How to connect Oracle client 9i to Linux.- Appl Database?
I installed 11i Application on Linux. I would like use Oracle client-9i to use OEM to connect 11i Application Databse from WindowsXP to Linux server. I did install the Oracle client, when Net Configuration time gives error, not connecting to the Appl DB in Linux.
I did trail with another computer which is installed Oracle 91 DB is working fine.
How to solve it?
How to connect Oracle client 9i to Linux.- Appl DB
Hi
Did you try connecting directly to your linux box through VNC viewer . Just double check both Linux Server and cleint 9i <Oracle_home> \network\admin\tnsnames.ora has exactly same entries.
After matching all entries in both files trying using "tnsping <database name> from your client machine.
If still you are getting any error please feel free to post it here.
Thanks
Amir
Did you try connecting directly to your linux box through VNC viewer . Just double check both Linux Server and cleint 9i <Oracle_home> \network\admin\tnsnames.ora has exactly same entries.
After matching all entries in both files trying using "tnsping <database name> from your client machine.
If still you are getting any error please feel free to post it here.
Thanks
Amir
Hi,
Thank you for the reply.
Still not working (connecting) the Oracle 9i client, sqlplus, Core FTP, SQL Developer, SQL tools.
The VNC, PUTTY (telnet, FTP), and telnet is woring from PC, and also VNC viewr working from Linux.
The tnsname.ora is OK in the PC.
When try to test from the Net8 Eassy configaration it gives error:
Connecting....
The test did not succeed.
ORA-12570: TNS:packet reader failure
There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
Please give a solution.
Thanks
Thank you for the reply.
Still not working (connecting) the Oracle 9i client, sqlplus, Core FTP, SQL Developer, SQL tools.
The VNC, PUTTY (telnet, FTP), and telnet is woring from PC, and also VNC viewr working from Linux.
The tnsname.ora is OK in the PC.
When try to test from the Net8 Eassy configaration it gives error:
Connecting....
The test did not succeed.
ORA-12570: TNS:packet reader failure
There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
Please give a solution.
Thanks
Hi,
Seems you don't have document Oracle Applications 11i, R12 - Administration - 4.5 which you can get from http://www.erpstuff.com/forum.asp?FORUM_ID=26 as you have to allow Oracle clients to connect. The steps are provided in the document. Thanks
Seems you don't have document Oracle Applications 11i, R12 - Administration - 4.5 which you can get from http://www.erpstuff.com/forum.asp?FORUM_ID=26 as you have to allow Oracle clients to connect. The steps are provided in the document. Thanks
-
- Posts: 3
- Joined: Thu Jul 05, 2007 3:33 am
- Location: Egypt
Hi,
ensure that the service name in your client (winXP) is configured correctly.
You have to check the host name and the port used by the 11i DB (may be not 1521 as usual) you can get this information from the tnsnames.ora form the 11i server.
also on the 11i server check the sqlnet.ora.
Thanks,
Mohamed
ensure that the service name in your client (winXP) is configured correctly.
You have to check the host name and the port used by the 11i DB (may be not 1521 as usual) you can get this information from the tnsnames.ora form the 11i server.
also on the 11i server check the sqlnet.ora.
Thanks,
Mohamed
Dear
I have observed, when you configureing network servive through Net Configuration Assistant, if your service is giving error that time, problem is only there. There must be connection test sucessfully if your service created correctly. revise serivce request steps carefully.
I am working in linux environment, and our our team working in window environment i have not seen any type of error from O.S.
Regards,
I have observed, when you configureing network servive through Net Configuration Assistant, if your service is giving error that time, problem is only there. There must be connection test sucessfully if your service created correctly. revise serivce request steps carefully.
I am working in linux environment, and our our team working in window environment i have not seen any type of error from O.S.
Regards,
Who is online
Users browsing this forum: No registered users and 0 guests