Oracle recommends to configure the system to automatically start Oracle Database when the system starts, and to automatically shut it down when the system down.
Environment:
Read more of this content when you subscribe today.
SQL> show parameter db_recovery_file NAME TYPE VALUE ------------------------------------ ----------- ------------- db_recovery_file_dest string db_recovery_file_dest_size big integer 0 SQL> select * from V$RECOVERY_FILE_DEST; no rows selected SQL>
SQL> alter system set db_recovery_file_dest_size=10g scope=both; System altered. SQL>alter system set db_recovery_file_dest='/u01/app/oracle/fra' scope=both; System altered. SQL> show parameter db_recovery_file NAME TYPE VALUE ---------------------------- ----------- ---------------------- db_recovery_file_dest string /u01/app/oracle/fra db_recovery_file_dest_size big integer 10G SQL> select * from V$RECOVERY_FILE_DEST; NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID ---- ----------- ---------- ----------------- --------------- ------- /u01/app/oracle/fra 1.0737E+10 0 0 0 0
SQL>alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both; System altered. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 30 Next log sequence to archive 32 Current log sequence 32
SQL> select * from v$flash_recovery_area_usage; FILE_TY PENT_SPACE_USED PCENT_SPACE_REBLE NUMBER_OF_FILES CON_ID ------------------------ ------------------ --------------- --------- CONTROL FILE 0 0 0 0 REDO LOG 0 0 0 0 ARCHIVED LOG .59 0 1 0 BACKUP PIECE 0 0 0 0 IMAGE COPY 0 0 0 0 FLASHBACK LOG 0 0 0 0 FOREIGN ARCHIVED LOG 0 0 0 0 AUXILIARY DATAFILE COPY 0 0 0 0 8 rows selected.
Oracle recommends to configure the system to automatically start Oracle Database when Operating System starts, and to automatically shut it down when the Operating System down.
Environment:
Operating System: Oracle Linux 7
Oracle Database: Oracle 18c
... .. . OEMREP:/opt/oracle/product/18c/dbhome_1:Y ... .. .
#! /bin/sh
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORACLE_HOME.
ORA_HOME=<Type your ORACLE_HOME in full path here>
ORA_OWNER=<Type your Oracle account name here>
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
# Remove "&" if you don't want startup as a background process.
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME" &
touch /var/lock/subsys/dbora
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME" &
rm -f /var/lock/subsys/dbora
;;
esac
# chgrp dba dbora # chmod 750 dbora
dbora script in the appropriate run-level script directories:This post demonstrates the installation of Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) on Oracle Linux 7 (x86_64).
Read more of this content when you subscribe today.
URL : https://oemnode1:7803/em
username: sysman
Password: you specified during your installation
[oracle@oemnode1 scripts]$ . oraenv ORACLE_SID = [OEMREP] ? AGENT [oracle@oemnode1 scripts]$ emctl status agent Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent Version : 13.3.0.0.0 OMS Version : 13.3.0.0.0 Protocol Version : 12.1.0.1.0 Agent Home : /u01/app/oracle/Product/Agent/agent_inst Agent Log Directory : /u01/app/oracle/Product/Agent/agent_inst/sysman/log Agent Binaries : /u01/app/oracle/Product/Agent/agent_13.3.0.0.0 Core JAR Location : /u01/app/oracle/Product/Agent/agent_13.3.0.0.0/jlib Agent Process ID : 6463 Parent Process ID : 6403 Agent URL : https://oemnode1:3872/emd/main/ Local Agent URL in NAT : https://oemnode1:3872/emd/main/ Repository URL : https://oemnode1:4903/empbs/upload Started at : 2020-03-27 23:43:12 Started by user : oracle Operating System : Linux version 4.14.35-1902.10.7.el7uek.x86_64 (amd64) Number of Targets : 33 Last Reload : (none) Last successful upload : 2020-03-28 00:14:07 Last attempted upload : 2020-03-28 00:14:07 Total Megabytes of XML files uploaded so far : 1.72 Number of XML files pending upload : 0 Size of XML files pending upload(MB) : 0 Available disk space on upload filesystem : 13.15% Collection Status : Collections enabled Heartbeat Status : Ok Last attempted heartbeat to OMS : 2020-03-28 00:13:52 Last successful heartbeat to OMS : 2020-03-28 00:13:52 Next scheduled heartbeat to OMS : 2020-03-28 00:14:52 Agent is Running and Ready
[oracle@oemnode1 ~]$ . oraenv ORACLE_SID = [OMS] ? OMS [oracle@oemnode1 ~]$ emctl status oms -bip_only Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. BI Publisher Server is Up [oracle@oemnode1 ~]$ emctl status oms -details Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : Console Server Host : oemnode1 HTTP Console Port : 7788 HTTPS Console Port : 7803 HTTP Upload Port : 4889 HTTPS Upload Port : 4903 EM Instance Home : /u01/app/oracle/Product/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /u01/app/oracle/Product/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://oemnode1:7803/em Upload URL: https://oemnode1:4903/empbs/upload WLS Domain Information Domain Name : GCDomain Admin Server Host : oemnode1 Admin Server HTTPS Port: 7102 Admin Server is RUNNING Oracle Management Server Information Managed Server Instance Name: EMGC_OMS1 Oracle Management Server Instance Host: oemnode1 WebTier is Up Oracle Management Server is Up JVMD Engine is Up BI Publisher Server Information BI Publisher Managed Server Name: BIP BI Publisher Server is Up BI Publisher HTTP Managed Server Port : 9701 BI Publisher HTTPS Managed Server Port : 9803 BI Publisher HTTP OHS Port : 9788 BI Publisher HTTPS OHS Port : 9851 BI Publisher is locked. BI Publisher Server named 'BIP' running at URL: https://oemnode1:9851/xmlpserver/servlet/home BI Publisher Server Logs: /u01/app/oracle/Product/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/ BI Publisher Log : /u01/app/oracle/Product/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log [oracle@oemnode1 ~]$
[oracle@oemnode1 ~]$ emctl stop oms Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. Stopping Oracle Management Server... Oracle Management Server Successfully Stopped Oracle Management Server is Down JVMD Engine is Down [oracle@oemnode1 ~]$ emctl status oms Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. WebTier is Up Oracle Management Server is Down JVMD Engine is Down BI Publisher Server is Up [oracle@oemnode1 ~]$
[oracle@oemnode1 ~]$ emctl stop oms -all Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. Stopping Oracle Management Server... WebTier Successfully Stopped Oracle Management Server Successfully Stopped Oracle Management Server is Down JVMD Engine is Down Stopping BI Publisher Server... BI Publisher Server Successfully Stopped AdminServer Successfully Stopped BI Publisher Server is Down [oracle@oemnode1 ~]$
[oracle@oemnode1 ~]$ emctl status oms Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. WebTier is Up Oracle Management Server is Up JVMD Engine is Up BI Publisher Server is Up [oracle@oemnode1 ~]$
[oracle@oemnode1 ~]$ emctl status oms -details Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : Console Server Host : oemnode1 HTTP Console Port : 7788 HTTPS Console Port : 7803 HTTP Upload Port : 4889 HTTPS Upload Port : 4903 EM Instance Home : /u01/app/oracle/Product/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /u01/app/oracle/Product/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://oemnode1:7803/em Upload URL: https://oemnode1:4903/empbs/upload WLS Domain Information Domain Name : GCDomain Admin Server Host : oemnode1 Admin Server HTTPS Port: 7102 Admin Server is RUNNING Oracle Management Server Information Managed Server Instance Name: EMGC_OMS1 Oracle Management Server Instance Host: oemnode1 WebTier is Up Oracle Management Server is Up JVMD Engine is Up BI Publisher Server Information BI Publisher Managed Server Name: BIP BI Publisher Server is Up BI Publisher HTTP Managed Server Port : 9701 BI Publisher HTTPS Managed Server Port : 9803 BI Publisher HTTP OHS Port : 9788 BI Publisher HTTPS OHS Port : 9851 BI Publisher is locked. BI Publisher Server named 'BIP' running at URL: https://oemnode1:9851/xmlpserver/servlet/home BI Publisher Server Logs: /u01/app/oracle/Product/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/ BI Publisher Log : /u01/app/oracle/Product/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log
[oracle@oemnode1 ~]$ emctl stop agent
[oracle@oemnode1 ~]$ emctl start agent
[oracle@oemnode1 ~]$ emctl status agent
When starting up 13cR3 OMS server, the command hangs forever.
[oracle@oemnode1 ~]$ emctl start oms Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. Starting Oracle Management Server...
Read more of this content when you subscribe today.
Make DBA Life Easy 