Connect user with “@” Password using sqlplus Verify the telnet with specific port as shown below  C:\Users>telnet 192.168.1.1 1521 Or  [oracle@localhost ~]$ telnet 192.168.1.1 1521 Trying 192.168.1.1… Connected to 192.168.1.1 Escape character is ‘^]’  Try to connect… 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..

Configure the Multiple Listener Port in Oracle DB & Tested in our Environment Configure Port 1521 – Default port Configure Port 1522   – Port Added by request from client $cd $ORACLE_HOME/network/admin/vi listener.ora LISTENER1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL… Read more..