Ed Chen Logic

How to Install Oracle Database 11.2.0.1 on Enterprise Linux 5 - 2 of 4 - Software Installation

by Ed Chen
April 24, 2022April 22, 2022

B. Oracle Software Installation Initiate a new oracle session. [oracle@primary01 ~]$ cd sources/database/ [oracle@primary01 database]$ ./runInstaller We are ready for next phase, Oracle listener installation.

How to Install Oracle Database 11.2.0.1 on Enterprise Linux 5 - 1 of 4 - Server Preparation

by Ed Chen
April 24, 2022April 27, 2022

There're 4 phases that we install Oracle database 11.2.0.1 on CentOS 5.7. Server Preparation Oracle Software Installation Oracle Listener Installation Oracle Database Creation A. Server… Read More »

How to Resolve Error in invoking target 'install' of makefile ins_ctx.mk

by Ed Chen
April 23, 2022April 21, 2022

ins_ctx.mk Met this error about makefile ins_ctx.mk during the installation of Oracle 11.2 on Enterprise Linux 7: The pieces of error message are: Error in… Read More »

How to Resolve ASMCMD-9463: operation failed due to lack of write permissions

by Ed Chen
April 22, 2022May 18, 2022

ASMCMD-9463 Tried to copy a data file out of ASM, but it failed with ASMCMD-9463. [grid@primary01 grid]$ asmcmd cp +DATA/ORCLCDB/ORCLPDB/example_01.dbf /backup/example_01.dbf ASMCMD-9463: operation failed due… Read More »

How to Resolve GPG key retrieval failed: [Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle"

by Ed Chen
April 21, 2022April 18, 2022

GPG key retrieval failed Tried to install some packages through yum, but it failed with "GPG key retrieval failed". This is because yum repository cannot… Read More »

How to Install Oracle Yum in CentOS 7

by Ed Chen
April 20, 2022April 11, 2022

Here are steps to install Oracle yum respository to CentOS 7. 1. Download Oracle Linux 7 Public Yum Repository First of all, you should make… Read More »

How to Add a Group to User

by Ed Chen
April 19, 2022April 18, 2022

Let's print current id of the user. [root@primary01 ~]# id oracle uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba) In this case, we would like to add a new group… Read More »

How to Get DDL of Table

by Ed Chen
April 18, 2022May 26, 2022

To retrieve the definition (Data Definition Language, DDL) of a table, we use the function DBMS_METADATA.GET_DDL to make it. Let's see an example. SQL> set… Read More »

How to Resolve ORA-32005: error while parsing size specification

by Ed Chen
April 15, 2022April 20, 2022

ORA-32005 When I tried to increase the size of Fast Recovery Area (FRA) from 1TB to 1.5TB, it failed with ORA-32005. SQL> show parameter db_recovery_file_dest_size… Read More »

How to Resolve ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

by Ed Chen
April 13, 2022April 20, 2022

ORA-01035 Tried to connect to a database in restricted mode, but it failed with ORA-01035. C:\Users\ed>sqlplus hr/hr@ORCL ... ERROR: ORA-01035: ORACLE only available to users… Read More »