Friday, May 27, 2011

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORA11G'
you need to check your tnsnames.ora file.In this above example.You can see "LISTENER_ORA11G" that is actually a service name from tnsnames.ora file.Check that service name configuration in tnsnames.ora.

Cheers.!!!

Friday, May 20, 2011

ORA-00845: MEMORY_TARGET not supported on this system

Got this error...?


This type of error depends on your server memory allocated to your database.You need to change your memory_target.

Alter system set memory_target= 2000M scope=both;



cheers!!!

Monday, May 9, 2011

The OracleDBConsolev8it3 service terminated with service-specific error 1 (0x1).

Got this error?

The OracleDBConsolev8it3 service terminated with service-specific error 1 (0x1).



emca -config dbcontrol db

SEVERE: Failed to unlock all EM-related accounts


Could not complete the configuration. Refer to the log file for more details

It`s a common error. you need to drop dbconsole first.after that you can recreate the same


1)DROP DBCONSOLE first

emca -deconfig dbcontrol db -repos drop

then

2)CREATE NEW REPOSITORY

emca -repos create

emca -config dbcontrol db


It will take sometime to create new repository.Also you can see the path of EM at end of the execution.

Restart EM Console


emctl stop dbconsole db

emctl start dbconsole db



Cheers!!!