INS-30510 reported while installing GridInfrastructure for Cluster or Single DB

Hello, For storing Voting disks in ASM,we require minimum of three disks or three failgroups for Normal Redundancy diskgroup. The number of voting files you can store in a particular Oracle ASM disk group depends upon the redundancy of the disk group. ASM puts each voting disk in its own failure group within the disk … Continue reading INS-30510 reported while installing GridInfrastructure for Cluster or Single DB

Advertisements

Linux Unix d.bin command

Hello, Some useful Oracle RAC Database commands in daily use Background Processes fraudms80:/dev#cd fraudms80:/home/oracle#ps -ef |grep d.bin oracle 7536914 1 0 10:17:18 - 0:00 /oracle/product/11.2.0.4/grid/bin/ohasd.bin reboot oracle 12452116 1 0 10:17:38 - 0:00 /oracle/product/11.2.0.4/grid/bin/evmd.bin oracle 14287240 1 0 10:17:38 - 0:00 /oracle/product/11.2.0.4/grid/bin/oraagent.bin oracle 23200164 12452116 0 10:17:39 - 0:00 /oracle/product/11.2.0.4/grid/bin/evmlogger.bin -o /oracle/product/11.2.0.4/grid/evm/log/evmlogger.info -l /oracle/product/11.2.0.4/grid/evm/log/evmlogger.log fraudms80:/home/oracle# … Continue reading Linux Unix d.bin command

AIX server : The file access permissions do not allow the specified action Error Solutions !

Hello, my server version AIX fraudms80 2 7 00CC51B74C00 while copy folder, creating a new folder or etc. is returning: The file access permissions do not allow the specified action Error.  the file is being copied with the expected permissions so why is AIX giving me this error? Look for the dot "." directory, ownership … Continue reading AIX server : The file access permissions do not allow the specified action Error Solutions !

Memory management in Oracle database

  SQL> COLUMN component FORMAT A30 SELECT component, current_size, min_size, max_size FROM v$memory_dynamic_components WHERE current_size != 0;SQL> SQL> 2 3 COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE ------------------------------ ------------ ---------- ---------- shared pool 771751936 318767104 771751936 large pool 67108864 67108864 603979776 java pool 50331648 50331648 50331648 streams pool 33554432 0 33554432 SGA Target 2030043136 1862270976 2030043136 DEFAULT buffer … Continue reading Memory management in Oracle database

PLS-00201: identifier ‘DBMS_LOCK’ must be declared

The Oracle schema does not have access to the DBMS_LOCK package. solution  : 1. Launch an sqplus / as sysdba 2. Connect/logon to the database, using administrative credentials 3. Run the following script: we are giving grant execute on the packages owner. commands : GRANT execute ON DBMS_LOCK TO packages_owner ( schema_name ) ; have … Continue reading PLS-00201: identifier ‘DBMS_LOCK’ must be declared

Sequences (Autonumber) Drop, Create, Alter commands.

In Oracle, you can create an autonumber field by using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key. Oracle SQL Syntax : SELECT last_number FROM all_sequences WHERE sequence_owner = … Continue reading Sequences (Autonumber) Drop, Create, Alter commands.

ORA-01555 or Alter _highthreshold_undoretention integer

hello, Setting either of this parameter will limit high value of undo retention like as ; Description: _highthreshold_undoretention integer : high threshold undo_retention in seconds connect as sysdba alter system set "_HIGHTHRESHOLD_UNDORETENTION=21600" SCOPE=spfile; you need to close and open database !! SQL> show parameter undo; NAME TYPE ------------------------------------ -------------------------------- VALUE ------------------------------ _highthreshold_undoretention integer 17200 undo_management string … Continue reading ORA-01555 or Alter _highthreshold_undoretention integer