Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renamed db refuses SQL*Net connection
Leng Kaing wrote:
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.
> -------
> Leng Kaing - leng_at_comsense.com
> Common Sense Consulting
> Tel: +61-3-9885-5829 Fax: +61-3-9885-0116
> VOUG: http://dingo.vut.edu.au/voug
Leng,
Just a possibility that you might have missed this -
alter database rename global_name to <new_db_name.ur_domain_name>;
Try this.
Manoj Appully Received on Tue May 20 1997 - 00:00:00 CDT