DATABASE

How to change the oracle database name using nid utility

  Follow below steps for changing the oracle database name using nid utility. We will change the database name from B2CRMD2 to S1D2ST. 1. Mount the database

2. Run the NID utility SYNTAX – nid sys/password@CURRENT_DBNAME DBNAME=NEW_DBNAME  

3. change the db_name parameter in the parameter file.

4. Rename the spfile to […]

How to find when a table was last modified in oracle

    If you want to find, when a table was last modified like insert,update ,delete, then use the dictionary table dba_tab_modifications. SCENARIO: 1. Insert into test data:

2. Check dba_tab_modification:

  As you can see, the dba_tab_modification is not showing any rows. Now you need to flush the info , to update […]

Enable archive log mode in Oracle RAC

            Follow below steps for enabling archive log mode in oracle RAC. 1. stop the database service.

2. start the database in mount state.

3. enable archive log mode.

4. Restart the database service (using srvctl)

5. set the archive destination to a ASM DISK

[…]

How to apply JVM patch in oracle 12c database

                  Below are the steps for applying JVM patch in oracle 12c database.   Steps 1 : Download the respective patch from oracle support  and unzip it in the server. unzip 21555660_hxuz.zip cd 21555660 Steps 2 : check the conflict against ORACLE_HOME  

  Step 3: […]

Create Incident package using ADRCI utility

     ADRCI is an command line oracle utility for managing diagnostic data. We can create incident packages and provide it to oracle support team for analysis. Follow below steps to create incident package. View the incidents:

Create incident package:  

How to Enable Trace for a listener

If you want to enable trace for a listener, Then follow below steps. Set current listener:  

Check status

Enable Trace:

Check the status again and the trace file location:

SEE- COMPLETE COLLECTION OF DATABASE MONITORING SCRIPTS

How to deinstall oracle client

              We can deinstall oracle client by runnning the deinstall tool provided by oracle client software. [oracle@bt-Prov-devst1 client_1]$ cd deinstall/ [oracle@bt-Prov-devst1 deinstall]$ ls -ltr total 92 -rwxr-xr-x. 1 oracle oinstall 32343 Dec 16 2009 sshUserSetup.sh -rw-r–r–. 1 oracle oinstall 409 Aug 18 2010 readme.txt -rw-r–r–. 1 oracle oinstall 3466 […]

How to find long running queries

Use below script to find the long running queries in your database.

SEE – COMPLETE COLLECTION OF DATABASE SCRIPTS

How to drop a private database link From sys

As we know, the private db_links can be dropped only by the owner of the database_link.  But you don’t have the password that db_link owner, then there is a workaround for that.

Now create one procedure under scoot user:

 

How to create database link without modifying the tnsnames.ora

            Suppose you want to create a database_link, but you don’t have the privilege to modify the tnsname entry. In that case you can create the database_link directly using tns description.

Much easier one is the below. No need to write the complete tns description also.

Page 4 of 512345
Skip to toolbar