[제품 주기 및 호환성]
742060.1 PNEWS1360 Release Schedule of Current Database Releases
2460719.1 PNEWS1360 데이터베이스 릴리즈 일정
207303.1 KB141043 Client / Server Interoperability Support Matrix for Different Oracle Versions
1556542.1 KB141043 서로 다른 오라클 버전의 클라이언트 / 서버 간의 상호 운용성 지원 매트릭스
401934.1 FAQ5960 Starting With Oracle JDBC Drivers - Installation, Certification, and More
1684635.1 FAQ5960 오라클 JDBC 드라이버 시작하기 - - 설치, 호환성 등
[Install]
1587357.1 KB147998 Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris and MS Windows Operating Systems Installation and Configuration Requirements Quick Reference (12.1/12.2/18c/19c)
2327772.1 KB187926How to Install / Upgrade/ Clone 12.2 Grid Infrastructure in Silent Mode Using gridSetup.sh
2668780.1 KB152488 Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64)
1529433.1 KB90245 Requirements for Installing Oracle Database 12.1 on RHEL5 or OL5 64-bit (x86-64)
880989.1 KB135513 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OL) 5 on AMD64/EM64T
[Patch]
888.1 KB106822 Master Note for Database Proactive Patch Program (문서 ID 888.1)
555.1 KB188772 Oracle Database 19c Important Recommended One-off Patches (문서 ID 555.1)
1594184.1 KB90328 Example: Manually Apply a 12c GI PSU/Interim or DB Interim Patch in Cluster Environment
2246888.1 KB627956 Supplemental Readme - Grid Infrastructure Release Update 12.2.0.1.x / 18c /19c
[RAC]
1062983.1 KB145644 How to Restore ASM Based OCR After Complete Loss of the CRS Diskgroup on Linux/Unix Systems
2139155.1 KB145644 11gR2 RAC : OCR을 구성하고있는 ASM Diskgroup이 전체손실 된 경우 복구 방법
276434.1 KB91820 How to Modify Public Network Information including VIP in Oracle Clusterware
1572572.1 KB91820 오라클 클러스터웨어에서 VIP를 포함한 공용 네트워크 정보를 수정하는 방법
283684.1 KB109184 How to Modify Private Network Information in Oracle Clusterware
952903.1 KB141046 How to Update the IP Address of the SCAN VIP Resources (ora.scan{n}.vip)
[Exadata]
888828.1 KB153930 Exadata Database Machine and Exadata Storage Server Supported Versions
757552.1 KB480584 Oracle Exadata Best Practices
1244344.1 KB808193 Exadata Starter Kit
1270094.1 KB623062 Exadata Critical Issues
1317159.1 KB314227 Changing IP addresses on Exadata Database Machine
Database
자주 참고하는 Oracle MOS(Metalink) 문서 - MOS 변경 후 신/구 문서번호비교 #1
2026. 1. 1. 09:00
반응형
반응형
Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk
2024. 7. 1. 09:00
반응형
[증 상]
-Oracle Linux 9.4 + Oracle DB 19c 설치 과정에서 아래와 같은 메시지 출력
[원 인]
Oracle Linux 9 / Redhat Linux 9인 경우 Bug 33794281 - OL9: LIBPTHREAD_NONSHARED.A IS NEEDED FOR ORACLE DATABASE 23C AND 19C 임
해당 Bug는 DB RU 19.21에서 Fix 됨
그외 OS는 Oralce MOS예서 2760289.1 문서 확인 필요
[처리방법]
※주의 : Oracle Linux 9 / Redhat Linux 9인 경우에만 해당, 그외 OS 및 OS버전은 Oralce MOS예서 2760289.1 문서 확인 필요
-최신 OPatch로 교체
[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ol9 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ cd ..
[oracle@ol9 dbhome_1]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@ol9 dbhome_1]$ mv OPatch OPatch_OLD
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ cd /u01/STAGE/
[oracle@ol9 STAGE]$ unzip -d $ORACLE_HOME p6880880_190000_Linux-x86-64.zip
Archive: p6880880_190000_Linux-x86-64.zip
creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/
inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatchauto
creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/
creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/doc/
creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/bin/
creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/lib/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/features/com.oracle.glcm.patch.opatch-common-api-classpath.jar
inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.sun.org.apache.xml.internal.resolver.jar
inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.oracle.glcm.patch.opatchauto-wallet_12.2.1.42.0.jar
inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.sun.xml.bind.jaxb-jxc.jar
inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/javax.activation.javax.activation.jar
[oracle@ol9 STAGE]$
[oracle@ol9 STAGE]$ cd $ORACLE_HOME/OPatch
[oracle@ol9 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@ol9 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.42
OPatch succeeded.
[oracle@ol9 OPatch]$
-최신 RU를 적용 하고 설치 작업
ex)
$ export CV_ASSUME_DISTID=OL8 <<<<< If performing Installation on Oracle Linux 9
$ export CV_ASSUME_DISTID=RHEL8 <<<<< If performing Installation on Red Hat Linux 9
$ ./runInstaller -applyRU <19.23 DBRU Patch 36233263 unzip Location> -applyOneOffs <19.23 OCW RU 36240578 unzip location>
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ cd /u01/STAGE/RU/36233126
[oracle@ol9 36233126]$ ls -al
total 144
drwxr-x---. 8 oracle dba 159 Apr 12 10:03 .
drwxr-xr-x. 3 oracle dba 45 Jun 25 13:34 ..
drwxr-x---. 5 oracle dba 81 Apr 12 10:04 36233263
drwxr-x---. 5 oracle dba 62 Apr 12 10:03 36233343
drwxr-x---. 5 oracle dba 62 Apr 12 10:03 36240578
drwxr-x---. 4 oracle dba 48 Apr 12 10:04 36383196
drwxr-x---. 4 oracle dba 48 Apr 12 10:04 36460248
drwxr-x---. 2 oracle dba 4096 Apr 12 10:08 automation
-rw-rw-r--. 1 oracle dba 5824 Apr 12 19:44 bundle.xml
-rw-r--r--. 1 oracle dba 132988 Apr 16 21:15 README.html
-rw-r--r--. 1 oracle dba 0 Apr 12 10:08 README.txt
[oracle@ol9 36233126]$
[oracle@ol9 36233126]$ cd $ORACLE_HOME
[oracle@ol9 dbhome_1]$ ls
addnode cfgtoollogs ctx dbs dmu has inventory jlib mgw olap oracore oui precomp rdbms root.sh.old.1 slax sqlplus usm
apex clone cv deinstall drdaas hs javavm ldap network OPatch ord owm QOpatch relnotes runInstaller sqldeveloper srvm utl
assistants crs data demo dv install jdbc lib nls OPatch_OLD ords perl R root.sh schagent.conf sqlj suptools wwg
bin css dbjava diagnostics env.ora instantclient jdk md odbc opmn oss plsql racg root.sh.old sdk sqlpatch ucp xdk
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ export CV_ASSUME_DISTID=OL8
[oracle@ol9 dbhome_1]$ ./runInstaller -applyRU /u01/STAGE/RU/36233126/36233263 -applyOneOffs /u01/STAGE/RU/36233126/36240578
Preparing the home to patch...
Applying the patch /u01/STAGE/RU/36233126/36233263...
Successfully applied the patch.
Applying the patch /u01/STAGE/RU/36233126/36240578...
Successfully applied the patch.
The log can be found at: /tmp/InstallActions2024-06-25_02-14-43PM/installerPatchActions_2024-06-25_02-14-43PM.log
Launching Oracle Database Setup Wizard...
The response file for this session can be found at:
/u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2024-06-25_02-14-43PM.rsp
You can find the log of this install session at:
/tmp/InstallActions2024-06-25_02-14-43PM/installActions2024-06-25_02-14-43PM.log
[참고문서]
19c Database Installation/relink fails with :"Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk " (문서 ID 2760289.1)
Requirements for Installing Oracle Database/Client 19c (19.22 or higher) on OL9 or RHEL9 64-bit (x86-64) (문서 ID 2982833.1)
반응형
Oracle SYS/SYSTEM User 삭제 가능한 가?
2023. 6. 26. 09:00
반응형
[상태 확인]
[oracle@datarac1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 31 09:51:29 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
SQL> col USERNAME for a15
SQL> select USER_ID, USERNAME, ACCOUNT_STATUS from dba_users where USERNAME in ('SYS','SYSTEM');
USER_ID USERNAME ACCOUNT_STATUS
---------- --------------- --------------------------------
0 SYS OPEN
9 SYSTEM OPEN
SQL>[SYSTEM User 삭제]
SQL> show user
USER is "SYS"
SQL>
SQL> drop user system;
drop user system
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL> drop user system CASCADE;
drop user system CASCADE
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL>[SYS User 삭제]
SQL> show user
USER is "SYSTEM"
SQL>
SQL> drop user sys;
drop user sys
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL> drop user sys CASCADE;
drop user sys CASCADE
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL>[결론]
안된다.
그러니 이상한 소리 하지 말아라..
반응형