Oracle Client connection problem [message #124566] |
Mon, 20 June 2005 04:31 |
nelnel
Messages: 5 Registered: June 2005 Location: HongKOng
|
Junior Member |
|
|
I am doing a school project. Try to make a database application program in linux to connect remote oracle database server(LAN).
Actually, i am the newbie of the oracle database. I have downloaded the oracle 9i release 2 from Oracle.com. And i have installed the Oracle 9i client to the linux( including the client program and the Oracle Enterprise Manager). But how could i connect the remote server??
Where can i specify the IP, Server Name and User/PWD of the Oracle Database Server in the Oracle 9i Client Config.? I try to ue SQLPLUS to connect, but i can't find the place to input such info.
Also, i have installed Oracle Enterprise Manager, is it the GUI interface in Xwindow? How could i startup of it?
I have read the Oracle Admintration Guide and Installation Guide, but still don't have idea of the above questions...
Thx for ur help!!
|
|
|
|
Re: Oracle Client connection problem [message #124681 is a reply to message #124566] |
Mon, 20 June 2005 21:17 |
nelnel
Messages: 5 Registered: June 2005 Location: HongKOng
|
Junior Member |
|
|
Thx for ur kindly help!!
i have created the tnsnames.ora and the sqlnet.ora under the dir /$ORACLE_HOME/network/admin/ but still can't connect the server by SQLPLUS.
it shows the error :
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
my tnsnames.ora:
SPK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dn2)(PORT = 1521))
(CONNECT_DATA = (SID = sp01))
)
what is the problem of it??
|
|
|
Re: Oracle Client connection problem [message #124684 is a reply to message #124566] |
Mon, 20 June 2005 21:26 |
nelnel
Messages: 5 Registered: June 2005 Location: HongKOng
|
Junior Member |
|
|
Also, does the tnsnames.ora file really need to be Generated by Oracle configuration tools? Can i created it by hand?
in fact, i can't set it by configuration tools during the installation process. I create it by hand only.....
thx for ur help~~
|
|
|
|
|