ORA-12154: TNS could not resolve service name

ORA-12154: TNS could not resolve service name

ORA-12154: TNS could not resolve service name: In this article we will see how to resolve this error ORA-12154: TNS could not resolve service name. ORA-12514 is a common error which related to your database tnsnames.ora file and your database name. Solution : Make sure that your listener is listening for the same service name … Read more

Oracle Database startup and shutdown procedure

Oracle Database startup and shutdown procedure

For a DBA, starting up and shutting down of oracle database is a routine and basic operation. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. So, it is important for non-DBAs to understand some basic database administration activities. Oracle Database startup and shutdown procedure Oracle Database startup and … Read more

Compile Invalid Objects In Oracle

Compile Invalid Objects In Oracle

Compile Invalid Objects In Oracle : In this article we will discuss about how to Compile Invalid Objects In Oracle. Objects in the database can become invalid, if there are any changes to the dependent objects. Oracle recommends that you run the utlrp.sql script after you install, patch, or upgrade a database, to identify and … Read more

ORA-39170: Schema expression does not correspond to any schemas

ORA-39170: Schema expression 'ORAKLDBA' does not correspond to any schemas

ORA-39170: Schema expression ‘ORAKLDBA’ does not correspond to any schemas : We are getting this error when we export/import in oracle. Suppose you need to take export backup of a schema or import dump of a schema which name contains string like, “ORAKLDBA.DB” or “ORAKLDBA$DB“. Some of the Places users are created with “Identified by … Read more

MAX_STRING_SIZE Parameter in Oracle 19c

MAX_STRING_SIZE Parameter in Oracle 19c

MAX_STRING_SIZE Parameter in Oracle 19c : In this article we will discuss about MAX_STRING_SIZE Parameter in Oracle 19c. This parameter was introduced in Oracle 12c onwards. MAX_STRING_SIZE controls the maximum size of string size in Oracle database. By default this parameter value is STANDARD, We can change the value of MAX_STRING_SIZE from STANDARD to EXTENDED, … Read more

How to Find Out the size of your Oracle Database

How to Find Out the size of your Oracle Database

How to Find Out the size of your Oracle Database : In this Article we are going to discuss about How to Find Out the size of your Oracle Database. Database Sizes : We can find out Database Total Size, Database Used Size, Database Free Size using below queries. Also you can use below mentioned … Read more

Transparent Data Encryption In Oracle

Transparent Data Encryption In Oracle

Transparent Data Encryption In Oracle : In this article we will discuss about configuring and enabling Transparent Data Encryption (TDE) in Oracle 19c. To configure Auto Login Wallet in Oracle 19c there are few parameters which needs to be set in spfile. Lets see how to configure TDE. I need to create a subdirectory for … Read more

Exclude Tablespace from Rman Backup in ORACLE

Exclude Tablespace from Rman Backup in ORACLE

During this article we will discuss how to Exclude Tablespace from Backup and configure Exclude option using RMAN. Sometimes we may exclude one or more tablespace from our database RMAN backup or regular RMAN backup. Suppose a tablespace contains test data only or its data never changed in such cases, we may exclude this from … Read more

How to Restore spfile from autobackup in ORACLE

How to Restore spfile from autobackup in ORACLE

If you have lost the SPFILE (server parameter file), and your Database abnormally shutdown. Then you will try to startup your Database but you got an error regarding spfile not found. You can restore spfile from autobackup using RMAN. NOTE:- Database must be in archivelog mode and must be configured Controlfile Autobackup on. Error : … Read more

Take RMAN backup in NOARCHIVE mode

Take RMAN backup in NOARCHIVE mode

Take RMAN backup in NOARCHIVE mode : In this article I’m going to demonstrate to you how to use RMAN in NOARCHIVE mode steps by steps. As you know Oracle strongly recommended running your database in archivelog mode for database security. If you running the database in noarchivelog mode, you refused any recovery. During Oracle … Read more