暂无图片
暂无图片
2
暂无图片
暂无图片
暂无图片

ky10.aarch64环境部署ORACLE19C的坑

原创 gh 2024-07-05
303

1、把/ssd/oracle/u01/app/oraInventory下的全部清空


2、设置CV_ASSUME_DISTID

由于在该版本的cvu_prereq.xml文件中只是写了oel支持,现在的操作系统是Kylin,不在他的列表里面,所以需要在.bash_profile中添加export CV_ASSUME_DISTID=RHEL7.6


3、ar 和 as 两个二进制, Oracle使用的是绝对路径,使用 ln 绕过,解决方法:

mkdir -p /opt/rh/devtoolset-8/root/usr/bin/
ln -s /bin/ar /opt/rh/devtoolset-8/root/usr/bin/ar
ln -s /bin/as /opt/rh/devtoolset-8/root/usr/bin/as

也有这种说法,但是么有成功,无法下载:由于缺少了/opt/rh/devtoolset-8/root/usr/bin/ar程序导致,对其进行安装然后重试编译



4、dbca无法正常启动,静默方式直接退出,选择命令方式创建库

Exception in thread "main"
java.lang.UnsatisfiedLinkError: oracle.ops.mgmt.nativesystem.Native.getEnvironment(Ljava/lang/String;Loracle/ops/mgmt/nativesystem/NativeResult;)V


进入$ORACLE_HOME/dbs目录

orapwd file=orapwCDB password=cdb19c*- ignorecase=no

cp init.ora initCDB.ora

修改 initCDB.ora文件如下:

db_name='CDB'
memory_target=10G
processes = 1024
audit_file_dest='/ssd/oracle/u01/app/oracle/admin/CDB/adump'
audit_trail ='db'
db_block_size=8192
db_domain='oracle.com'
db_recovery_file_dest='/ssd/oracle/u01/app/oracle/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/ssd/oracle/u01/app/oracle'
#dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = ('/ssd/oracle/u01/app/oracle/oradata/CDB/disk1/cdb_control1', '/ssd/oracle/u01/app/oracle/oradata/CDB/disk2/cdb_control2')
compatible ='19.3.0'

sqlplus / as sysdba

create spfile from pfile;

startup nomount;

@/home/oracle/dbcreate.sql

其中,dbcreate.sql建库命令:

CREATE DATABASE CDB
USER SYS IDENTIFIED BY ORACLE
USER SYSTEM IDENTIFIED BY ORACLE
LOGFILE GROUP 1 ('/ssd/oracle/u01/app/oracle/oradata/CDB/disk1/redo01a.log','/ssd/oracle/u01/app/oracle/oradata/CDB/disk2/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/ssd/oracle/u01/app/oracle/oradata/CDB/disk2/redo02a.log','/ssd/oracle/u01/app/oracle/oradata/CDB/disk3/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/ssd/oracle/u01/app/oracle/oradata/CDB/disk3/redo03a.log','/ssd/oracle/u01/app/oracle/oradata/CDB/disk4/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/ssd/oracle/u01/app/oracle/oradata/CDB/disk4/system01.dbf'
SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/ssd/oracle/u01/app/oracle/oradata/CDB/disk5/sysaux01.dbf'
SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE users
DATAFILE '/ssd/oracle/u01/app/oracle/oradata/CDB/disk1/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/ssd/oracle/u01/app/oracle/oradata/CDB/disk2/temp01.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE undotbs1
DATAFILE '/ssd/oracle/u01/app/oracle/oradata/CDB/disk3/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
;

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catporc.sql

好友安装时遇到的错误及解决方法:

1、报错1:$ORACLE_HOME/perl/bin/perl: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

使用ldd命令查看发现libnsl.so.1 => not found,安装库包dnf install libnsl解决。

2、报错2:PRVG-0282:failed to retrieve the operating system distribution ID

通过export CV_ASSUME_DISTID=RHEL7.6解决。

3、报错3:Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile

查看详细日志提示缺少libc_nonshared.a、libpthread_nonshared.a文件,从centos7.6上拷贝到麒麟/usr/lib64目录下解决。

最后修改时间:2024-12-20 09:56:40
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论