ORA-00304: Requested Instance_Number is Busy 错误解析 1. 错误代码 ORA-00304 的含义 ORA-00304 错误表示“请求的实例号(instance_number)正忙”。这通常发生在使用 Oracle 的并行服务器(Oracle Parallel Server, OPS)或 Oracle Real Application Clusters (RAC) 环境中,当尝试连接到某个特定的实例号,但该实例...
SQL> connect sys as sysdbaEnter password: Connected to an idle instance.可是此时,数据库是open状态,用toad等其他工具是可以连接的。如果此时startup库,会得到如下错误:ORA-00304: requested INSTANCE_NUMBER is busy折腾了很久,决定向服务公司求助。最后得到的结果是,连接方式错误,必须用如下方式方可连接:[oracle@...
[oracle@rac1 ~]$ sqlplus / nolog SQL> connect sys as sysdba Enter password: Connected to an idle instance. 可是此时,数据库是open状态,用toad等其他工具是可以连接的。 如果此时startup库,会得到如下错误: ORA-00304: requested INSTANCE_NUMBER is busy 折腾了很久,决定向服务公司求助。 最后得到的结果...
最近在vmware中实验RAC,启动一个节点再启动另外一个后报错如下 ORA-00304"requested INSTANCE_NUMBER is busy" 当节点RAC01启动后就不能启动RAC02 或者当RAC02启动后就不能启动RAC01 反正同时只能启动一个,否则就报00304的错误,或者伴随有3113的错误.经多次google,终于发现问题 1.修改instance_number参数. alter sys...
requested INSTANCE_NUMBER is busy Cause An instance tried to start by using a value of the initialization parameter INSTANCE_NUMBER that is already in use. Action Either specify another INSTANCE_NUMBER, shut down the running instance with this number wait for instance recovery to complete on the ...
ORA-00304: requested INSTANCE_NUMBER is busy Pfile(initdupdb.ora) has: instance_name='dupdb' db_name='utld' CAUSE As the database UTLD exists in two nodes , Oracle believes you want to add the instance in the other node. SOLUTION ...
Oracle Database - Enterprise Edition - Version 9.2.0.6 and later: ORA-00304: requested INSTANCE_NUMBER is busy Creating a Duplicate for Standby with RMAN
ORA-00304: requested INSTANCE_NUMBER is busy [grid@testrac1 ~]$ crs_stat -t -v Name Type R/RA F/FT Target State Host --- ora.DATADG.dg ora...up.type 0/5 0/ ONLINE ONLINE testrac1 ora.GRIDDG.dg ora...up.type 0/5 0/ ONLINE ONLINE testrac1 ora...ER.lsnr ora...er....
4.到目标主机解tar tar -xzvf Prod.tar.gz 5.创建审计目录 mkdir -p /u01/app/oracle/admin/PROD/adump 6.启动数据库 startup 但是启动的时候报一个这种错误: ORA-00304"requested INSTANCE_NUMBER is busy" USER (ospid: 19198): terminating the instance due to error 304 ...
Connected to an idle instance. SQL> startup ORA-00304: requested INSTANCE_NUMBER is busy [grid@testrac1 ~]$ crs_stat -t -v Name Type R/RA F/FT Target State Host --- ora.DATADG.dg ora...up.type 0/5 0/ ONLINE ONLINE testrac1 ora.GRIDDG.dg ora...up.type 0/...