Saya sudah melakukan seperti yang Anda sarankan,
outputnya seperti berikut ini :
-sh-2.05b$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.3.0 - Production on
17-FEB-2005 16:39:49
Copyright (c) 1991, 2002, Oracle Corporation. All
rights reserved.
Starting /oracle/d02/oracle/proddb/9.2.0/bin/tnslsnr:
please wait...
TNSLSNR for Linux: Version 9.2.0.3.0 - Production
System parameter file is
/oracle/d02/oracle/proddb/9.2.0/network/admin/PROD_oracle/listener.ora
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 16:39:49
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File
/oracle/d02/oracle/proddb/9.2.0/network/admin/PROD_oracle/listener.ora
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)))
Services Summary...
Service "PROD" has 1 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s)
for this service...
The command completed successfully
-sh-2.05b$ lsnrctl services
LSNRCTL for Linux: Version 9.2.0.3.0 - Production on
17-FEB-2005 16:39:53
Copyright (c) 1991, 2002, Oracle Corporation. All
rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
Services Summary...
Service "PROD" has 1 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s)
for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
Apakah output tersebut menandakan keberhasilan ? :D
Trus, saya coba jalankan sqlplus sebagai system :
-sh-2.05b$ sqlplus system/[EMAIL PROTECTED]
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Feb 17
16:43:33 2005
Copyright (c) 1982, 2002, Oracle Corporation. All
rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Terima kasih sebelumnya,
wass,
rab
--- Yulius Wibowo <[EMAIL PROTECTED]> wrote:
>
>
> 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
>
>
>
>
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
-----------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/
