作者:einyboy?【原創(chuàng)】鯤鵬ARM構(gòu)架openEuler操作系統(tǒng)安裝Oracle 19c | 云非云計(jì)算機(jī)科學(xué)、自然科學(xué)技術(shù)科譜http://www.nclound.com/index.php/2023/09/03/%E3%80%90%E5%8E%9F%E5%88%9B%E3%80%91%E9%B2%B2%E9%B9%8Farm%E6%9E%84%E6%9E%B6openeuler%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E5%AE%89%E8%A3%85oracle-19c/
- 一、操作系統(tǒng)版本
二、安裝介質(zhì)
Database Software Downloads | Oracle
這個(gè)鏈接是下載oracle安裝包
OracleDB_19.19_Linux-for-arm.zip
Oracle Linux 8 (aarch64) AppStream | Oracle, Software. Hardware. Complete.
這個(gè)鏈接是下載oracle準(zhǔn)備包
oracle-database-preinstall-19c-1.0-3.el8.aarch64.rpm
三、安裝步驟
3.1 使用操作系統(tǒng)yum源
yum install -y ksh libaio-devel libgfortran libstdc+±devel psmisc xorg-x11-utils xorg-x11-xauth
3.2 安裝oracle-database-preinstall-19c-1.0-3.el8.aarch64.rpm
rpm -ivh oracle-database-preinstall-19c-1.0-3.el8.aarch64.rpm –-nodeps
如果不是忽略關(guān)聯(lián)安裝的話(huà)會(huì)報(bào)這個(gè)錯(cuò)
/etc/redhat-release is needed by oracle-database-preinstall-19c-1.0-3.el8.aarch64
libnsl is needed by oracle-database-preinstall-19c-1.0-3.el8.aarch64
3.3 設(shè)置編譯工具
Oracle軟件relink時(shí)，會(huì)到指定位置找ar和as工具，在CentOS 8上，雖然有這兩個(gè)工具，但是位置不對(duì)，在Orace軟件引用的位置創(chuàng)建符號(hào)鏈接：
mkdir -p /opt/rh/devtoolset-8/root/usr/bin/
cd /opt/rh/devtoolset-8/root/usr/bin/
ln -s /usr/bin/ar ar
ln -s /usr/bin/as as
3.4 設(shè)置Oracle環(huán)境變量
3.5 建好oracle目錄
mkdir -p /oracle/admin/orcl/adump
mkdir -p /oracle/oradata/orcl
chown oracle:oracle -R /oracle
3.6 設(shè)置CV_ASSUME_DISTID
export CV_ASSUME_DISTID=RHEL8.0
規(guī)避這個(gè)報(bào)錯(cuò)參考連接：
ARM Linux（麒麟操作系統(tǒng)）安裝Oracle數(shù)據(jù)庫(kù) – 提供7*24專(zhuān)業(yè)數(shù)據(jù)庫(kù)(Oracle,SQL Server,MySQL等)恢復(fù)和Oracle技術(shù)服務(wù)@Tel:+86 17813235971 - 惜分飛
3.7安裝開(kāi)始
su – oracle
cd $ORACLE_HOME
unzip LINUX.ARM64_1919000_db_home.zip
./runInstaller
3.8 手工建庫(kù)
Dbca不能建庫(kù)，只能手工建庫(kù).
1) pfile文件設(shè)置
vi initorcl.ora
*._library_cache_advice=FALSE
*._serial_direct_read='NEVER'
*.audit_file_dest='/oracle/admin/orcl/adump'
*.audit_trail='NONE'
*.compatible='19.0.0' #兼容版本
*.control_files='/oracle/oradata/orcl/control01.ctl','/oracle/oradata/orcl/control02.ctl'
*.db_block_size=8192
*.db_files=1500
*.db_name='orcl' #庫(kù)名
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
.event='10949 TRACE NAME CONTEXT FOREVER:28401 TRACE NAME CONTEXT FOREVER,level 1' #.local_listener='LISTENER_SJYZDB03'
*.max_dump_file_size='500M'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=2000
*.parallel_force_local=TRUE
*.pga_aggregate_target=1289m
*.processes=1000
*.remote_listener=''
*.remote_login_passwordfile='EXCLUSIVE'
*.session_cached_cursors=200
*.sga_target=5868m
*.undo_tablespace='UNDOTBS1'
2) 設(shè)置密碼文件
orapwd file=/home/oracle/oracle_install/dbs/orapworcl entries=10
3）連接實(shí)例
4）連接實(shí)例
SQL> create spfile from pfile;
File created.
5）啟動(dòng)到nomount狀態(tài)
SQL> startup nomount
6）創(chuàng)建庫(kù)
CREATE DATABASE orcl
USER SYS IDENTIFIED BY Oracle123
USER SYSTEM IDENTIFIED BY Oracle123
LOGFILE GROUP 1 ('/oracle/oradata/orcl/redo0101.log','/oracle/oradata/orcl/redo0102.log') SIZE 1000M BLOCKSIZE 512,
GROUP 2 ('/oracle/oradata/orcl/redo0201.log','/oracle/oradata/orcl/redo0202.log') SIZE 1000M BLOCKSIZE 512,
GROUP 3 ('/oracle/oradata/orcl/redo0301.log','/oracle/oradata/orcl/redo0302.log') SIZE 1000M BLOCKSIZE 512
MAXLOGFILES 30
MAXLOGMEMBERS 5
MAXLOGHISTORY 1000
MAXDATAFILES 5000
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/oracle/oradata/orcl/system01.dbf' SIZE 2G REUSE
SYSAUX DATAFILE '/oracle/oradata/orcl/sysaux01.dbf' SIZE 10G REUSE
DEFAULT TABLESPACE users
DATAFILE '/oracle/oradata/orcl/users01.dbf' SIZE 2G REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/oracle/oradata/orcl/temp01.dbf' SIZE 2G REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/oracle/oradata/orcl/undotbs01.dbf' SIZE 2G REUSE;
7）運(yùn)行腳本建立數(shù)據(jù)字典視圖
以SYSDBA管理權(quán)限運(yùn)行下面的腳本：
SQL> @?/rdbms/admin/catalog.sql --->創(chuàng)建數(shù)據(jù)字典視圖、動(dòng)態(tài)性能視圖和同義詞
SQL> @?/rdbms/admin/catproc.sql --->運(yùn)行所有PL/SQL需要或使用的腳本
SQL> @?/rdbms/admin/utlrp.sql --->重新編譯失效狀態(tài)的PL/SQL模塊，包括包、過(guò)程或類(lèi)型
以SYSTEM用戶(hù)執(zhí)行下面的腳本：
SQL> conn system/oracle
Connected.
SQL> @?/sqlplus/admin/pupbld.sql文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-699283.html
文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-699283.html
到了這里，關(guān)于【】鯤鵬ARM構(gòu)架openEuler操作系統(tǒng)安裝Oracle 19c的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
