解决Oracle数据库问题
解决centos系统中Oracle突然无法使用
出现的错误：
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
解决方法：
[[email protected]_0_6_centos ~]# id oracle
uid=1005(oracle) gid=1000(oinstall) groups=1000(oinstall),1001(dba),1003(asmdba)
[[email protected]_0_6_centos ~]# su - oracle
Last login: Tue Apr 2 17:13:59 CST 2019 on pts/0
[[email protected]_0_6_centos ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2019 17:21:57
Copyright © 1991, 2009, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
[[email protected]_0_6_centos ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2019 17:22:50
Copyright © 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 29-MAR-2019 20:01:39
Uptime 3 days 21 hr. 21 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /db/app/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File /db/app/oracle/diag/tnslsnr/VM_0_6_centos/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM_0_6_centos)(PORT=1521)))
Services Summary…
Service “DBUA0” has 1 instance(s).
Instance “DBUA0”, status BLOCKED, has 1 handler(s) for this service…
Service “ORCL” has 1 instance(s).
Instance “ORCL”, status READY, has 1 handler(s) for this service…
Service “orclXDB” has 1 instance(s).
Instance “ORCL”, status READY, has 1 handler(s) for this service…
The command completed successfully
[[email protected]_0_6_centos ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 2 17:23:23 2019
Copyright © 1982, 2009, Oracle. All rights reserved.
SQL> connect youc1/123456 as sysdba
Connected.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
之前给用户授权还不能执行，现在能执行了，数据库能正常打开了。