Saya jalankan lsnctrl
---------------------
LSNRCTL> start
Starting /oracle/d02/oracle/proddb/9.2.0/bin/tnslsnr:
please wait...
TNSLSNR for Linux: Version 9.2.0.3.0 - Production
Log messages written to
/oracle/d02/oracle/proddb/9.2.0/network/log/listener.log
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.accounting.fe.ui.ac.id)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version
9.2.0.3.0 - Production
Start Date 17-FEB-2005 14:29:52
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File
/oracle/d02/oracle/proddb/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.accounting.fe.ui.ac.id)(PORT=1521)))
The listener supports no services
The command completed successfully
Isi file listener.log
---------------------
TNSLSNR for Linux: Version 9.2.0.3.0 - Production on
17-FEB-2005 14:30:32
Copyright (c) 1991, 2002, Oracle Corporation. All
rights reserved.
Log messages written to
/oracle/d02/oracle/proddb/9.2.0/network/log/listener.log
Trace information written to
/oracle/d02/oracle/proddb/9.2.0/network/trace/listener.trc
Trace level is currently 0
Started with pid=28579
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.accounting.fe.ui.ac.id)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [*
SID] * RETURN CODE
17-FEB-2005 14:30:32 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=oracle.accounting.fe.ui.ac.id)(USER=applmgr))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092864))
* status * 0
17-FEB-2005 14:30:33 *
(CONNECT_DATA=(SID=PROD)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=)))
*
(ADDRESS=(PROTOCOL=tcp)(HOST=207.197.17.9)(PORT=53403))
* establish * PROD * 12505
TNS-12505: TNS:listener could not resolve SID given in
connect descriptor
17-FEB-2005 14:30:34 *
(CONNECT_DATA=(SID=PROD)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=)))
*
(ADDRESS=(PROTOCOL=tcp)(HOST=207.197.17.9)(PORT=53404))
* establish * PROD * 12505
TNS-12505: TNS:listener could not resolve SID given in
connect descriptor
17-FEB-2005 14:30:35 *
(CONNECT_DATA=(SID=PROD)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=)))
*
(ADDRESS=(PROTOCOL=tcp)(HOST=207.197.17.9)(PORT=53408))
* establish * PROD * 12505
TNS-12505: TNS:listener could not resolve SID given in
connect descriptor
Rekan2, ada yang tau gimana ngesolve errornya?
Wass,
rab
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/