-sh-2.05b$ ps -ef | grep PROD applmgr 19776 1 0 13:31 ? 00:00:00 /oracle/d01/oracle/prodora/8.0.6/bin/tnslsnr APPS_PROD -inherit applmgr 19907 1 0 13:31 pts/1 00:00:00 f60srvm em oracle_9000_PROD port 9000 mode socket exe f60webmx applmgr 19909 19907 0 13:31 pts/1 00:00:00 f60webmx webfile=5,0,oracle_9000_PROD applmgr 19967 1 0 13:31 pts/1 00:00:00 rwmts60 name=REP60_PROD applmgr 19969 19967 0 13:31 pts/1 00:00:00 rwmts60 name=REP60_PROD applmgr 19970 19969 0 13:31 pts/1 00:00:00 rwmts60 name=REP60_PROD applmgr 19971 19969 0 13:31 pts/1 00:00:00 rwmts60 name=REP60_PROD applmgr 19972 19969 0 13:31 pts/1 00:00:00 rwmts60 name=REP60_PROD applmgr 19973 19969 0 13:31 pts/1 00:00:00 rwmts60 name=REP60_PROD applmgr 19974 19969 0 13:31 pts/1 00:00:00 rwmts60 name=REP60_PROD applmgr 19975 19969 0 13:31 pts/1 00:00:00 rwmts60 name=REP60_PROD applmgr 11910 6603 0 17:29 pts/1 00:00:00 grep PROD
--- Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > > 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 > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.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/
