【ORACLE】ORA-01034ORACLE not available
2024-08-29 13:54:26
供稿：網友
剛裝上的Oracle9i,上次還能用呢,這次突然用不了.[oracle@R39i oracle]$ sqlplus scott/tigerSQL*Plus: Release 9.2.0.4.0 - PRoduction on Mon Nov 24 11:06:50 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existlinux Error: 2: No such file or directory[root@R39i root]# id oracleuid=500(oracle) gid=501(dba) groups=501(dba)[root@R39i root]# su - oracle[oracle@R39i oracle]$ lsnrctl startLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 24-NOV-2008 10:57:29Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Starting /oracle/product/9i/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 9.2.0.4.0 - ProductionSystem parameter file is /oracle/product/9i/network/admin/listener.oraLog messages written to /oracle/product/9i/network/log/listener.logError listening on: (DESCRipTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))TNS-12542: TNS:address already in useTNS-12560: TNS:protocol adapter errorTNS-00512: Address already in use Linux Error: 98: Address already in useListener failed to start. See the error message(s) above...[oracle@R39i oracle]$ lsnrctl statusLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 24-NOV-2008 11:21:13Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))STATUS of the LISTENER==============================================[oracle@R39i oracle]$ lsnrctl statusLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 24-NOV-2008 11:21:13Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 9.2.0.4.0 - ProductionStart Date 24-NOV-2008 10:52:27Uptime 0 days 0 hr. 28 min. 45 secTrace Level offSecurity OFFSNMP OFFListener Parameter File /oracle/product/9i/network/admin/listener.oraListener Log File /oracle/product/9i/network/log/listener.logListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=R39i)(PORT=1521)))Services Summary...Service "PLSExtProc" has 1 instance(s).Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "mydata" has 1 instance(s).Instance "mydata", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully呵呵，原來監聽已經啟動了.[oracle@R39i oracle]$ sqlplus /nologSQL*Plus: Release 9.2.0.4.0 - Production on Mon Nov 24 12:01:37 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> connect /as sysdbaConnected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 122754448 bytesFixed Size 451984 bytesVariable Size 88080384 bytesDatabase Buffers 33554432 bytesRedo Buffers 667648 bytesDatabase mounted.Database opened.數據庫就可以用了。總結，1,數據庫沒有打開時，其它用戶是聯不上的。2,如果用sys也打不開數據庫，則可能是壞境變量的事了。可用下面的方法來檢查,看是否和你預想的一樣。env |grep ORACLE
