| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Renamed db refuses SQL*Net connection
Hello all,
Env: OSF 3.2, RDBMS 7.3.2.1, SQL*Net 2.3.2.1
My database has just been renamed by recreating the controlfile. Now I've found that not only is the global_name not reflecting the new database name, now I can't connect to it via sql*net. I can connect to new database using a direct connection "sqlplus /" and when querying v$database I can see the new database name. But when I do "sqlplus /@new" it fails with ORA-00472: PMON process terminated with error. This error also occurs on any client that wishes to connect to the new db view sql*net. No, we're not using Oracle Names, just plain old sql*net.
Doing a "ps-fe | grep pmon" shows that pmon is certainly alive. And there are no trace files generated, or any entries in the alert.log.
I've restarted the listener (with the new name) and bounced the database a couple of times already. TNSNAMES.ORA has also been changed. So the question for you guys out there is: after renaming a database, did you have problems connecting via sql*net?
Thanks.
Leng.
 |
 |