Drop and recreate db console
I was trying to configure database console on one 10g db on Linux box.
When I configured the dbconsole, the db port is 1521 and the hostname used the real machine name. I was trying to change the port to 1545 and using the VIP name (easy to remember).
It seems kinda messed up. I want to drop it and then recreate it.
When I use
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos recreate
Is there any other better way to do this?
The error from the log file when I tried to drop:
Getting temporary tablespace from database...
[16-08-2007 11:14:19] Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))(CONNECT_DAT A=(SERVICE_NAME=SACTD))):
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)
The listener for SACTD is running like this.
(ADDRESS = (PROTOCOL = TCP)(HOST = sactd.ges.XXXX.com)(PORT = 1545))
the database isnt registered with the listener, or you are trying to connect to something that doesnt exist
When I started the dbconsole, the homepage shows, but when I try to login in as sys. Got error:
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))(CONNECT_DAT A=(SERVICE_NAME=SACTD)))
[orasactd tus1sacdbsdex01] /home/orasactd$ lsnrctl service SACTD
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 16-AUG-2007 14:57:28
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))
Service "SACTD.ges.XXXX.com" has 1 instance(s).
Instance "SACTD", status UNKNOWN, has 1 handler(s) for this service...
"DEDICATED" established:110 refused:0
The command completed successfully
NOTE, In error message. the service_name IS SACTD,
In the lsnrctl service , it shows the service_name is SACTD.ges.XXXX.com.
Does this matter?
If it does, how can I change the client’s service_name to match the listener ‘s ?
yes it matters because they are different - easier to change the listener / database
Click Here to Expand Forum to Full Width