Month: January 2020

ORA-01017: Invalid Username/Password; Logon Denied

While you try to connect to database then most probably you will find the ORA-01017 error. Problem Statement ORA-01017: Invalid Username/Password; Logon Denied Solution Check if you have set up the right ORACLE_HOME and ORACLE_SID Check the entry for your tnsnames.ora and listener.ora file. there should not be any typo error. If you set SEC_CASE_SENSITIVE_LOGON …

ORA-01017: Invalid Username/Password; Logon Denied Read More »

ORA-00604, ORA-01882 While Connecting With SQL Developer

Sometime when you try to connect to oracle database using sql developer tool, you will see the below error message Problem Statement An error was encountered performing the requested operations: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found OO604. 00000 – “error occurred at recursive SQL level %s” *Cause: An …

ORA-00604, ORA-01882 While Connecting With SQL Developer Read More »

ORA-12154: TNS could not resolve service name specified

Sometimes you will see the error message related to tns. Error message will be like this. ORA-12154: TNS could not resolve service name specified Solutions Check if your listener is up and running Check if listener is listening to database services. Look for tnsnames.ora file. database entry needs to be available there Syntax error in …

ORA-12154: TNS could not resolve service name specified Read More »

How To Create Pluggable Database In Oracle 12c

In this blog, We will see the command to create the pluggable database in oracle 12c multitenent architecture. Create the required directory Put the source database in closed status Fire the following command to create new pluggable database Open the newly created pluggable database Create pluggable database using seed database create pluggable database PDBCDB admin …

How To Create Pluggable Database In Oracle 12c Read More »

Oracle Dataguard Important Command

In this blog, We will look some important oracle dataguard command.Following command will be useful for dataguard administration Check the Dataguard database status on primary and standby select status,instance_name,database_role,protection_mode from v$database,v$instance; Query to apply redo log on standby. Following command useful for real time apply ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE; To …

Oracle Dataguard Important Command Read More »