Posted by Mir Sayeed Hassan on October 4th, 2017
SQL> select status from v$instance; STATUS ------------ OPEN
SQL> select database_status from v$instance; DATABASE_STATUS ----------------- ACTIVE
Posted in MISCELLANEOUS | Comments Off on Find the Quick General query as per your requirement
Posted by Mir Sayeed Hassan on October 3rd, 2017
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..
Posted in DBA Administration | Comments Off on Manually generate AWR Report in oracle database
Posted by Mir Sayeed Hassan on October 3rd, 2017
SQL> SELECT DBID,NAME,open_mode from v$database; DBID NAME OPEN_MODE --------- ---------...Read more..
Posted in DBA Administration | Comments Off on Change the existing DB Name to New DB NAME (SID)
Posted by Mir Sayeed Hassan on October 3rd, 2017
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..
Posted in DBA Administration | Comments Off on Restrict a schema to drop a table from its own
Posted by Mir Sayeed Hassan on October 3rd, 2017
SQL> Create user mir identified by mir;
SQL> Grant connect, resource to mir;
SQL> SHO USER USER is "SYS"
Posted in DBA Administration | Comments Off on Restrict a user to drop from sys user
Posted by Mir Sayeed Hassan on October 3rd, 2017
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...
Posted in DB Install & Create | Comments Off on Install SQL Instant client on Ubuntu