Showing posts with label oraclexe 11. Show all posts
Showing posts with label oraclexe 11. Show all posts

Friday, February 8, 2019

Install OracleXE 11g on Centos7 64 bit

1.install minimal centos 7 with network active

2.lakukan:
yum update
yum install unzip libaio bc flex mc net-tools
 
 
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
 
cd Disk1
rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
 
 
/etc/init.d/oracle-xe configure
 
[selesai] 
 
 
 
The database is install at /u01/app/oracle/product/11.2.0/xe/
The oracle_env script is in the folder bin.

masukin ke
To set the environment permanently for users, add the following to the .bashrc or .bash_profile of the users you want to access the environment:

. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
[note: ada spasi setelah titik]

reboot

coba: sqlplus

===ganti IP [misal 192.168.10.200] kadang gak bisa, coba:

[oracle@oracle admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 10 12:57:37 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.200)(PORT=1521))' scope=both;
System altered.
SQL> alter system register;
System altered.
SQL> exit