2010 April | dbazone

dbazone

RSS

ORA-01078: failure in processing system parameters

Posted on April 28th, 2010 in Ora Error

SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘D:\\ORACLE\\PRODUCT\\10.2.0\\DB_1\\DATABASE\\INITORCL.ORA’ SQL> create pfile from spfile=’D:\\oracle\\product\\10.2.0\\db_1\\dbs\\SPFILEORCL.ora’ ; File created. SQL> startup ORACLE instance started. Total System Global Area  612368384 bytes Fixed Size                  1250452 bytes Variable Size             197135212 bytes Database Buffers          411041792 bytes Redo Buffers                2940928 bytes Database mounted. Database opened. SQL>

Published by Paresh Sarma // Comment now »

ORA-12638: Credential retrieval failed

Posted on April 28th, 2010 in Ora Error

Today while I am going to startup my database , I found the following error SQL> startup ORA-12638: Credential retrieval failed I have edited the sqlnet.ora file and modified the same as follows Before – SQLNET.AUTHENTICATION_SERVICES= (NTS) After – SQLNET.AUTHENTICATION_SERVICES= (NONE) After modification , I perform the following operation to bring the database open SQL> [...]

Published by Paresh Sarma // Comment now »

Oracle database Logical and Physical Backups

Posted on April 28th, 2010 in Database Backup, Database backup and Recovery ,

Oracle database backup is an important role for oracle DBA. Physical Backups Oracle database physical backup includes of backing up the  physical files as Datafiles Archived redo logs Control files Network files (tnsnames.ora,listener.ora,sqlnet.ora) Parameter file Physical backups are made on the disk or on the tape devices. Logical Backups Oracle database logical backup made using [...]

Published by Paresh Sarma // Comment now »

Home

Follow dbazonein on Twitter
Increase Google Page Rank