Category Archives: Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Many companies has implemented their data in Oracle. Most of them are mission critical. So Oracle database concept need to be very clear to manage these mission critical things. At the same time Oracle database needs to deliver high performance also. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Below section I have tried to present all the important features in Oracle Database management

How to Solve ORA-00942 table or view does not exist

ORA-00942 is one of the many errors which Oracle developer ,DBA often gets. Lets first look at the OERR output Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required … Continue reading How to Solve ORA-00942 table or view does not exist »

ORA-01017: invalid username/password; logon denied Tips

Last updated on July 13th, 2018 at 05:20 amORA-01017  is one of the common error seen in PLSQL programs. Here is what documentation says about this error Here are the checklist to run to resolve the ORA-01017 error The main issue with an ORA-01017 error is an invalid user ID and passwords combination.  You have to make sure ,you are entering the right password Incase … Continue reading ORA-01017: invalid username/password; logon denied Tips »

How to resolve ORA-29913 with external tables

Last updated on July 13th, 2018 at 09:00 amORA-29913 is one of the common error when working with external tables in Oracle database. We would be looking at various ways the error can be produced and what can be done to resolve the error External File not found or permission incorrect SQL> select * from Scott.example_external_table; select * from example_external_table * ERROR at line 1: … Continue reading How to resolve ORA-29913 with external tables »

How to resolve ORA-00904: invalid identifier

ORA-00904: invalid identifier is one of the common error seen. Reference: Oracle documentation One of the most common cause of this error Invalid identifier means the column name entered is either missing or invalid. It also Some time comes  when you used reserved word in Oracle database. Check List to resolve the ORA-00904 error  It comes when you put extra comma in the create table … Continue reading How to resolve ORA-00904: invalid identifier »

Useful Unix/Linux command for Oracle DBA

Last updated on June 21st, 2018 at 07:03 am Oracle DBA need to operate on Unix/Linux/Solaris/AIX Operating system. He has to locate various file, process, kill session ,clear directories, schedule cron and various other activities. Here in this article I am trying to give some Useful Unix command for Oracle DBA  to help them in day-to-day activities.These same commands are applicable for Linux also. Hope you … Continue reading Useful Unix/Linux command for Oracle DBA »

ORA-00257: archiver error. Connect internal only, until freed.

Last updated on July 13th, 2018 at 09:38 amORA-00257 is one of the commonest error in Oracle DBA life. He/She often has to deal with it.Database almost got frozen because of it and all transaction get stopped .Let us see how to deal with ORA-00257 error Error Message   ORA-00257: archiver error. Connect internal only, until freed. As per The oerr ORA-00257 error means ORA-00257: … Continue reading ORA-00257: archiver error. Connect internal only, until freed. »

How to resolve ORA-06512 at line num

Last updated on July 12th, 2018 at 06:14 pmDescription of ORA-06512 ORA-06512  is one of the common error seen in PLSQL programs. Here is what documentation says about this error Reference :Oracle documentation Explanation of the ORA-06512 error: Error Ora-06512 means the backtrace message as the stack is being unwound by unhandled exceptions in your PLSQL code. This is a catch-all error for All PLSQL … Continue reading How to resolve ORA-06512 at line num »

ORA-00911: invalid character Common Issues and Resolution

Last updated on July 13th, 2018 at 02:48 pmAs per OERR,ORA-00911: invalid character Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by double quotes may contain any character other than a double quote. Alternative quotes (q’#…#’) cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, … Continue reading ORA-00911: invalid character Common Issues and Resolution »

How to remotely clone a PDB or non-CDB in Oracle Database 12.1

Many times, we may need to copy the remote PDB to Local PDB for testing purpose. The case would be copying Production PDB to Development PDB box. Some times , we may want to migrate the non-CDB to PDB to make sure Multitenant features in the Oracle database Restriction for doing this 1)The default tablespaces for each common user in the remote PDB must exist … Continue reading How to remotely clone a PDB or non-CDB in Oracle Database 12.1 »

Hot PDB cloning in Oracle database 12.2

In Oracle database release 12.1, in order to clone a PDB, The source PDB must be quiescent(read only mode) for the duration of the clone operation. So it was called a “cold clone” operation because it involved an outage (from a transactional perspective) in the source database. This applies for both the same CDB clone or Remote CDB clone. Related Article Oracle database 12c:How to … Continue reading Hot PDB cloning in Oracle database 12.2 »

Refreshable PDB in Oracle Database 12.2

Refreshable PDB is a new features introduced in 12.2 . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create a cloned environment from scratch and also ensures that a cloned PDB can be periodically synchronized with … Continue reading Refreshable PDB in Oracle Database 12.2 »

PDB Relocate in Oracle database 12c Release 2

A pluggable database is a self-contained, fully-functional Oracle database. We often need to move the pluggable database from one CDB to another CDB. This will be a unplug/plug operation where outage will depend on the location of source and destination CDB 1) When moving between servers with shared storage, such as is typically the case in Cloud environments when the PDB is being moved for … Continue reading PDB Relocate in Oracle database 12c Release 2 »