ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
:::: Database sudah UP ?
Coba dicheck dulu ...
$ ps -ef | grep PROD
???
Bowo
--- In [email protected], `newbies` <[EMAIL PROTECTED]>
wrote:
> 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.o
ra
> 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.o
ra
> 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/
