Oracle Net-Problem in HOSTNAME
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: TNS rotocol adapter error.
sqlplus system/oracle@sales.us.acem.com
Thanks in advance,
Nirav
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
In case of HOSTNAME method tnsnames.ora is required ?
Regards,
Nirav
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Dear Vijay,
I am using Oracle 9i.
EZCONNECT is introduced in 10g.
Thanks and Regards,
Nirav
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
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
Attached Files
lsnrctl status is showing the instance status UNKNOWN. Is the DB up and running?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Yes database is up and running.
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width