How to create a password file using ORAPWD Utility in oracle

How to create a password file using ORAPWD Utility in oracle

How to create a password file using ORAPWD Utility in oracle: In this post we will discuss about how to create a password file using ORAPWD Utility in oracle. What is password file in ORACLE ? The password file stores a list of usernames and passwords that are allowed to remotely authenticate as SYSDBA over … 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

Create an Oracle Listener with Oracle Network Configuration Assistant

Create an Oracle Listener with Oracle Network Configuration Assistant

Create an Oracle Listener with Oracle Network Configuration Assistant : In this article we will see how to Create an Oracle Listener with Oracle Network Configuration Assistant. In order t remote connections to an Oracle database the database must be registered with an Oracle Listener. If you will need to create a Listener manually. This document will detail the … Read more

How to Drop And Recreate Temp Tablespace In Oracle

How To Drop And Recreate Temp Tablespace In Oracle

Drop And Recreate Temp Tablespace In Oracle : During this article we’ll see how to Drop And Recreate temp tablespace In Oracle Database. Note :- While doing this activity, existing temporary tablespace may have existing live sessions, due to same oracle won’t let us to drop existing temporary tablespace. Resulting, we need to kill existing … Read more

How To Rename Or Move A Datafile In Oracle

How To Rename Or Move A Datafile In Oracle

How To Rename Or Move A Datafile In Oracle: In this article we will see How To Rename Or Move A Datafile In Oracle Database. Here is a sample procedure for relocating a datafile. Assume the following conditions: An open database has a tablespace named users that is made up of datafiles all located on … Read more

Multiplexing Control Files in Oracle

Multiplexing Control Files in Oracle

Multiplexing Control Files in Oracle: In this article we will discuss about Multiplexing Control Files in Oracle. This document will detail multiplexing of control files. Having multiple control files reduces the risk of control file loss due to corruption or accidental removal. In the case of corruption or loss recovery is no more difficult than … Read more

Changing the Database Archiving Mode In Oracle

Changing the Database Archiving Mode In Oracle

Changing the Database Archiving Mode In Oracle: In this article we will discuss how Changing the Database Archiving Mode In Oracle. There are 2 types of logging mode in oracle database: Archivelog mode : In this mode, after the online redo logs are filled , it will move to archive location. Noarchivelog mode : In … Read more

Managing Datafiles in Oracle Database

Managing Datafiles in Oracle Database

Managing Datafiles in Oracle Database: In this article we will discuss about Managing Datafiles in Oracle Database. Guidelines for Managing Datafiles: Datafiles are physical files of the operating system that store the data of all logical structures in the database. They must be explicitly created for each tablespace. Oracle Database assigns each datafile two associated … Read more

Change Flashback mode In Oracle Database

Change Flashback mode In Oracle

Change Flashback mode In Oracle Database: In this article we will discuss how to Change Flashback mode In Oracle Database. By using flashback technology we can restore the database to a particular point in past. It’s like time machine.Here we will see , how to enable and disable flashback in oracle.To enable flashback we need … Read more