Coba gunakan STATIC registration utk SID-nya
dengan menambahkan di listener.ora
(/oracle/d02/oracle/proddb/9.2.0/network/admin/listener.ora)
#--------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PROD)
(ORACLE_HOME = /oracle/d02/oracle/proddb/9.2.0)
(SID_NAME = PROD)
)
)
#--------------------------
Save ! lalu restart listenernya ...
$ lsnrctl stop
$ lsnrctl start
Verify dengan :
$ lsnrctl services
Pastikan, ada service dengan nama "PROD"
Bowo
--- In [email protected], `newbies` <[EMAIL PROTECTED]>
wrote:
> 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/
