分类目录归档：Oracle安装升级

opatch auto 出现unable to get oracle owner for 错误

发表于 2024 年 8 月 7 日 由 惜分飞

在11.2.0.4环境中使用opatch auto 打psu补丁之时遇到unable to get oracle owner for 错误

[root@rac1 35058300]# opatch auto .
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir . -patchn . 
   -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2024-08-06_22-25-22.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2024-08-06_22-25-22.report.log

2024-08-06 22:25:22: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
unable to get oracle owner for

根据mos:OPATCH AUTO Fails with “unable to get oracle owner for” in Multi-Byte Language Environment (Doc ID 1325256.1)的描述是由于多字节语言环境导致,检测当前系统环境,确实是中文语言

[root@rac1 35058300]# env|grep LANG
LANG=zh_CN.UTF-8

export设置LANG=C,然后打patch成功

[root@rac1 35058300]# export LANG=C
[root@rac1 35058300]# opatch auto .
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir . -patchn .
  -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2024-08-06_22-27-31.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2024-08-06_22-27-31.report.log

2024-08-06 22:27:31: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch ././32758914/custom/server/32758914  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 
patch ././34998337  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 

Stopping CRS...
Stopped CRS successfully

patch ././32758914  apply successful for home  /u01/app/11.2.0/grid 
patch ././34998337  apply successful for home  /u01/app/11.2.0/grid 
patch ././33112794  apply successful for home  /u01/app/11.2.0/grid 

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.
发表在 Oracle安装升级 | 评论关闭

oracle 23ai（23.5.0.24.07）完整功能版安装体验

发表于 2024 年 7 月 26 日 由 惜分飞

最近oracle 发布了for exadata、oda以及云端的oracle 23ai版本,今天在x86环境中进行了安装测试,安装环境非常顺利,基本上按照安装需求配置好,然后一路下一步(注意选择不创建库)即可
ORA23AI-install

dbca创建库会遭遇到ORA-27350
ora-27350
由于我这是普通的x86环境,需要设置_exadata_feature_on参数来骗过数据库,参考:ORA-12754: Feature ‘startup’ is disabled due to missing capability ‘Runtime Environment’
最终效果

[oracle@xifenfei ~]$ ss

SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Sat Jul 27 07:30:36 2024
Version 23.5.0.24.07

Copyright (c) 1982, 2024, Oracle.  All rights reserved.


Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.5.0.24.07

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems
Version 23.5.0.24.07

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems
         0


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORA23AI/system01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/system01.dbf
/u01/app/oracle/oradata/ORA23AI/sysaux01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/ORA23AI/users01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/undotbs01.dbf
/u01/app/oracle/oradata/ORA23AI/undotbs01.dbf

7 rows selected.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
SQL> 
SQL> 
SQL> EXIT
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.5.0.24.07
发表在 Oracle安装升级 | 标签为 , | 评论关闭

win平台安装oracle遭遇INS-30131处理

发表于 2024 年 7 月 23 日 由 惜分飞

客户在win平台上安装11.2.0.4 client遭遇到 [INS-30131]执行安装程序验证所需的初始设置失败（原因：无法访问临时位置）
ins-30131

根据官方描述这个问题（Bug 21452473 – Windows: INS-30131 while Installing 12.1.0.2 Database/Client on Windows (Doc ID 21452473.8)）是由于c盘没有被共享的原因,解决方案:
1)启用c盘共享；2)使用ignorePrereq 参数跳过检测

Symptoms:
 While performing 12.1.0.2 Database or Client installations on windows install will fail with following error:
 
 [INS-30131] Initial setup required for the execution of installer validations failed and unable to proceed 
 
 At the command prompt net use will return the following error :
 
  net use \\hostname\c$ 
  ^
  System error 53 has occurred
  The network path was not found. 
 
Cause :
 The error is caused due to Administrative share disabled . If they cannot be enabled perform the following workaround.
 
Workaround :
 For client software  installations, run the installer with following args:
 
 setup.exe -ignorePrereq -J"-Doracle.install.client.validate.clientSupportedOSCheck=false" 
 
 For Database Installation, run the installer with following args:
 
 setup.exe -ignorePrereq -J"-Doracle.install.db.validate.supportedOSCheck=false"
发表在 Oracle安装升级 | 标签为 , , , , | 评论关闭