1.查看当前数据库版本信息 [oracle@oracle19c~]$cd$ORACLE_HOME [oracle@oracle19cdbhome_1]$./OPatch/opatchlspatches 29585399;OCWRELEASEUPDATE19.3.0.0.0(29585399) 29517242;DatabaseReleaseUpdate:19.3.0.0.190416(29517242)2.替换Opatch [root@orac

查看oracle环境变量#查看oracle环境变量echo$ORACLE_HOME编辑ORACLE配置文件vim/etc/oratabORCL:/opt/oracle/product/19c/dbhome_1:Y配置启动vim/etc/rc.d/rc.local设置ORACLE开机自启su-oracle-c'/opt/oracle/product/19c/dbhome_1/bin/lsnrctlsta

ORACLE开机自启配置linux下配置单机开机自启2,redhat操作系统下面，用dbstart的方式2.1，测试[oracle@localhost~]$/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbstartORACLE_HOME_LISTNERisnotSET,unabletoauto-startOracleNetListenerUsage:/oracle/app/o

比较简单。关键点：ln-s/usr/lib64/libnsl.so.1   /usr/lib64/libnsl.soln-sf/u01/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libaio.so.1  /usr/lib64/libaio.so.1vi/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk (emdctl:添加-

Patch22191577:GRIDINFRASTRUCTUREPATCHSETUPDATE11.2.0.4.160119(JAN2016)Unzipthepatch22191577UnziplatestOpatchVersioninoraclehomeandcrshom

首先当然是找到st_shapelib.dll或st_geometry.dll文件，比如我本机的：C:\soft\ArcGIS\Desktop10.2\DatabaseSupport\Oracle\Windows64目录下找到st_shapelib.dll文件。

 SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=/oracleapp/oracle/product/11.2.0/dbhome_2)(PROGRAM=ext

1、找到 product\11.2.0\dbhome_1\NETWORK\ADMIN下面的 listener.ora&tnsnames.ora两个文件，记得先备份 2、分别修改文件内的端口号listener.ora 如下图所示，要

一套测试环境，GI是19c，而DB是11.2.0.4，打算针对DB安装最新的PSU时。使用opatchauto方式报错。[root@19cracdg1software]#/u01/app/oracle/product/11.2.0.4/dbhome_1/OPat