I had one instance running on a server dev1, now this database crashed and was temporarily brought up to get exports etc, I had to create a new instance in the same server cdev and I exported the data from dev1 to cdev.
Then I dropped the instance dev1 and renamed cdev to dev1.
Here's the confusion, when I created cdev I created a new service for it thru oradim with internal password as oracle. The old instance dev1 had a different password-devil.
Now after I renamed this instance to the old instance both the passwords work on dev1.
Which sid should I get rid of/delete from oradim, cdev or dev1. I am not very familiar with windows so please help.
Thanx in advance. Hope I didn't confuse too much.
Click Here to Expand Forum to Full Width