Jan 29, 2025 · 3 min read · Oracle is a company that offers a variety of business oriented products and services, including Oracle Database, a relational database management system (RDBMS). Oracle database is a core component of many corporate IT environments, supporting busin...
Join discussionFeb 7, 2024 · 1 min read · Connect as DBA. [oracle@orcl ~]$ sql / as sysdba Disconnect all users. Shutdown and startup mount (!Caution). SQL> SHTDOWN IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP MOUNT ORACLE instance star...
Join discussion
Feb 6, 2024 · 1 min read · Check Status and Parameters. Shutdown and startup mount (!Caution). [oracle@orcl ~]$ sqlplus / as sysdba SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. ...
Join discussion
Feb 5, 2024 · 1 min read · Get and Set ADR_BASE location. [oracle@orcl ~]$ adrci ADRCI: Release 19.0.0.0.0 - Production on Tue Aug 8 15:08:45 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show bas...
Join discussion
Feb 5, 2024 · 1 min read · Purge Alerts older than 1 month (44640 minutes). adrci> purge -age 44640 -type ALERT Purge Trace Files older than 1 month (44640 minutes). adrci> purge -age 44640 -type TRACE Purge Incidents older than 1 month (44640 minutes). adrci> purge -ag...
Join discussion