Posted inOracle Scripts SQL

Oratop Utility

Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time for RAC and Standalone DB. oratop utility can be downloaded…
No Comments
Posted inDataGuard Oracle

Standby : Unnamed file issue

Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown - rename to correct file ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185' ORA-01157: cannot identify/lock…
No Comments
Posted inOracle

Oracle AWR (Automatic Workload Repository)

AWR-ADDM-REPORTDownload Automatic Workload Repository (AWR) is a licensed feature that allows information to be recorded on a database for multiple purposes including detection and elimination of performance issues. AWR reports…
1
Posted inOracle

sec_case_sensitive_logon Parameter in oracle

The SEC_CASE_SENSITIVE_LOGON parameter is deprecated. It is retained for backward compatibility only.  SEC_CASE_SENSITIVE_LOGON enables or disables password case sensitivity in the database. true: Database logon passwords are case sensitive. false: Database logon passwords…
No Comments
Posted inOracle

Crontab

Cron is named after Greek word “Chronos” that is used for time. It is a system process that will automatically perform tasks as per the specific schedule. Cron is a…
No Comments