This content has been marked as final. Show 32 replies
For the Oracle client on Windows, only 32bit client is supported.
When I start the setup of the oracle client, there will be 4 option for me to choose.
-(forgotten what is it)
May I know as a client, which one shall I install and why is that so?
Please assist me and let me know please. Thanks
If you only need to access the DB server, just choose the "Client" version. If you need to configure an Application/Batch Server will would need to install additional administration tools like Net Config. Assitant then you should choose "Administrator" or "Custom"
Edited by: Andres_Caro on Sep 20, 2012 10:09 AM
As what I know, client need a copy of server TNSNAMES.ora file but do we need also need to have server listener.ora file as well? If the server side there are a few TNSNAMES.ora files and listener.ora files, do I need to copy all of the above or just one of the file will do? When I install instant client, there isn't any network>admin in the home, how and where shall I place the TNS file? Please assist me.
The listener is a process running onto the server used to... listen on a port for incoming request from a client.
As of the client side, a tnsnames.ora file is required to specify a service_name registered onto the remote server, a host of the database and a port the listener on the server is listenning.
Regarding the client installation type you need to have, "instant client" is certainly not the one you want to have (this is the bar minimum - AppServer needs more such as net config), but rather <s>"runtime client" (if not admin).</s> admin installation.
Please find out more :
correction : that's a bit of surprise to me, I was sure to have already tested a runtime client, anyway it seems only the admin client installation is supported, please read note #660972.1
Edited by: N Gasparotto on Sep 21, 2012 9:59 AM
So you mean that when I install the setup, I have to choose the administrator radio button? And as for the ODBC, do I need to include anything? But there isn't any oracle in my driver, what shall I do?
Yes. I'm not sure about your doubts, it should be a staightforward installation.
But do I need to put the oracle into the ODBC driver? But I couldn't find it in my ODBC driver.
The client setup is just Next, Next type of setup. The only important detail is to choose administrator when asked to.
You don't need to setup anything on ODBC. Editing TNSNAMES.ORA is enough.
If it is Windows, make sure the bin directory of the correct ORACLE_HOME is on the PATH environment variable and appears first than other Oracle installations that you may have on the same server.
I managed to connect to the server database using this command: sqlplus psowner/abab@L31004.citi.sit:1521/orcl
however, I tried to connect it through the sqlplus command using the same id and password, I cannot connect to it. What is the reason?
And I want to know does client need to connect to data mover?
When I sign in to Data Mover they give me this error:
File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 12514 - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
Can anyone please assist me?
Please, paste your tnsnames.ora of the client.
This is the TNSNAMES.ora file from client. I copied it from the server.
(ADDRESS = (PROTOCOL = TCP)(HOST = L31004.citi.sit)(PORT = 1521))
(SID = ORCL)
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.citi.sit)
From the client :
From the server :
ping L31004.citi.sit tnsping ORCL
however, it's far to be a Peoplesoft issue by now
Edited by: N Gasparotto on Sep 24, 2012 11:22 AM
But do I need to sign into data mover?