每次 linux 系统 reboot 后,连接数据库orcl都报 ORA-01034: ORACLE not available
错误原因: 没有开启oracle服务
可按照下面的步驟操作(oracle用户下):
lsnrctl start
sqlplus / as sysdba
sql> startup
但这个还是不能随linux自动启动,可按照下面的步驟操作
1. 修改oratab (root用户执行)
/etc/oratab的配置格式如下:
$ORACLE_SID:$ORACLE_HOME:Y
2. 测试dbstart, dbstop(oracle用户执行)
设置ORACLE_HOME, ORACLE_HOME_LISTENER
执行dbstart, dbshut脚本测试能否启停Oracle实例和监听器
dbstart $ORACLE_HOME
dbshut $ORACLE_HOME
3. 配置rc.local (root用户执行)
vi /etc/rc.d/rc.local
su - oracle -lc "/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbstart $ORACLE_HOME"
这里要注意的是dbstart一定要写全路径,否则有可能无法正确调用。
至此,Oracle随Linux自动启动设置完毕!
相关推荐
ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3 ORA-27301: OS ...
用Oracle DBCA 工具创建新数据库
Oracle报错ORA-12516 TNS:listener could not find available handler with matching protocol stack
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 进程 ID: 0 会话 ID: 0 序列号: 0
Oracle数据库因断电导致异常的解决方案,如:数据库服务开着,监听正常,但是连接数据库不成功,或者连接上无法查询数据,报错:ORA-01034: ORACLE not available
8_____vi /home/oracle/ora/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora 9_____/opt/lampp/lampp start 10_____/opt/lampp/lampp restart 11_____/opt/lampp/lampp stop 帮助 [root@...
BBED is not available in 11g but you can still link it after getting the following files from any previous version like 10gR2. Copy $ORA10g_HOME/rdbms/lib/ssbbded.o to $ORA11g_HOME/rdbms/lib Copy $...
D:\oracle\product\10.2.0\db_1\Network\Admin\tnsnames.ora Using Home: OraDb10g_home1 DLL: D:\oracle\product\10.2.0\db_1\bin\oci.dll OCI: Version 10.2 Oracle Database 10g Enterprise Edition ...
D:\app\orcl\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora Using Home: instantclient_12_1 DLL: D:\app\instantclient_12_1\oci.dll OCI: version 11.1 Oracle Database 12c Enterprise Edition ...
- Bug # 4918539: ORA-ORA-06502 or ORA-01460 may occurs if a procedure is executed through the Run PL/SQL dialog box and a string with multibyte characters is assigned to one of the parameters. ...
Viewing job classes on Oracle12c could lead to "ORA-01036: illegal variable name/number" PL/SQL Beautifier did not format FORALL/MERGE loop correctly Test Window now processes trailing slash of a PL/...
Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) were not available in the 64 bit version The “Close unused ...
Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) were not available in the 64 bit version The “Close unused ...