Oracle Net-Problem in HOSTNAME

[bhattnirav]

Dear All,

I am configuring hostname method for testing.

step 1 :

Configure listner as per documentation.

Step 2 :

Configure sqlnet.ora file as per documentation

Step 3 :

add hostname entry in /etc/hosts file


I have also remove tnsnames.ora file.

Now when i tried to connect using following command I am getting ORA-12560: TNSrotocol adapter error.


sqlplus system/oracle@sales.us.acem.com


Thanks in advance,

Nirav

[vnktummala]

you can't connect with service name if you remove tnsnames.ora file. Replace the file and add proper entry in tnsnames.ora file. Test tnsping before trying to connect.

Thanks,

[bhattnirav]

In case of HOSTNAME method tnsnames.ora is required ?

Regards,

Nirav

[vnktummala]

If you are trying to connect with easy connect host name method then tnsnames is not required.

The below Oracle white paper might help you to connect to the database with out tnsnames configuration.

http://www.oracle.com/technology/pro...asyConnect.pdf

Thanks,

[bhattnirav]

Dear Vijay,

I am using Oracle 9i.

EZCONNECT is introduced in 10g.

Thanks and Regards,

Nirav

[vnktummala]

OUR mistake ... you have not mentioned & i have not asked ...

by the way, I would like to see the output of lsnrctl status command and the contents of sqlnet.ora file. Please post.

Thanks,

[bhattnirav]

Dear Vijay,

Sorry for late reply. Becasue we are doing testing on home PC.

Required file is attached. (listner,lisnstatus & sqlnet)

Thanks and Regards,

Nirav

[vnktummala]

lsnrctl status is showing the instance status UNKNOWN. Is the DB up and running?

Thanks,

[bhattnirav]

Yes database is up and running.