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 SQL> create database link test_link connect to scott identified by tiger using ‘Test’; Test the DB link SQL> select * from dual@test_link; ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from VODCMS Reason: Case sensitive login enabled in the target database. Check-in target database: […]
All posts by Anuradha Mudgal
Anuradha Mudgal
ORA-16000
Let’s have a look at the steps used for the error ORA-16000 ORA-16000: database open for read-only access SQL> select log_mode,open_mode , database_role from v$database; LOG_MODE OPEN_MODE DATABASE_ROLE ———————————– ————————————————————————— ARCHIVELOG READ ONLY WITH APPLY PHYSICAL STANDBY If we got the above output then your database is physical standby which is […]
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 select vs.sid, vs.username, vs.osuser, vs.process fg_pid, vp.spid bg_pid from v$session vs, v$process vp where vs.paddr = vp.addr; If you know the user detail you can filter […]
RMAN Parallel Backup
Let’s have look on the commands are used for “RMAN Parallel Backup”. Run the backup RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup (datafile 1,2,3 channel c1) (archivelog all channel c2); } Create more allocate channel RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; […]
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 […]
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: RMAN> run { allocate channel c1 type disk; copy datafile 1 to ‘D:\oracle\product\10.2.0\flash_recovery_area\DBA01\Image copy\SYSTEM01.DBF’, current controlfile to ‘D:\oracle\product\10.2.0\flash_recovery_area\DBA01\Image copy\CONTROL01.ctl’; } Backup Database: RMAN> backup as copy database; Compressed Backup: RMAN> backup as compressed backupset […]
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 SQL> archive log list; Database log mode No Archive Mode […]
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 […]
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 select tablespace_name, file_id, file_name DATA_FILE_NAME, Allocated_MBYTES, High_Water_Mark_MBYTES, FREE_MBYTES, trunc((FREE_MBYTES/Allocated_MBYTES)*100,2) “% Free”, trunc(Allocated_MBYTES-High_Water_Mark_MBYTES,2) Resizeble from ( […]
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. SQL> conn user/password ORA-00257: archiver error. Connect internal only, until freed. SQL> archive log all; ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST […]