@martynfigueiredo
Oracle Database Administrator Certified Professional 19c | PL/SQL | MCP Microsoft SQL Server | ITIL
Nothing here yet.
Nothing here yet.
Feb 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
Feb 5, 2024 · 2 min read · Show Real Time log. [oracle@orcl ~]$ adrci ADRCI: Release 19.0.0.0.0 - Production on Tue Aug 8 15:10:27 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show alert -tail -f...
Join discussion