ORA-01017 : invalid username/password Using Database Link

Let’s start a post with the steps which use for the solve ORA-01017: invalid username/password; logon denied (Using Database Link)  Create a database link with the wrong password

Test the DB link

Reason: Case sensitive login enabled in the target database. Check-in target database:

How to fix: Drop and recreate the database link […]

Read More

ORA-16000

Let’s have a look at the steps used for the error ORA-16000 ORA-16000: database open for read-only access

If we got the above output then your database is physical standby which is READ ONLY mode. You can only select when the database is in Read only mode. If you want to do any changes […]

Read More

ORA-00031: session marked for kill

Let’s have look on the steps used to solve the error Error(ORA-00031: session marked for the kill) Let’s have look on the steps Phase – 1 Find out thread id that needed to be killed from OS level

If you know the user detail you can filter the query.

Output:

Phase-2  Kill […]

Read More

RMAN Parallel Backup

Let’s have look on the commands are used for “RMAN Parallel Backup”. Run the backup

Create more allocate channel

Set the parallelism parameter and run the backup again

Thought of the day.. “You will get all you want in life if you help enough other people get what they want.” — Zig […]

Read More

RMAN Script

Today we are going to have look on the most important topic “script”.  Being human being we are using the script from the long time ago. Before the start, our technical topic has some look use in normal life. Definition A script is any particular system of writing or the written means of human communication. Script originated as simply a […]

Read More

RMAN Image Copy And Compressed Backup

Let’s have look on the steps used for “RMAN Image Copy And Compressed Backup” Backing up Particular Datafile and System file:

Backup Database:

Compressed Backup:

Today’s thought.. “Be helpful. When you see a person without a smile, give them yours.” —  Zig Ziglar Thank you for giving your valuable time to read […]

Read More

Recover From Redo Log File (After Lost Data File))

Today we are going to have look on the steps which we are going to use in Oracle for ” Recover From Redo Log File (After Lost Data File)”. The loss is loss being DBA we well understand the cost of loss “CDR” Check archive list

check the tablespaces and datafile

Create new tablespace […]

Read More

Change SYS password in Data Guard environment

Today we are going have look at changing the password of SYS in the Data Guard environment. Normally we have seen how to change the password of the normal user. That seems a game of kids,  Now we must learn new things in Oracle RDBMS. Let’s have look at the steps we use to change […]

Read More

ORA-03297: file contains used data beyond requested RESIZE value

Today we are talking about the steps we use to solve the “error ORA-03297: file contains used data beyond requested RESIZE value” Let’s have look on the steps. QUERY 1 – datafile Allocated space, free space, High Water Mark location,%Free and resizeable MB

QUERY 2 – location of segments within a data file (Provide file_id […]

Read More

ORA-00257: archiver error

Let’s have look at the post of error’s solving steps. ORA-00257: archiver error. Connect internal only, until freed Or ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST Symptoms: A user cannot connect to the database.

Cause: The flash_recovery_are is full. To perform archiving one destination is allowed (log_archive_min_succeed_dest= 1). Solution: Check the space limit and […]

Read More