oracle 12C 手工建库报错问题记录

最新推荐文章于 2023-03-29 17:55:47 发布

hzcyhujw

最新推荐文章于 2023-03-29 17:55:47 发布

阅读量593

点赞数

分类专栏： install

本文链接：https://blog.csdn.net/hzcyhujw/article/details/82717266

版权

install 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

记一次oracle12C 手工建库报错记录：

[oracle@12c List]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Sep 15 19:52:42 2018

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> host perl -I &&rdbms_admin &&rdbms_admin_catcdb --logDirectory &&1 --logFilename &&2
Enter value for 1: /tmp
Enter value for 2: create_cdb.log
Can't locate Util.pm in @INC (@INC contains: /u01/app/product/12.2.1/rdbms/admin /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /u01/app/product/12.2.1/rdbms/admin/catcdb.pl line 35.
BEGIN failed--compilation aborted at /u01/app/product/12.2.1/rdbms/admin/catcdb.pl line 35.

返回操作系统查看有咩有对应的文件：

[oracle@12c Hash]$ find $ORACLE_HOME -name util.pm | wc -l
0

[oracle@12c admin]$ find $ORACLE_HOME -name Util.pm
/u01/app/product/12.2.1/perl/lib/5.22.0/x86_64-linux-thread-multi/Hash/Util.pm
/u01/app/product/12.2.1/perl/lib/5.22.0/x86_64-linux-thread-multi/List/Util.pm
/u01/app/product/12.2.1/perl/lib/5.22.0/x86_64-linux-thread-multi/Scalar/Util.pm
/u01/app/product/12.2.1/perl/lib/5.22.0/x86_64-linux-thread-multi/Sub/Util.pm
/u01/app/product/12.2.1/perl/lib/site_perl/5.22.0/HTTP/Headers/Util.pm

发现有相关的文件，但是有大小写区分需要修改catcdb.pl文件并进入到对应的目录直接输入相关的参数：

[oracle@12c admin]$ cp catcdb.pl catcdb.pl.bak
[oracle@12c admin]$ vi catcdb.pl

use Term::ReadKey; # to not echo password
use Getopt::Long;
use Cwd;
use File::Spec;
use Data::Dumper;
use Util qw(trim, splitToArray);
use catcon qw(catconSqlplus);

经过几次的尝试最终可行的是：/u01/app/product/12.2.1/perl/lib/5.22.0/x86_64-linux-thread-multi/Scalar/Util.pm

SQL> host perl -I &&rdbms_admin &&rdbms_admin_catcdb --logDirectory &&1 --logFilename &&2
Enter value for rdbms_admin: /u01/app/product/12.2.1/rdbms/admin
Enter value for rdbms_admin_catcdb: /u01/app/product/12.2.1/rdbms/admin/catcdb.pl
Enter value for 1: /tmp
Enter value for 2: create_cdb.log
List::Util object version 1.27 does not match bootstrap parameter 1.41 at /usr/lib64/perl5/DynaLoader.pm line 213.
Compilation failed in require at /u01/app/product/12.2.1/rdbms/admin/catcdb.pl line 35.
BEGIN failed--compilation aborted at /u01/app/product/12.2.1/rdbms/admin/catcdb.pl line 35.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@12c List]$ cd /u01/app/product/12.2.1/perl/lib/5.22.0/x86_64-linux-thread-multi/Scalar
[oracle@12c Scalar]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Sep 15 19:53:40 2018

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> host perl -I &&rdbms_admin &&rdbms_admin_catcdb --logDirectory &&1 --logFilename &&2
Enter value for rdbms_admin: /u01/app/product/12.2.1/rdbms/admin
Enter value for rdbms_admin_catcdb: /u01/app/product/12.2.1/rdbms/admin/catcdb.pl
Enter value for 1: /tmp
Enter value for 2: create_cdb.log
Enter new password for SYS: P@ssw0rd
Enter new password for SYSTEM: P@ssw0rd
Enter temporary tablespace name: tempts1
No options to container mapping specified, no options will be installed in any containers
catcon: ALL catcon-related output will be written to [/tmp/catalog_catcon_18103.lst]
catcon: See [/tmp/catalog*.log] files for output generated by scripts
catcon: See [/tmp/catalog_*.lst] files for spool files, if any

接下去你会看到/tmp/catalog*.log 日志的输出记录执行相关的脚本