1) I have created a new database called 'oct'.
The database was opened, however, I was not able to log into 'database' 'OCT' using sqlplus.
a)Which user id and password, should I use to get into this new data base?.
2). As I could not get into 'oct', I tried connecting back using the default 'ORCL' database after changing the ORACLE_SID to ORCL and all other parameters being same.
Now, I am unable to get into even SVRMGR, Oracle gives
ORA-12203: TNS:unable to connect to destination.
I have checked up the listner(It's running) and all other files are in its place.
You could connect as:
su - oracle
SVRMGR> connect internal;
you could try as well:
But the problem is, I am not able to get into svrmgr.
when I give svrmgr30,
I immediately get TNS: error.
Can you please help me in starting one of the servers
The ORACLE_SID is ORCL and listener is running
Before you start Server Manager issue at command prompt:
SET ORACLE_SID = ORCL
Start Server Manager and connect.
Click Here to Expand Forum to Full Width