Home » RDBMS Server » Performance Tuning » Error when I try to connect to a database using sqlplus
Error when I try to connect to a database using sqlplus [message #266608] Tue, 11 September 2007 04:04 Go to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Hi.I have a question. When this error appears?
SQL> CONNECT system/<password>@<sid> as sysdba;
ERROR:
ORA-12528: Message 12528 not found; product=RDBMS; facility=ORA
I have received this error because i have mest up the sids, now it is ok, but is there any other reason for getting this error? Thank you!

[Updated on: Tue, 11 September 2007 04:12]

Report message to a moderator

Re: Error when I try to connect to a database using sqlplus [message #266615 is a reply to message #266608] Tue, 11 September 2007 04:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12528: TNS:listener: all appropriate instances are blocking new connections 
Cause: All instances supporting the service requested by the 
       client reported that they were blocking the new 
       connections. This condition may be temporary, such as at 
       instance startup.
Action: Attempt the connection again. If error persists, then
        contact the administrator to check the status of the instances.

You are in restricted mode, you cannot remotely connect.
Use a local connection.

Regards
Michel

[Updated on: Tue, 11 September 2007 04:12]

Report message to a moderator

Re: Error when I try to connect to a database using sqlplus [message #266616 is a reply to message #266608] Tue, 11 September 2007 04:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Wait and see , If still remain, query

select status from v$instance;


as well as,
select logins from v$instance

[Updated on: Tue, 11 September 2007 04:18]

Report message to a moderator

Re: Error when I try to connect to a database using sqlplus [message #266618 is a reply to message #266608] Tue, 11 September 2007 04:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Michel , Don't take it otherwise, I about to got the chance to remind you about linesize. Laughing Laughing
Re: Error when I try to connect to a database using sqlplus [message #266621 is a reply to message #266618] Tue, 11 September 2007 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Too late! Laughing Laughing
Re: Error when I try to connect to a database using sqlplus [message #266652 is a reply to message #266621] Tue, 11 September 2007 05:36 Go to previous message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Thank you anyway. I have accidentally pressed "Edit" instead of quote. Thank you!
Previous Topic: a lot of rollback problem
Next Topic: Trying to tune a query.
Goto Forum:
  


Current Time: Mon Nov 04 17:18:25 CST 2024