BlogNow | Learn Technology with us | Best Training Center

Oracle Databse Monitoring tool | OEM Introduction

Leave a Comment / Oracle DBA / By ankushthavali

Oracle enterprise manager (OEM) is monitoring tool for Oracle database server. Oracle enterprise manager monitor to Oracle database, Oracle database server, agent, listener and all the targets which are registered with the Oracle enterprise manager. Oracle enterprise manager tool is provided by the Oracle itself and having more demand for the Oracle database administration. Following …

Oracle Databse Monitoring tool | OEM Introduction Read More »

Autostart pluggable database when CDB starts

Leave a Comment / Oracle DBA / By ankushthavali

In this blog, We will see how to auto start the pluggable database when CDB get started. Before Version 12.1.0.2 version We had to create the trigger to start the pdb’s automatically but starting from 12.1.0.2 there is new feature to save the state of PDB’S. Connect to pluggable database and start the PDB’S . …

Autostart pluggable database when CDB starts Read More »

Start and Stop All Pluggable Database

Leave a Comment / Oracle DBA / By ankushthavali

There is way to start and stop all pluggable database. you can also use except keyword if you want to skip or add pluggable database. STOP all pluggable database. SQL>ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE; Pluggable database altered. START All pluggable database SQL> ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE; Pluggable database altered. EXCEPT Keyword …

Start and Stop All Pluggable Database Read More »

PayKun Payment Gateway

Leave a Comment / Technology Blog / By ankushthavali

PayKun is a global payment gateway service that provides a secure and safe transaction between buyer and seller. We provide a customized solution to our merchants as per their requirements. There are more than 10,000+ happy merchants whom we have helped to grow their business because your customer will get multiple payment options to make payment …

PayKun Payment Gateway Read More »

ORA-01017: Invalid Username/Password; Logon Denied

Leave a Comment / Oracle DBA / By ankushthavali

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

Leave a Comment / Oracle DBA / By ankushthavali

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-12560: TNS:protocol adaptor error

Leave a Comment / Oracle DBA / By ankushthavali

This is the common error in oracle database related to oracle database connection Problem Statement ORA-12560: TNS:protocol adaptor error Solutions Check if your database is up and running Make sure listener is up and running Crosscheck if your ORACLE_HOME and ORACLE_SID set up properly if you are using windows server then go to services.msc and …

ORA-12560: TNS:protocol adaptor error Read More »

ora-01722 invalid number in oracle

Leave a Comment / Oracle DBA / By ankushthavali

In this blog, We will try to understand how to resolve the ORA-01722 error. Problem Statement ora-01722 invalid number in oracle Solution First describe the table and check for data types by using desc command Check the type of data you are inserting and type of column An ORA-01722 error occurs when an attempt is …

ora-01722 invalid number in oracle Read More »

ora-03113 end-of-file on communication channel

Leave a Comment / Oracle DBA / By ankushthavali

This is common error which will occur on oracle database. ora-03113 end-of-file on communication channel Following are the reason to get the error Database goes down abruptly Server goes down and there is no communication with server Solutions Check the alert log file. reason can be anything and accordingly you need to act If you …

ora-03113 end-of-file on communication channel Read More »

ORA-12154: TNS could not resolve service name specified

Leave a Comment / Oracle DBA / By ankushthavali

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

Leave a Comment / Oracle DBA / By ankushthavali

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 »