Basic Unix command for Oracle DBA

1) Finding the present working directory : pwdThis command will list the present working directoryexample $ pwd2) create the directory : mkdirexample $ mkdir data -> This command will create a directory... Read more »

Drop datafile which is already removed Locally – ORA-01157,ORA-01110

I got the below issue while starting the database. Below issue occurred as I have deleted the datafiles from server level and not I am unable to start the datafile.SQL> startupORACLE instance... Read more »

Change Timezone in Oracle Database for CDB and PDB

In this blog, We are going to see how to change DBTime zone in multitenent database. Oracle recommends setting the database time zone to UTC (0:00), as no conversion of time zones... Read more »

Silent Oracle 12C Database Installation

Oracle 12C Database installationResponse file location/data/database/response/dbca.rsp/data/database/response/netca.rsp/data/app/oracle/product/12.2.0.1/assistants/dbca/dbca.rspvi /tmp/dbca.rsp to install databasegdbName=prim2sid=primcreateAsContainerDatabase=truenumberOfPDBs=1pdbName=pdbprim2pdbAdminPassword=Oracle1234templateName=General_Purpose.dbcsysPassword=Oracle1234systemPassword=Oracle1234emConfiguration=DBEXPRESSemExpressPort=5500dbsnmpPassword=Oracle1234datafileDestination=/data/app/oracle/oradatarecoveryAreaDestination=/data/app/oracle/flash_recovery_areastorageType=FScharacterSet=AL32UTF8nationalCharacterSet=AL16UTF16listeners=LISTENERsampleSchema=truedatabaseType=OLTPautomaticMemoryManagement=TRUEmemoryPercentage=40./dbca -silent -createDatabase -responseFile /tmp/dbca.rsp Read more »

Change Protection Mode in Oracle 12C Dataguard

Primary SideSQL> select status,instance_name,database_role,protection_mode from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE PROTECTION_MODE------ ------------- ------------- --------------------OPEN prim PRIMARY MAXIMUM PERFORMANCEStandby SideSQL> select status,instance_name,database_role,protection_mode from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE PROTECTION_MODE------ ------------- ------------- --------------------OPEN stand STANDBY MAXIMUM... Read more »

Startup and Shutdown Container and Pluggable database

Startup Container database SQL> select name, open_mode, cdb from v$database; NAME OPEN_MODE CDB --------- -------------------- --- NONCDB12 READ WRITE NO <----- SQL> create user raj identified by raj default tablespace users temporary... Read more »

🔥DHAMAKA OFFERS 🔥100 Free Courses By LinkedIn & Microsoft🔥💥🔥

I am going to show you top microsoft and linkedin free courses.Please watch below video and subscribe to my channel. Read more »

Oracle 12C User Management

In Oracle 12C , there are two types of user. Common user Local User COMMON USER: 1.A common user is a DB user, which work perform an activity in all the containers... Read more »

Oracle Database Real time Training on YouTube

If you are looking for real time database training then please contact me. Email – ankush.thavali@gmail.com Mob No – +91 9960262955 Read more »

Disable firewall in Oracle Linux 7

Following are the command to stop firewall in oracle linux 7. Command to stop firewall but will start again after reboot. [root@prim ~]# systemctl stop firewalld Command to stop firewall after reboot... Read more »