All Productsnav_clkallproductsAll Solutionsnav_clkallproducts
SearchBar__icon__search
Marketplacenavbar-searchnavbar-menu
Documents Product Categories Oracle Database 12.2 Enterprise on RedHat 7

Oracle Database 12.2 Enterprise on RedHat 7

Jun 28, 2024
RHEL 7 – Oracle Database 12.2.0.1 Enterprise Edition Version: 1.0.0 Created by: cloudimg Table of Contents 1.) Overview......................................................................................................................1 2.) Access & Security..........................................................................................................2 3.) System Requirements....................................................................................................2 4.) Connecting to the Instance...........................................................................................2 5.) On Startup....................................................................................................................2 6.) Filesystem Configuration..............................................................................................2 7.) Server Components......................................................................................................3 8.) Scripts and Log Files.....................................................................................................3 9.) Using System Components...........................................................................................4 1.) Overview This document is provided as a user guide for the RHEL 7 – Oracle Database 12.2.0.1 Enterprise Edition product offering on the Alibaba Cloud Marketplace. Please reach out to support@cloudimg.co.uk if any issues are encountered following this user guide for the chosen product offering.2.)Access & Security Please update the security group of the target instance to allow the below ports and protocols for access and connectivity. Protocol Type Port Description SSH TCP 22 SSH connectivity TCP TCP 1521 Oracle Database Listener Port 3.)System Requirements The minimum system requirements for the chosen product offering can be found below Minimum CPU Minimum RAM Required Disk Space 1 1 GB 20 GB 4.) Connecting to the Instance Once launched in the ECS Console, please connect to the instance via an SSH client using the root user with the key pair associated at launch. 5.) On Startup An OS package update script has been configured to run on boot to ensure the image is fully up to date at first use. You can disable this feature by removing the script from /stage/scripts/ and deleting the entry in crontab for the root user. Disable the OS update script from running on reboot rm -f /stage/scripts/initial_boot_update.sh crontab -e #DELETE THE BELOW LINE. SAVE AND EXIT THE FILE. @reboot /stage/scripts/initial_boot_update.sh 6.) Filesystem ConfigurationPlease see below for a screenshot of the server disk configuration and specific mount point mappings for software locations. Filesystem Size Used Avail Use% Mounted on devtmpfs 1.9G 0 1.9G 0% /dev tmpfs 1.9G 0 1.9G 0% /dev/shm tmpfs 1.9G 8.5M 1.9G 1% /run tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup /dev/nvme0n1p2 38G 3.5G 32G 10% / /dev/nvme1n1 20G 6.5G 13G 35% /u01 /dev/nvme0n1p1 2.0G 143M 1.7G 8% /boot tmpfs 389M 0 389M 0% /run/user/1002 tmpfs 389M 0 389M 0% /run/user/0 Mount Point Description /boot Operating System Kernel files /u01 Oracle software installation directory 7.) Server Components Please see below for a list of installed server components and their respective installation paths. The below versions are subject to change on initial boot based on the initial_boot_update.sh script finding new versions of the software in the systems package repositories. Component Version Software Home Aliyun CLI 3 /usr/local/bin/aliyun Oracle Database 12.2.0.1 Enterprise 12.2.0.1 /u01 8.) Scripts and Log Files The below table provides a breakdown of any scripts & log files created to enhance the useability of the chosen offering. Script/Log Path Description Initial_boot_update.sh /stage/scripts Update the Operating System withthe latest updates available. Initial_boot_update.log /stage/scripts Provides output for initial_boot_update.sh /stage/scripts/oracle-database- /stage/scripts Oracle Database user credentials credentials.log 9.) Using System Components Instructions can be found below for using each component of the server build mentioned in section 7 of this user guide document. Aliyun CLI Run – Once logged into the server, you may check the options available for the use of Aliyun CLI via the below command. aliyun –-help Oracle Database A sample Oracle Database has been preinstalled on the system. You can start and or stop this example Database via the below commands as the oracle OS user. Run – Once logged into the server as the root user, switch to the oracle user. (Please type this command instead of copy paste) sudo su – oracle Run – Three scripts have been created under the $HOME directory of the Oracle user.  setEnv.sh – This script will set the Oracle environment variables allowing the use of utilities such as sqlplus.  start_all.sh – This script will start the example Oracle Database Listener and ORCL sample database. stop_all.sh – This script will stop the example Oracle Database Listener and ORCL sample database. Run – The below commands will start the sample Oracle Database & Listener. #Start the sample Oracle Database and associated Listener cd $HOME . ./start_all.sh EXPECTED OUTPUT LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-APR-2023 07:04:15 Copyright (c) 1991, 2016, Oracle. All rights reserved. Starting /u01/app/oracle/product/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 12.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/ip-172-31-90-60/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip-172-31-90-60.ec2.internal) (PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 05-APR-2023 07:04:16 Uptime 0 days 0 hr. 0 min. 2 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/ip-172-31-90-60/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip-172-31-90-60.ec2.internal)(PORT=1521))) The listener supports no services The command completed successfullySQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 5 07:04:21 2023 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> ORACLE instance started. Total System Global Area 1627389952 bytes Fixed Size 8621280 bytes Variable Size 1040188192 bytes Database Buffers 570425344 bytes Redo Buffers 8155136 bytes Database mounted. Database opened. SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Run – Set the Oracle environment variables and access SQLPLUS #Set the Oracle environment variables and access SQLPLUS cd $HOME . ./setEnv.sh sqlplus / as sysdba EXPECTED OUTPUT SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 5 07:05:18 2023 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionNOTE: if you would like to access the database using the SYSTEM user, please refer to the randomly generated credentials located in file: /stage/scripts/oracle-database- credentials.log. If you would also like to connect to the database via an external programme such as SQL Developer, please reference the below screenshot for the correct settings such as Port & Service Name. The IP address will differ based on the IP of your instance. Run – Issue the below commands to stop the Oracle Listener and Oracle Database as required. #Stop the Oracle Database and associated listener cd $HOME . ./stop_all.sh EXPECTED OUTPUT LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-APR-2023 07:05:45 Copyright (c) 1991, 2016, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 5 07:05:45 2023 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> Database closed. Database dismounted. ORACLE instance shut down. SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
To view the full page, please visit: Oracle Database 12.2 Enterprise on RedHat 7 Product Userguide

Oracle Database 12.2 Enterprise on RedHat 7

This product has charges associated with it for the build, maintenance and support of the image.
Buy now
About Us Privacy Policy Legal Notice List
Alibaba Group Taobao Marketplace Tmall Juhuasuan AliExpress Alibaba.com 1688 Alimama Alitrip YunOS AliTelecom AutoNavi UCWeb Umeng TTPod DDChong DingTalk Alipay UC Union Legal Notice
© 2009-2025 Copyright by Alibaba Cloud All rights reserved