Oracle database - Compitionpoint

Archives for Oracle database

ORA-01031: insufficient privileges when connect as sysdba

compitionpoint January 18, 2021 ORA-01031: insufficient privileges when connect as sysdba2020-09-12T11:37:16+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…

LOGIN PAGE SHOWS BLANK IN Oracle Applications R12

compitionpoint January 17, 2021 LOGIN PAGE SHOWS BLANK IN Oracle Applications R122020-09-12T11:37:20+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 …

SIMPLE DATABASE CREATION

compitionpoint January 14, 2021 SIMPLE DATABASE CREATION2020-09-12T11:37:33+00:00 Oracle database No Comment

CREATION OF DATABASE IN COMMAND LINE: 1) Set Environment file: #su – oracle $pwd export ORACLE_SID=PROD export ORACLE_HOME=/u01/app/oracle/ export PATH=$ORACLE_HOME/bin:$PATH 2) Create Parameter file: $cd $ORACLE_HOME/dbs $ vi $ORACLE_HOME/ db_name…

TRACE IN ORACLE DATABASE

compitionpoint December 22, 2020 TRACE IN ORACLE DATABASE2020-09-12T11:36:09+00:00 Oracle database No Comment

Current session trace: NORMAL TRACE: alter session set tracefile_identifer=’XXX’; — trace identifier alter session set sql_trace = true; FULL LEVEL TARCE with WAIT and BIND : alter session set tracefile_identifer=’XXX’;…

DATABASE SIZE (datafiles + tempfiles + redologfiles)

compitionpoint December 15, 2020 DATABASE SIZE (datafiles + tempfiles + redologfiles)2020-09-12T11:36:37+00:00 Oracle database No Comment

To get accurate size of the database, We have to combined the sizes of all datafiles, tempfiles and redologfiles. select round ((++)/1024/1024/1024,2) “DB_size_in_GB” from ( select sum(bytes) data_size from dba_data_files…

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:…

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:…

12 3