On server side + SQL*Plus tool!
connect sys/pwd @sid as sysdba
shutdown immediate or abort
ORA-12528: TNS:listener: all appropriate instances are blocking new connection
Use lsnrctl status - blockage - stop service + restart
same error message.
--> listerner.ora --> dynamic to static
Result, most backup strategies cannot be done, as 10g not in mounted state!!!! Any ideas, with thanks.
February 10, 2005 6:11 AM
March 23, 2005 6:14 PM