|
|
|
|
| Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386785 is a reply to message #386751] |
Tue, 17 February 2009 00:32   |
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
|
Senior Member |
|
|
@venumsc123,
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Error.
Before following the below steps type services.msc and stop and strt the listener
Them try to connect to the database if not then try this,
Hope the below steps help you,
Open command Prompt and type cmd it will pop up you to the dos window type
--sqlplus sys/test as sysdba
--ShutDown Immediate
--Startup mount
--Alter Database open
Thanks and Regards,
Hammer
|
|
|
|
|
|
| Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386800 is a reply to message #386792] |
Tue, 17 February 2009 00:55 |
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
|
Senior Member |
|
|
@venumsc2006,
Can you post the exact error which hits your screen.Copy and paste the commands what you have typed in the cmd prompt.
Ok I think you have done like the below steps.
SQL> CONN SYS/TEST@ORCL AS SYSDBA
Connected.
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
SQL> EXIT;
Just type exit..
Follow the below steps which will work
C:\Documents and Settings\Administrator>SQLPLUS SYS/TEST AS SYSDBA
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Jan 6 12:41:59 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> SHUTDOWN IMMEDIATE;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Then issue Alter Database open.
Thanks and Regards,
Hammer.
[Updated on: Tue, 17 February 2009 01:03] Report message to a moderator |
|
|
|
|
|
|
|
| Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386814 is a reply to message #386812] |
Tue, 17 February 2009 01:31 |
venumsc2006
Messages: 7
Registered: February 2009
|
Junior Member |
|
|
Hi Hammer,
Even though, I am getting the same error. I pasted the result here.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\gfic-idc>sqlplus sys as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Feb 17 12:56:59 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
With the Partitioning, OLAP and Data Mining options
SQL> Shutdown Immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> Startup mount
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
SQL>
Thanx
Venu
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
