ORA-01031: insufficient privileges to sys@standby as sysdba

The ORA-01031 is very generic error and normally users will receive this error when users don’t have appropriate privilege. $oerr ora 01031 01031, 00000, "insufficient privileges" // *Cause: An attempt was made to change the current username or password //         without the appropriate privilege. This error also occurs if //         attempting to install a database without the necessary operating //         system privileges. //        ...

Read more

Creating Redo Log Groups and Members

Create all required groups and members of redo log files during database creation. However, there are situations where you might want to create additional groups or members. Creating Redo Log Groups To create new redo log groups and members, you must have the ALTER DATABASE system privilege. To create a new group of redo log files, use the SQL statement ALTER DATABASE with the ADD LOGFILE clause. The following statement adds a new group of redo logs to the database:  ALTER DATABASE   ADD LOGFILE ('/oracle/dbs/log1c.rdo',...

Read more

Multiplex & Move Oracle control files to different directory

1, shutdown database. shutdown immediate; 2, edit Oracle init.ora file, e.g., C:\Oracle\10g\database\inittest.ora, find the line with control file location, change the location from old directory to new directory, e.g.:          OLD:          control_files=("H:\Oradata\test\control01.ctl")          NEW:          control_files=("I:\Oradata\test\control01.ctl",  "J:\Oradata\test\control02.ctl", "K:\Oradata\test\control03.ctl") save init.ora...

Read more

Automate AWR Report Generation

By default snapshots of the relevant data are taken every hour and retained for 7 days. Most of the times database running in default AWR settings. DBA's generates the awr report when something  happened in their database or periodically to check if anything is wrong in databases Some times databases are running smooth without any problems. Due to the default retention of AWR snapshot setting we may loose some good information about database.When problem occurs in the database we may need to compare the bad time report (when problem...

Read more