Author Archives: compitionpoint - Page 4
NID Utility in Oracle – RENAME DATABASE
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
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
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…
Create New Application user from existing user in EBS R12
We can create new application user from existing user with same responsibility, Which can be achieved from FNDLOAD utility. Here I would like to create new user with name ‘APPADMIN’…
REP-0004: Warning: Unable to open user preference file
Symptoms: All concurrent requests that run REPORTS are printing the following warning in the request log. “REP-0004: Warning: Unable to open user preference file” Your local (customized) Oracle Reports preference…
Oracle ORA-21561 : OID generation failed
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
Giving below error when trying to connect oracle user ERROR: Sqlplus scott/tiger@PROD SQL*Plus: Release – Production on Thu Oct 16 15:06:46 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved.…
CHECK TABLESPACE SIZE, FREE AND USED SPACE
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
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…
How to compile forms in R12
we have to use frmcmp(Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But in 11i we need to use f60gen to compile forms and libraries which…