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 […]

“ORA-01034: ORACLE not available” resolved

Summary Encountered problem cannot login Oracle by login name and password “system/oracle”, resolved this issue by changed the kernal parameter kernel.sem in sysctl.conf. Problem Encountered ORA-01034 and ORA-27101 as below, [tom@ocp ~]$ [tom@ocp ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on 星期四 12月 20 20:42:24 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> […]

AWS Ubuntu Oracle SQL Developer install and connect

SQL Developer is the GUI software to connect Oracle DB, installed on AWS Ubuntu and tested the connection to RDS. 1, Download the Oracle SQL Developer 4.1.3 through this Link. 2, Installing Java 8 on Ubuntu sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java8-installer java -version java version “1.8.0_91” Java(TM) SE Runtime Environment (build […]