ora-12547 tns lost contact err [message #158434] |
Fri, 10 February 2006 16:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|