Find DB tier details from R 12 application login.

How to find the oracle R12 application database running  hostname, port number,service name from oracle application front end .

If R12 oracle application installed on multi-node we will find the database server details from application front end ..

Iam have crossed this situation, we having only access to oracle application and have access to database apps user only but we dnt know the database tier details someone is supporting for database.

while executing scripts given wrong password for apps user, now apps user account is locked.

We need to unlock the apps user account for that we need to connect to database system user.

To find the database tier details , login to application "http://.......com:8007/" sysadmin/password.

In Home page - click on "About this page" available at left side bottom - Click on "Page Context" tab in about oracle application page.

Here you will get the database tier details,

hostname :
port number:1527.
SID   :DEV

Now we connected to the database using this details and unlocked the apps user account. FYI. If system/sys account password is Default as "manager" then only you can connect to database. Best Regards.