Home » RDBMS Server » Server Administration » Sql plus login issue
Sql plus login issue [message #141248] Fri, 07 October 2005 14:34 Go to next message
jking
Messages: 5
Registered: October 2005
Location: The Woodlands, Texas
Junior Member
I am trying to login to SQLplus and I keep getting this error, can anyone help?

(ORA-27101: shared memory realm does not exist)

It's strange because yesterday I was able to login just fine.

Report message to a moderator

SQL Plus Login issue [message #141250 is a reply to message #141248] Fri, 07 October 2005 14:58 Go to previous messageGo to next message
jking
Messages: 5
Registered: October 2005
Location: The Woodlands, Texas
Junior Member
No Message Body

Report message to a moderator

Re: SQL Plus Login issue [message #141252 is a reply to message #141250] Fri, 07 October 2005 15:36 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member
if you are connecting to a remote database ..then ensure that you have configured the tns entry for the remote db ..

if you are connecting to a local database (database in your machine itself ) ..then try to connect without giving any tns entry .

-Sai Jeedigunta

Report message to a moderator

Re: SQLplus error when trying to login [message #141253 is a reply to message #141248] Fri, 07 October 2005 15:40 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member
Already replied to your prev message ..
go ahead and start the db ..

sqlplus /nolog
conn /as sysdba
startup ..

Quote:

PS: Assuming that you have a database in your local machine ..



-Sai Jeedigunta

Report message to a moderator

Re: SQLplus error when trying to login [message #141893 is a reply to message #141253] Wed, 12 October 2005 13:24 Go to previous message
jking
Messages: 5
Registered: October 2005
Location: The Woodlands, Texas
Junior Member
DB is located on a server.

The DB is up and running. I can login in using OEM and SQL Navigator.

Report message to a moderator

Previous Topic: Oracle9i Release 2 download
Next Topic: Archive related
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 26 07:49:13 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.