Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 793
  • Last Modified:

DBCA not recognizing sid after running DBNEWID

Hi everyone,

I used  DBNEWID on an 11g database to rename the database.   Everything looks correct in environmental variables  ( sid, services, instance, global name  etc).   The database is working fine.  I even have the dbconsole up and running .   However, when I try to run DBCA  to reconfigure the database it does not recognize the new name ( sid) .  It only sees the old name .  I have not been able to find where  DBCA pulls the sid list from .  Any ideas would be appreciated.
0
jhucofsa
Asked:
jhucofsa
  • 2
1 Solution
 
ravindran_eeeCommented:
Check the values under in the following registry setting

\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEn

DBCA pulls information from /etc/oratab in UNIX systems. The above Windows registry location is where DBCA pulls information for Windows systems. Changes might be needed there to reflect the new SID
0
 
jhucofsaAuthor Commented:
THANK YOU!!.  That was it.  I hadn't set up auto start of oracle on this db yet so didn't notice that.  Thanks again!!
0
 
ravindran_eeeCommented:
Glad I could help!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now