I need to download oracle client database, must I download 32bit or 64bit? And what does this mean?
I seen it from another thread in the forum. However my client database are not suppose to have a database but to access into the server database. Anyone can assist me please !
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?
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"
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?
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.