Find the Quick General query as per your requirement Find the status of the database SQL> select status from v$instance; STATUS ———— OPEN SQL> select database_status from v$instance; DATABASE_STATUS —————– ACTIVE Or – To get… Read more..

Manually generating the AWR Report in oracle database SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql; Current Instance ~~~~~~~~~~~~~~~~ DB Id    DB Name      Inst Num Instance ———– ———— ——– ———— 4187434325 TESTDB              1 testdb Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ Would… Read more..

Change the existing DB Name to New DB NAME (SID) Before performing the below operation, safer side to take a full backup of the database using rman or dumpfile (expdp) Check the existing database name SQL> SELECT DBID,NAME,open_mode from v$database; DBID NAME      OPEN_MODE ——— ———… Read more..

Restrict a schema to drop a table from its own SQL> sho user USER is “SYS” SQL> create user mir identified by mir; User created. SQL> grant connect,resource to mir; Grant succeeded. SQL> connect mir/mir; Connected. SQL>  create table… Read more..

Restrict a user to drop from sys user Find the below tested & verified method SQL> Create user mir identified by mir; SQL> Grant connect, resource to mir; Now user have the privilege to connect & perform DDL,DML Etc Operation SQL> SHO USER USER is “SYS” Create… Read more..

Install SQL Instant client on Ubuntu Directly we don’t have the RPM/Zip Packages to install the instant client on Ubuntu, as we need to download the Linux Packages/Zip Files from the Oracle Site (http://www.oracle.com/technetwork/database/features/instant-client/index…)  And convert… Read more..