Splunk is a software platform to search, analyse & visualize the machine generated data gathered from different websites, applications, sensors, devices etc. which make up your IT infrastructure and business. It helps in getting answers from your raw machine data Key Points Benefits:
Primary Key Constraints A primary key constraint designates a column as the primary key of a table or view. A composite primary key designates a combination of columns as the primary key. A primary key can be natural or a surrogate. A natural key is a meaningful identifier made of existing attributes in a table. … Read more
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