- http://mrlehongquang.blogspot.com/2016/05/oracle-database-installation.html
- http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htm
- https://wiki.centos.org/HowTos/Oracle12onCentos7
- https://blogs.oracle.com/opal/how-i-enable-autostarting-of-oracle-database-for-demonstrations-and-development
- https://wiki.centos.org/HowTos/Oracle12onCentos7
II.Setup
Mô hình triển
khai hệ thống máy chủ CSDL
IV. Cài đặt auto start Oracle
1.Create a new service script
Create a file /etc/init.d/dbora using dbora
2.Set permissions on the script
# chmod 750 /etc/init.d/dbora
3.Tell Linux to autostart/stop the service
On Oracle Linux 5 and 6 run:
# chkconfig --add dbora
# chkconfig dbora on
On Oracle Linux 7 run:
# systemctl enable dbora
4.Edit /etc/oratab
In /etc/oratab, change the autostart field from N to Y for any databases that you want autostarted.
Starting / Stopping the DB
The DB will start and stop at machine boot and shutdown.
Or it can be manually controlled with:
# service dbora start
And
# service dbora stop
On Oracle Linux 7, use 'systemctl start dbora' and 'systemctl stop dbora'.
5.Starting Oracle Database 12c Multitenant PDBs
To also start all pluggable databases when the container database starts, run this in
SQL*Plus as SYSDBA:
create or replace trigger sys.after_startup
after startup on database
begin
execute immediate 'alter pluggable database all open';
end after_startup;
/
III. Lỗi thường gặp
1. Lỗi cài đặt lại oracle
problem:
You do not have sufficient permissions to access the inventory '/u01/app/oraInventory'. Installation cannot continue. Make sure that you have read/write permissions to the inventory directory and restart the installer.: Permission denied
solution:
rm /etc/oraInst.loc
refers:
2. Đặt service_name: lưu ý chỉ dùng chữ thường không viết in hoa.
