PROBLEM : The attempt to create a password file for a 12.2 database failed : SOLUTION: To address this issue, there are two options available: either provide a password that meets the complexity requirements, such as: Alternatively, you can create the password file in the 12.1 format, which differs from the default 12.2 format. Reference:
This property specifies connection information used to connect to an Oracle database. The Oracle installer generally places a sample tnsnames.ora file in your $ORACLE_HOME/network/admin directory, but you can see many sample tnsnames.ora file for use as a template.
Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform (Oracle /Redhat Linux)
Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database. It can be done in up are running condition of DB . No downtime required. For Real application cluster(RAC): In RAC, the archive destination is pointed to an ASM diskgroup. Change the archive destination: Before pointing the … Read more
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/prod/system01.dbf’ Suppose we are facing this issue while opening the database with resetlogs option. We have to check how many files have been recovered. We can check with the … Read more
cassandra -f [start commads] ./nodetool status [checking status] ./nodetool ring [depicts of the state of nodes] ./nodetool -h 192.168.0.101 clean [cleanup of keys that no longer belong to a particular node] ./nodetool -h 192.168.0.101 info [gives information token,disk storage, generation number,uptime seconds,heap] ./nodetool -h 192.168.0.101 compact [immediate compaction on the entire node,key space,column family level] … Read more
PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes. The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to … Read more
To identify the number of diskgroup ,status from below query. Size of ASM Diskgroup Check Diskgroup online/offline Status from OS Prompt Check Datafile, Controlfile, Logfile existence in respective Diskgroup. Check the compatibility version for below diskgroup. Change ASM Compatibility to 18.0.0.0.0. ASM_DISKSTRING Validate Unused Disk To identify the free allocation units for each lun based … Read more
Oracle hangs only when he is waiting for a resource. It might be a software resource (a latch or lock), or you could be hung waiting for server resources (CPU, RAM). There are several ways to find the root cause of an Oracle hanging issue: oradebug – See below for complete steps for diagnosing a … Read more
12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a NOCOMPRESS index in the WHALE tablespace: SQL> create table WHALE (id number, Slno number, name varchar2(38));Table created. SQL> insert into WHALE select rownum, mod(rownum,10), ‘BLUE WHALE’ from dual connect by level <= 1000000;1000000 rows created. SQL> commit;Commit complete. SQL> create … Read more