Oracle DBA Error, during upgrade.

[Former Member]

Hi,

after upgrading Oracle DBA with the last patch available and executing the migration and configuration functionality from windows progams the activity stops with the following error:

2008-04-30 12:41:01,218 [HttpRequestHandler-12231451] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:

ORA-12526, TNS:listener: all appropriate instances are in restricted mode

The Connection descriptor used by the client was:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sapsrv)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

2008-04-30 12:41:01,234 [HttpRequestHandler-12231451] ERROR eml.OMSHandshake getParameterFromDB.402 - Listener refused the connection with the following error:

ORA-12526, TNS:listener: all appropriate instances are in restricted mode

The Connection descriptor used by the client was:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sapsrv)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

2008-04-30 12:41:01,234 [HttpRequestHandler-12231451] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://sapsrv:3938/emd/main)(ERROR = INTERNAL_ERROR)

2008-04-30 12:41:01,343 [HttpRequestHandler-12743356] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:

ORA-12526, TNS:listener: all appropriate instances are in restricted mode

The Connection descriptor used by the client was:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sapsrv)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

2008-04-30 12:41:01,359 [HttpRequestHandler-12743356] ERROR eml.OMSHandshake getParameterFromDB.402 - Listener refused the connection with the following error:

ORA-12526, TNS:listener: all appropriate instances are in restricted mode

The Connection descriptor used by the client was:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sapsrv)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

2008-04-30 12:41:01,359 [HttpRequestHandler-12743356] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://sapsrv:3938/emd/main)(ERROR = INTERNAL_ERROR)

???

[Former Member]

HI,

execute following from command prompt

lsnrctl status

What is the output?

If it is in restrictive mode then you need to change mode to normal

regards,

kaushal

[Former Member]

Hi,

after executing from command promt lsnrctl status there is the restricted mode.

How can I change it ?

Best regards

[Former Member]

Hi,

connect as sysdba

and execute

alter system disable restricted session.

regards,

kaushal

[Former Member]

Hi,

could you please indicate how to do that by command prompt?

Regards

[Former Member]

Hi,

on SQL command prompt

connect \as sysdba

after connecting to database

execute following query

alter system disable restricted session.

regards,

kaushal