Prev: Oracle - Column Order
Next: Error ORA-12547: TNS: lost contact
From: Antonio on 19 Oct 2005 07:00
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

From: Antonio on 21 Oct 2005 06:06
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

From: Laurenz Albe on 24 Oct 2005 06:38
Antonio <anto_sir(a)hotmail.com> wrote:
> 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?

Make sure that your server is up.
Look into the server trace files and alert logs.
Search Metalink.
Open a TAR.

Yours,
Laurenz Albe
 | 
Pages: 1
Prev: Oracle - Column Order
Next: Error ORA-12547: TNS: lost contact