help for oracle [message #72732] |
Tue, 07 October 2003 23:27 |
nagesh Kotekar
Messages: 4 Registered: October 2003
|
Junior Member |
|
|
HI,
I am nagsh kotekar from india. I am looking for oracle 7.3 help on novell 4.11 can you help me. i want clear my following point.
(1) I am not able connect from client (98) oracle database (novell 4.11) . i did net easy with spx service.
(2) how i check database working or not on server and tell me how to confugure neteasy on server (novell 4.11)
Pl help me out,
Nagesh kotekar
|
|
|
Re: help for oracle [message #72733 is a reply to message #72732] |
Wed, 08 October 2003 07:51 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
first, you are still living with a very old version of oracle. try to get upgraded. Becuase
-> you more advanced versions
-> availablity of TechSupport. In event of any catastropic failure, oracle corp will not support ur database.
[i]
(1) I am not able connect from client (98) oracle database (novell 4.11) . i did net easy with spx service.
[/i]
what kind of error are u getting? post the exact error message and ur sqlnet.ora, tnsnames.ora , listner.ora.
is the listener configured properly, up and available?
are the spx protocol services enabled? is there any preference for using spx?
[i]
(2) how i check database working or not on server and tell me how to confugure neteasy on server (novell 4.11)[/i]
do the following in the database server.
make sure the datbase is up and available.
use svrmgr ( or sqldba?..i forgot i beleive sqldba is for oracle versions less than 7.3 , for 7.3 it is svrmgr ) to login to database
and start it manually ( in case it is down).
use
lsnrctl status < your_listener_name > -- to check the status of listener.
do the following in your client
net easy config assitant is a gui tool.
select your protocol, host,sid,port and create a service(connect string).
or simply edit your tnsnames.ora
|
|
|
Re: help for oracle [message #72737 is a reply to message #72733] |
Fri, 10 October 2003 01:33 |
nagesh Kotekar
Messages: 4 Registered: October 2003
|
Junior Member |
|
|
Hi,
pl give me details of spx connectivity format in tnslister.ora and its possible to connect oracle 7.3 (novell 4.11) connect from windows 98 with tcp/ip support.
|
|
|