Tuesday, July 26, 2011

Reinstalling OCM thows ORA-20007: ORA-31003: Parent /sys/acls/ already contains child entry

›
On the process of reinstalling OCM; ORACLE_OCM user was dropped. After running setupCCR the setup of installCCRSQL.sh was failing with below...
Friday, July 22, 2011

OCM Configuration fails "The ORACLE_HOME does not contain Java"

›
While trying to install Oracle's Configuration Manager application following error issued: [oracle@LAB bin]$ ./setupCCR -s T...
Friday, March 11, 2011

Shrink SQL Server Log File

›
Below are simple steps to shrink transaction log files in SQLSERVER. sp_helpdb 'DATABASE_NAME' Truncate the log by chan...
Thursday, February 10, 2011

Cloning a database manually

›
Using the following steps one can clone a database manually. In the following example PRD represents the source and DEV represents targe...

Writing a message to the alert log for testing

›
SQL> execute sys.dbms_system.ksdwrt(2,('ORA-07445: Nadvi is testing AlertLog Monitoring')); Now check the alert log. [oracl...

Changing SQL*Plus prompt

›
Below is the straight forward syntax according to your choice. SQL> set sqlprompt 'nadvi@TESTDATABASE> ' nadvi@TESTDATABAS...

Generate DDL for all Database Links & Indexes

›
Below script is going to generate DDL for DBLINK with values instead of password. So that you can create links without knowing the passwo...

Script to find Oracle Bind Variables

›
Simple script to find bind variables with or without sql_id. select sql_id, t.sql_text SQL_TEXT, b.name BIND_NAME, b.value_string BIND_S...
Wednesday, February 09, 2011

Cloning Oracle Database Software

›
Cloning an 11gR2 Oracle Home from source machine PROD to target machine TEST. On source (PROD): ORACLE_HOME location is : /u01/app/ora...
Tuesday, February 08, 2011

Oracle password with @ or Special characters

›
First let's see what it looks like from within sqlplus: sqlplus /nolog SQL> alter user scott identified by "scott@test...
4 comments: