Re: Error ORA-12547 after patching Oracle 9i on Tru64

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 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
>
> How can I solve, please?
> Antonio

Hi,
I've checked my listener.ora, sqlnet.ora and tnsnames.ora.

> 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)
> )
> )

What do you think Can I do?

Thanks Received on Fri Oct 21 2005 - 05:06:39 CDT