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 27, 2011
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!!!
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!!!
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!!!
Subscribe to:
Posts (Atom)