OraFAQ Forum: Networking and Gateways » ora-12547 tns lost contact err

Home » RDBMS Server » Networking and Gateways » ora-12547 tns lost contact err

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-12547 tns lost contact err [message #158434]

Fri, 10 February 2006 16:39

trcdutt
Messages: 1
Registered: February 2006
Location: Southfield

Junior Member

Hi,
I am getting the following error, when try to login.
SQL> connect / as sysdba
ERROR:
ORA-12547: TNS:lost contact.

I installed Oracle 10g R1 and I am trying to create a database.

The following is my .profile:

CLASSPATH=/usr/opt/java131/lib/classes.zip
DDIRECT_BASE=/var/opt/DAU200/connect
DISPLAY=10.1.10.111:0.0
GWSOURCE=telnet
HOME=/usr/users/oracle/oracle
IFS=

LD_LIBRARY_PATH=/oracle01/app/oracle/product/10.1.0.2/lib:/var/opt/DAU200/connec
t/lib
LOGNAME=oracle
MAIL=/usr/spool/mail/oracle
MAILCHECK=600
ODBCINI=/var/opt/DAU200/connect/odbc.ini
ORACLE_BASE=/oracle01/app/oracle
ORACLE_DOC=/oracle01/app/oracle/doc
ORACLE_HOME=/oracle01/app/oracle/product/10.1.0.2
ORACLE_SID=OSI
ORA_NLS33=/oracle01/app/oracle/product/10.1.0.2/ocommon/nls/admin/data
PATH=/oracle01/app/oracle/product/10.1.0.2:/oracle01/app/oracle/product/10.1.0.2
/bin:/usr/users/oracle/oracle/bin:/usr/bin:.:/usr/CUP/abl:/usr/bin/X11:/usr/sbin
:/etc:/usr/local/bin:/oracle01/app/oracle/product/10.1.0.2/OPatch
PS1=TestAlpha.com>
PS2=>
SHELL=/bin/sh
TERM=ansi
TMP=/oracle01/tmp
TMPDIR=/oracle01/tmp
TNS_ADMIN=/oracle01/app/oracle/product/10.1.0.2/network/admin
USER=oracle

The following is my sqlnet.ora file

NAMES.DEFAULT_DOMAIN = com

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

The following is my listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TestAlpha.com)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = TestAlpha.com)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle01/app/oracle/product/10.1.0.2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = OSI.TestAlpha.com)
(ORACLE_HOME = /oracle01/app/oracle/product/10.1.0.2)
(SID_NAME = OSI)
)
)

Any kind of help is appreciated. I am using HP Tru64 5.1A.

Thanks
Ramesh

[Updated on: Fri, 10 February 2006 16:45]

Report message to a moderator