ORACLE DBA- Page 2 of 4 - Compitionpoint

Archives for ORACLE DBA - Page 2

DATABASE HANGS

compitionpoint December 7, 2020 DATABASE HANGS2020-09-12T11:34:09+00:00 Oracle database No Comment

ERROR MESSAGE IN ALERTLOG FILE: ORACLE Instance PROD – Archival Error ORA-16038: log 4 sequence# 9961 cannot be archived ORA-19502: write error on file “”, block number (block size=) ORA-00312:…

RMAN COLD BACKUP AND RESTORE

compitionpoint December 3, 2020 RMAN COLD BACKUP AND RESTORE2020-09-12T11:34:24+00:00 ORACLE DBA No Comment

Simple RMAN script to take cold database backup: For taking RMAN cold database backup, Database should be in mount status, Which can be noticed from below scipt. mkdir -p /BACKUP/PROD…

NID Utility in Oracle – RENAME DATABASE

compitionpoint December 2, 2020 NID Utility in Oracle – RENAME DATABASE2020-09-12T11:34:28+00:00 Oracle database No Comment

DBNEWID (NID) utility was introduced in Oracle 10g, Which can change the database identifier (DBID) and the database name (DBNAME). NID utility allows us to change Only DBID Only DBNAME…

ORA-27125: unable to create shared memory segment when run DBCA

compitionpoint November 28, 2020 ORA-27125: unable to create shared memory segment when run DBCA2020-09-12T11:34:46+00:00 Oracle database No Comment

I have installed 10gR2 on linux environment, When running DBCA it got filed with below error ORA-27125: unable to create shared memory segment SOLUTION: cd $ORACLE_HOME/bin mv oracle …

ORA-01031: insufficient privileges when connect as sysdba

compitionpoint November 26, 2020 ORA-01031: insufficient privileges when connect as sysdba2020-09-12T11:34:54+00:00 Oracle database No Comment

Not able to connect Oracle database, When issue command — > sqlplus “/ as sysdba” $ sqlplus “/ as sysdba” SQL*Plus: Release Production on Wed Jan 22 02:09:17 2014 Copyright…

Oracle ORA-21561 : OID generation failed

compitionpoint November 19, 2020 Oracle ORA-21561 : OID generation failed2020-09-12T11:32:29+00:00 Oracle database No Comment

Giving below error when trying to connect from Oracle client “ORA-21561 : OID generation failed” ERROR: sqlplus <test_user>/<test_user_password>@<database_name> xxxxx xxxx xxxx xxxx ERROR: ORA-21561 : OID generation failed Enter user-name:…

ORA-12537: TNS:connection closed

compitionpoint November 17, 2020 ORA-12537: TNS:connection closed2020-09-12T11:32:37+00:00 Oracle database No Comment

CHECK TABLESPACE SIZE, FREE AND USED SPACE

compitionpoint November 16, 2020 CHECK TABLESPACE SIZE, FREE AND USED SPACE2020-09-12T11:32:41+00:00 Oracle database No Comment

Below query is used for finding total tablespace size and free, used space. select tablespace_name, ROUND(bytes_free,2) free,ROUND(bytes_total-bytes_free,2) used, ROUND(bytes_total,2) total,perused from (select , ,, ROUND((100-(100*)),2) perused from (Select tablespace_name,sum(bytes)/1024/1024 bytes_free…

DROP DATABASE THROUGH RMAN

compitionpoint November 15, 2020 DROP DATABASE THROUGH RMAN2020-09-12T11:32:44+00:00 Oracle database No Comment

In Oracle Database 10gR1 Oracle introduced the RMAN command DROP DATABSE. This one simple statement has the ability to completely remove a database including all RMAN backups with the optional…

Drop temp tablespace taking long time

compitionpoint November 11, 2020 Drop temp tablespace taking long time2020-09-12T11:33:02+00:00 Oracle database No Comment

Created new temporary tablespace: CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE ‘/u01/oracle/#8217; SIZE 2g; Make new temporary tablespace as default: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01; Dropping old temporary tablespace, Which is…

123 4