Antsle Forum

Welcome to our Antsle community! This forum is to connect all Antsle users to post experiences, make user-generated content available for the entire community and more. 

Please note: This forum is about discussing one specific issue at a time. No generalizations. No judgments. Please check the Forum Rules before posting. If you have specific questions about your Antsle and expect a response from our team directly, please continue to use the appropriate channels (email: [email protected]) so every inquiry is tracked. 

Please or Register to create posts and topics.

Guide to install Oracle 18c on Centos 7.1

Start a new antlet based on CentOS 7.1 lxc template and setup a bridge Nic.

Don’t perform yum update

Copy the following files to /opt

  • oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
  • oracle-database-ee-18c-1.0-1.x86_64.rpm

cd /opt and execute the following commands

  • yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
  • yum -y localinstall oracle-database-ee-18c-1.0-1.x86_64.rpm

 

Modify the following files (use your own server hostname)

  • /etc/hosts
    • Add ip-address oracledbserver1.kain.nl oracledbserver1
  • /etc/hostname
    • Replace localhost with oracledbserver1.kain.nl

Execute hostnamectl set-hostname oracledbserver1.kain.nl --transient

Reboot server

Execute /etc/init.d/oracledb_ORCLCDB-18c configure

Change password for the oracle user

  • passwd oracle

 

Login in with oracle user

Modify the following file

  • /home/oracle/.bash_profile
    • Add 
      • export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1
      • export ORACLE_SID=ORCLCDB
    • Append to Path
      • :$ORACLE_HOME/bin

Execute source /home/oracle/.bash_profile

 

Verify if the server hostname is correct in the following files

  • /opt/oracle/product/18c/dbhome_1/network/admin/listener.ora
  • /opt/oracle/product/18c/dbhome_1/network/admin/tnsnames.ora

 

Execute sqlplus '/ as sysdba'

  • EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE)

 

Change Password for sys and system

  • ALTER USER sys IDENTIFIED BY <Password>;
  • ALTER USER system IDENTIFIED BY <Password>;

 

Exit sqlplus

 

You should be able to connect with SQL Developer (client) to the database via server_ip port 1521

Oracle Enterprise Manager https://server_ip:5500/em (needs flash plugin)

 

used resources