Thinking Out Loud

May 10, 2012

ORA-12547: TNS:lost contact while connecting as sysdba

Filed under: 11g,oracle — mdinh @ 3:09 am

Connect as sysdba would take a long time and eventually fail with ORA-12547

> sysdba 
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 27 13:18:42 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact

> ipcs -a
 IPC status from as of Fri Apr 27 13:21:23 PDT 2012
 T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID STIME RTIME CTIME
 Message Queues:
 T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
 Shared Memory:
 m 8 0x759c6b1c --rw-rw---- oracle dba oracle dba 2 1895833600 7173 18689 13:21:21 13:21:21 14:56:53
 T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
 Semaphores:
 s 14 0xab90108c --ra-ra---- oracle dba oracle dba 154 11:23:28 14:56:55

> ipcrm -m 8
> ipcrm -s 14

> ipcs -a
IPC status from as of Fri Apr 27 13:22:15 PDT 2012
 T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID STIME RTIME CTIME
 Message Queues:
 T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
 Shared Memory:
 T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
 Semaphores:

REFERENCE:

connect / as sysdba Fails with Ora-12547 And Tns-12514 [ID 381566.1]

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: