Home » RDBMS Server » Server Administration » Getting Ora-03113 if we specify the SID
Getting Ora-03113 if we specify the SID [message #54083] Mon, 28 October 2002 22:28 Go to next message
benoy
Messages: 1
Registered: October 2002
Junior Member
Hi,

I have installed Oracle 9i server on win2k.
If I try connecting by specifying the sid
eg- system/manager@sid
I get Ora-03113
If I dont specify it connects.
What could be the possible solution.

ALso please note that I created the database manually,after database configuration assistant gave errors ,during installation.

Thanks in advance

Benoy

Report message to a moderator

Re: Getting Ora-03113 if we specify the SID [message #54099 is a reply to message #54083] Tue, 29 October 2002 10:08 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Try this:

c:>set oracle_sid=sid
c:>sqlplus /nolog
SQL>conn system/manager@sid

Also check your TNS service name for sid in tnsnames.ora file.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: password file "pwd got corrupted"
Next Topic: "segmentation fault" on RedHat 7.2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:46:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.