Oracle

There are 7 posts filed in Oracle (this is page 1 of 1).

ORA-29701 / CRS-4124 Oracle ASM start failed

Encountered CRS-4124, the OHASD cannot be started, it shows as below: [bob@ocp ~]$ crsctl start has CRS-4124: 未能启动 Oracle High Availability Services。 CRS-4000: 命令 Start 失败, 或已完成但出现错误。 Cannot startup the instance: [bob@ocp ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.1.0 Production on 星期三 8月 28 13:56:52 2019 Copyright (c) 1982, 2009, Oracle. All rights reserved. […]

ORA-19602: 无法按 NOARCHIVELOG 模式备份或复制活动文件

使用非存档模式在RMAN下备份数据文件，遇到ORA-19602错误。错误如下： [tom@ocp ~]$ rman target / 恢复管理器: Release 11.2.0.1.0 – Production on 星期二 8月 20 14:01:47 2019 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. 已连接到目标数据库: ORCL (DBID=1523101237, 未打开) RMAN> backup datafile 5 format ‘/u01/backup/xxxx’; 启动 backup 于 20-8月 -19 使用目标数据库控制文件替代恢复目录 分配的通道: ORA_DISK_1 通道 ORA_DISK_1: SID=10 设备类型=DISK 通道 ORA_DISK_1: 正在启动全部数据文件备份集 通道 ORA_DISK_1: […]

Oracle under Linux – emctl start dbconsole command failed

After certain time of the testing on the Oracle 11.2.0.1.0 on Linux, encountered below errors. [tom@ocp ~]$ emctl start dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved. https://ocp:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 11g Database Control ………………………………………………………………………………… failed. —————————————————————— Logs are generated in directory /u01/app/tom/product/11.2.0/dbhome_1/ocp_orcl/sysman/log Check […]

Oracle SHARED mode server confiuguration error ORA-12523

Summary Configure the Shared mode for Oracle connection, it failed and returned ORA-12523, found out it is mandatory to configure local listener. 本地监听的配置是必须的。 Configure Shared server mode ‘listener.ora’ was configured as below, LISTENER3 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ocp)(PORT = 1523)) ) LISTENER2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST […]