当数据库为归档模式时, 只能连接DBA用户,且连接上的是个空实例(即数据库还不能够使用)。连接普通用户时,会出现如下错误:(也就是没连上)( ORA-01034 -Oraclenot available ORA-27101 - shared memory realm does not exist 进程ID:0 会话ID:0 序列号:0 如下是解决思路:(将归档模式关闭,改为非归档模式) 1...
ora11g -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/11.2.0/dbhome_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/u01/app/oracle/product/11.2.0/dbhome_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.he...
ora11g -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/11.2.0/dbhome_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/u01/app/oracle/product/11.2.0/dbhome_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.he...
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> alter session set container=pn1; alter session set container=pn1 * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 SQL> 1. 2. 3. 4. 5. 6...
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SHOW CON_NAME ERROR: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 SP2-1545: This feature requires Database availability. ...
12.1.0.2 on AIX 7.1 TL4 SP1 (or AIX 7.2 TL0), database shutdown fails with ORA-00449: ORA-00449: background process 'MMON' unexpectedly terminated with error 448 Database alert.log: Shutting down instance (immediate) Stopping background process SMCO ...
INSTANCE_NAME---ora12cSQL>show con_name;CON_NAME---CDB$ROOTSQL>shutdown immediate;Database closed.Database dismounted.ORACLEinstance shut down.SQL>alter sessionsetcontainer=PDB1;alter sessionsetcontainer=PDB1*ERRORat line1:ORA-01034:ORACLEnot available ProcessID:0SessionID:0Serial number:0 从...
【已解决】ORA-01034: ORACLE not available ORA-27101 解决方法: 打开命令行输入数据库的dba账户 回车再输入startup,回车.这步是启动oracle服务。如果startup启动被告知已经启动了,可以先输入shutdownimmediate;等shutdown结束之后,再输入startup。问题解决; ...
Now If I try to do a shutdown immediate, there is a message:ORA-01034: ORACLE not available, but the istance oracle is not down.How can I restart the Server ?Thanks Attilio Solved! Go to Solution. 0 Kudos Reply 6 REPLIES Jean-Luc Oudart Honored Contributor 12-01-2005 11:...
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> alter session set container=pn1; alter session set container=pn1 * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 ...