Hi,
You have to change in listener.ora also; stop and start the listener to
solve this.
Thanks
Solange Januzi
-----Mensagem original-----
De: Mahendra Kumar.T
[mailto:oracledba-ezmlmshield-x51098840.[Email address protected]
Enviada em: terça-feira, 27 de fevereiro de 2007 08:07
Para: LazyDBA Discussion
Assunto: Re: change in computer name
Hi,
You have to change in listener.ora also.
Thanks.
T.Mahendra kumar
Remya P. Namboothiri wrote:
> Hi All,
>
>
>
> I have changed the name of the system where my database is created.
> Now I am not able to connect to my database getting the error 'TNS: No
> listener.
>
>
>
> I have replaced the same in tnsnames.ora file. Can any body help me
> to solve this...
>
>
>
> Thanks in advance,
>
> Remya.
>
>
>
>
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this e-mail
or its contents to any other person and any such actions are unlawful. This
e-mail may contain viruses. Infosys has taken every reasonable precaution to
minimize this risk, but is not liable for any damage you may sustain as a
result of any virus in this e-mail. You should carry out your own virus
checks before opening the e-mail or attachment. Infosys reserves the right
to monitor and review the content of all messages sent to or from this
e-mail address. Messages sent to or from this e-mail address may be stored
on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
> a dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
>
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page