From: Antonio on
Hi all,
I' ve patched Oracle 9.2.0.1.0 on Tru64 with patchset for Oracle
9.2.0.6.


After I have installed it launching the runInstaller in tha Patch
directory, i try to connect to sqlplus for the post installation tasks.

But appears the error:

ORA-12547: TNS:lost contact

Here is my tnsnames.ora:

> ORA1."host"=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL =TCP)(HOST = "my host name")(PORT=1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME= ORA1)
> )
> )


> INST1_HTTP."host"=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL =TCP)(HOST = "my host name")(PORT=1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME= MODOSE)
> (PRESENTATION = http://HRService)
> )
> )


> EXTPROC_CONNECTION_DATA."host"=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL =TCP)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )

From: Antonio on

Antonio ha scritto:

> Hi all,
> I' ve patched Oracle 9.2.0.1.0 on Tru64 with patchset for Oracle
> 9.2.0.6.
>
>
> After I have installed it launching the runInstaller in tha Patch
> directory, i try to connect to sqlplus for the post installation tasks.
>
> But appears the error:
>
> ORA-12547: TNS:lost contact
>
> Here is my tnsnames.ora:
>
> > ORA1."host"=
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS= (PROTOCOL =TCP)(HOST = "my host name")(PORT=1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME= ORA1)
> > )
> > )
>
>
> > INST1_HTTP."host"=
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS= (PROTOCOL =TCP)(HOST = "my host name")(PORT=1521))
> > )
> > (CONNECT_DATA =
> > (SERVER = SHARED)
> > (SERVICE_NAME= MODOSE)
> > (PRESENTATION = http://HRService)
> > )
> > )
>
>
> > EXTPROC_CONNECTION_DATA."host"=
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS= (PROTOCOL =TCP)(KEY = EXTPROC))
> > )
> > (CONNECT_DATA =
> > (SID = PLSExtProc)
> > (PRESENTATION = RO)
> > )
> > )


Wha do you think can I do to solve??

Thank to all.

From: Laurenz Albe on
Antonio <anto_sir(a)hotmail.com> wrote:
> Antonio ha scritto:
[...]
> Wha do you think can I do to solve??

Repeatedly posting the same question and following up on your own postings
is definitely not the best way to solve your problem.

Yours,
Laurenz Albe