oracle enterprise version download installation

qiaofeng1227 commented 3 years ago

19c ee:

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#license-lightbox https://download.oracle.com/otn/linux/oracle19c/190000/oracle-database-ee-19c-1.0-1.x86_64.rpm

https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/running-rpm-packages-to-install-oracle-database.html#GUID-BB7C11E3-D385-4A2F-9EAF-75F4F0AACF02

https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/index.html

qiaofeng1227 commented 3 years ago

Previous Database Release Software Oracle Database Enterprise Edition 10.2, 11.x, 12.x, and 18c are available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition. To request access to these releases, follow the instructions in Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media:https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=1071023.1) from My Oracle Support. NOTE: for Oracle Database 10.2, you should request 10.2.0.1 even if you want to install a later patch set. Once you install 10.2.0.1 you can then apply any 10.2 patch set. Similarly, for 11.1 request 11.1.0.6 which must be applied before installing 11.1.0.7. Patch sets can be downloaded from the Patches and Updates tab on My Oracle Support.

历史版本已经不提供直接下载安装，需要用之前的购买的标识符验证才能下载安装

qiaofeng1227 commented 3 years ago

Unbreakable Linux Network (ULN)

注册需要输入oracle账号，密码和CSI, 这个CSI只有购买oracle软件后才能向oracle support申请，因此我们无法考虑此种方式，用户已经有了CSI本身就是付费用户了，没有从我们这里购买oracle db的需求。

注册ULN后，会禁止掉oracle自带源，可以理解为 ULN等同于 Redhat的付费库。

qiaofeng1227 commented 3 years ago

Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration failed.
[root@iZj6c55u1570vkjx6biy49Z ~]# cat /opt/oracle/cfgtoollogs/netca/trace_OraHome1-2106154AM5611.log
[main] [ 2021-06-15 04:56:11.426 EDT ] [NetCALogger.initTrace:203]  Oracle Net Configuration Assistant: 2106154AM5611
[main] [ 2021-06-15 04:56:11.426 EDT ] [NetCALogger.initTrace:204]  Oracle Home: /opt/oracle/product/19c/dbhome_1
[main] [ 2021-06-15 04:56:11.427 EDT ] [NetCALogger.initTrace:205]  Oracle Base: /opt/oracle
[main] [ 2021-06-15 04:56:11.427 EDT ] [NetCALogger.initTrace:206]  Oracle Home Name: OraHome1
[main] [ 2021-06-15 04:56:11.484 EDT ] [InventoryUtil.getOUIInvSession:349]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2021-06-15 04:56:11.484 EDT ] [HAUtils.<init>:339]  oui location /opt/oracle/oraInventory/ContentsXML
[main] [ 2021-06-15 04:56:11.486 EDT ] [InventoryUtil.getOUIInvSession:349]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2021-06-15 04:56:11.487 EDT ] [OracleHome.isClientHome:1816]  Homeinfo /opt/oracle/product/19c/dbhome_1,1
[main] [ 2021-06-15 04:56:11.855 EDT ] [HAUtils.<init>:372]  isClientHome: false
[main] [ 2021-06-15 04:56:11.868 EDT ] [Version.isPre:757]  version to be checked 19.0.0.0.0 major version to check against 10
[main] [ 2021-06-15 04:56:11.869 EDT ] [Version.isPre:768]  isPre.java: Returning FALSE
[main] [ 2021-06-15 04:56:11.871 EDT ] [OCR.loadLibrary:337]  
 Inside constructor of OCR
[main] [ 2021-06-15 04:56:11.871 EDT ] [OCR.loadLibrary:345]  Going to load the ocr library
[main] [ 2021-06-15 04:56:11.871 EDT ] [Library.load:205]  library.load
[main] [ 2021-06-15 04:56:11.875 EDT ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2021-06-15 04:56:11.875 EDT ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2021-06-15 04:56:11.876 EDT ] [Library.load:291]  Loading  library /opt/oracle/product/19c/dbhome_1/lib/libsrvmocr19.so
[main] [ 2021-06-15 04:56:11.888 EDT ] [OCR.loadLibrary:347]  loaded ocr libraries
[main] [ 2021-06-15 04:56:11.890 EDT ] [SRVMContext.init:186]  Performing SRVM Context init. Init Counter=1
[main] [ 2021-06-15 04:56:11.891 EDT ] [Library.load:205]  library.load
[main] [ 2021-06-15 04:56:11.891 EDT ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2021-06-15 04:56:11.891 EDT ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2021-06-15 04:56:11.891 EDT ] [Library.load:291]  Loading  library /opt/oracle/product/19c/dbhome_1/lib/libsrvmhas19.so
[main] [ 2021-06-15 04:56:11.895 EDT ] [Version.isPre:757]  version to be checked 19.0.0.0.0 major version to check against 10
[main] [ 2021-06-15 04:56:11.895 EDT ] [Version.isPre:768]  isPre.java: Returning FALSE
[main] [ 2021-06-15 04:56:11.896 EDT ] [OCR.loadLibrary:337]  
 Inside constructor of OCR
[main] [ 2021-06-15 04:56:11.896 EDT ] [SRVMContext.init:186]  Performing SRVM Context init. Init Counter=2
[main] [ 2021-06-15 04:56:11.896 EDT ] [OCR.isCluster:1059]  Calling OCRNative for isCluster()
[main] [ 2021-06-15 04:56:11.899 EDT ] [nativesystem.OCRNative.Native]  JNI: clsugetconf retValue = 0
[main] [ 2021-06-15 04:56:11.899 EDT ] [OCR.isCluster:1063]  OCR Result status = true
[main] [ 2021-06-15 04:56:11.899 EDT ] [OCR.isCluster:1075]  Bolean result = false
[main] [ 2021-06-15 04:56:11.900 EDT ] [SRVMContext.init:197]  No CRS configuration found
[main] [ 2021-06-15 04:56:11.900 EDT ] [OCR.isCluster:1059]  Calling OCRNative for isCluster()
[main] [ 2021-06-15 04:56:11.900 EDT ] [nativesystem.OCRNative.Native]  JNI: clsugetconf retValue = 0
[main] [ 2021-06-15 04:56:11.900 EDT ] [OCR.isCluster:1063]  OCR Result status = true
[main] [ 2021-06-15 04:56:11.901 EDT ] [OCR.isCluster:1075]  Bolean result = false
[main] [ 2021-06-15 04:56:11.903 EDT ] [CmdlineArgs.<init>:148]  Initializing variables array...
[main] [ 2021-06-15 04:56:11.903 EDT ] [CmdlineArgs.<init>:154]  Initializing NetProperties...
[main] [ 2021-06-15 04:56:11.904 EDT ] [CmdlineArgs.initArgs:171]  Initializing command line arguments...
[main] [ 2021-06-15 04:56:11.904 EDT ] [CmdlineArgs.parseLogParam:303]  Parsing /log argument...
[main] [ 2021-06-15 04:56:11.906 EDT ] [CmdlineArgs.parseLogParam:358]  Returning Log File = null
[main] [ 2021-06-15 04:56:11.908 EDT ] [CmdlineArgs.setOraArgs:249]  Setting Oracle arguments...
[main] [ 2021-06-15 04:56:11.908 EDT ] [CmdlineArgs.setOraArgs:253]  Passed Oracle Home = /opt/oracle/product/19c/dbhome_1
[main] [ 2021-06-15 04:56:11.908 EDT ] [CmdlineArgs.setOraArgs:256]  Read Oracle Home = /opt/oracle/product/19c/dbhome_1
[main] [ 2021-06-15 04:56:11.908 EDT ] [CmdlineArgs.setOraArgs:259]  Read Oracle Home ID = 
[main] [ 2021-06-15 04:56:11.909 EDT ] [CmdlineArgs.setOraArgs:262]  Read Oracle Home Name = null
[main] [ 2021-06-15 04:56:11.909 EDT ] [CmdlineArgs.compareOraHome:228]  Comparing Oracle Homes ...
[main] [ 2021-06-15 04:56:11.909 EDT ] [CmdlineArgs.compareOraHome:229]  Oracle Home 1 = /opt/oracle/product/19c/dbhome_1
[main] [ 2021-06-15 04:56:11.909 EDT ] [CmdlineArgs.compareOraHome:230]  Oracle Home 2 = /opt/oracle/product/19c/dbhome_1
[main] [ 2021-06-15 04:56:11.909 EDT ] [CmdlineArgs.compareOraHome:237]  Returning true
[main] [ 2021-06-15 04:56:11.920 EDT ] [HASContext.<init>:128]  moduleInit = 7
[main] [ 2021-06-15 04:56:11.920 EDT ] [SRVMContext.init:186]  Performing SRVM Context init. Init Counter=1
[main] [ 2021-06-15 04:56:11.920 EDT ] [SRVMContext.init:197]  No CRS configuration found
[main] [ 2021-06-15 04:56:11.920 EDT ] [HASContext.<init>:139]  Initialised SRVMContext
[main] [ 2021-06-15 04:56:11.921 EDT ] [has.HASContextNative.Native]  prsr_trace: no lsf ctx, line=Native: allocHASContext

[main] [ 2021-06-15 04:56:11.921 EDT ] [has.HASContextNative.Native]  allocHASContext: module_init = 7
[main] [ 2021-06-15 04:56:11.921 EDT ] [has.HASContextNative.Native]  
 allocHASContext: META context [1]
[main] [ 2021-06-15 04:56:11.922 EDT ] [has.HASContextNative.Native]  
 allocHASContext: LSF context [1]
[main] [ 2021-06-15 04:56:11.922 EDT ] [has.HASContextNative.Native]  prsr_trace: Native: prsr_initSCLS

[main] [ 2021-06-15 04:56:11.922 EDT ] [has.HASContextNative.Native]  
 allocHASContext: SCLS context [1]
[main] [ 2021-06-15 04:56:11.923 EDT ] [has.HASContextNative.Native]  
 allocHASContext: retval [1]
[main] [ 2021-06-15 04:56:11.923 EDT ] [Util.<init>:105]  Util Instance created.
[main] [ 2021-06-15 04:56:11.924 EDT ] [has.UtilNative.Native]  prsr_trace: Native: getOracleUser

[main] [ 2021-06-15 04:56:11.924 EDT ] [has.UtilNative.Native]  prsr_trace: Native: prsr_getOracleUserID

[main] [ 2021-06-15 04:56:11.924 EDT ] [has.UtilNative.Native]  prsr_trace:     OH=/opt/oracle/product/19c/dbhome_1 SID=NULLSID

[main] [ 2021-06-15 04:56:11.925 EDT ] [has.UtilNative.Native]  prsr_trace: scls returned=0

[main] [ 2021-06-15 04:56:11.925 EDT ] [has.UtilNative.Native]  prsr_trace: Native: prsr_getUserName

[main] [ 2021-06-15 04:56:11.925 EDT ] [has.UtilNative.Native]  prsr_trace: Native: prsr_allocUserName

[main] [ 2021-06-15 04:56:11.925 EDT ] [has.UtilNative.Native]  prsr_trace: get_user_name_by_id ret=0, insz=32, sz=6, name=oracle

[main] [ 2021-06-15 04:56:11.926 EDT ] [has.UtilNative.Native]  prsr_trace: Native: getCurrentUser

[main] [ 2021-06-15 04:56:11.926 EDT ] [has.UtilNative.Native]  prsr_trace: Native: prsr_getUserName

[main] [ 2021-06-15 04:56:11.926 EDT ] [has.UtilNative.Native]  prsr_trace: Native: prsr_allocUserName

[main] [ 2021-06-15 04:56:11.926 EDT ] [has.UtilNative.Native]  prsr_trace: get_user_name_by_id ret=0, insz=32, sz=6, name=oracle

[main] [ 2021-06-15 04:56:11.927 EDT ] [has.UtilNative.Native]  prsr_trace: got uname=oracle

[main] [ 2021-06-15 04:56:11.929 EDT ] [InventoryUtil.getOUIInvSession:349]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2021-06-15 04:56:11.929 EDT ] [OracleHome.isClientHome:1816]  Homeinfo /opt/oracle/product/19c/dbhome_1,1
[Finalizer] [ 2021-06-15 04:56:11.978 EDT ] [Util.finalize:136]  Util: finalized called for oracle.ops.mgmt.has.Util@1feddc66
[main] [ 2021-06-15 04:56:12.075 EDT ] [InitialSetup.<init>:4162]  isClientHome: false
[main] [ 2021-06-15 04:56:12.079 EDT ] [InitialSetup.checkIfBigClusterAndHubNode:6245]  Not a cluster environment: exiting BigCluster Check
[main] [ 2021-06-15 04:56:12.079 EDT ] [InitialSetup.configureOPS:4726]  Cluster mode is OFF
[main] [ 2021-06-15 04:56:12.081 EDT ] [OPSUtil.getHomeVersion:446]  Inside getHomeVersion...
[main] [ 2021-06-15 04:56:12.081 EDT ] [OPSUtil.getHomeVersion:447]  oracleHome = /opt/oracle/product/19c/dbhome_1
[main] [ 2021-06-15 04:56:12.081 EDT ] [OPSUtil.getHomeVersion:451]  oracle.sysman.assistants.util.OracleHome Object = /opt/oracle/product/19c/dbhome_1
[main] [ 2021-06-15 04:56:12.081 EDT ] [OracleHome.getVersion:1066]  OracleHome.getVersion called.  Current Version: null
[main] [ 2021-06-15 04:56:12.083 EDT ] [InventoryUtil.getOUIInvSession:349]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2021-06-15 04:56:12.083 EDT ] [OracleHome.getVersion:1085]  Homeinfo /opt/oracle/product/19c/dbhome_1,1
[main] [ 2021-06-15 04:56:12.214 EDT ] [OracleHome.getVersion:1113]  OracleHome.server.getVersion Version: 19.0.0.0.0
[main] [ 2021-06-15 04:56:12.214 EDT ] [OracleHome.getVersion:1134]  Current Version From Inventory: 19.0.0.0.0
[main] [ 2021-06-15 04:56:12.214 EDT ] [OPSUtil.getHomeVersion:452]  returning oracleHome Version = 19.0.0.0.0
[main] [ 2021-06-15 04:56:12.214 EDT ] [OracleHome.getVersion:1066]  OracleHome.getVersion called.  Current Version: 19.0.0.0.0
[main] [ 2021-06-15 04:56:12.215 EDT ] [OracleHome.getVersion:1134]  Current Version From Inventory: 19.0.0.0.0
[main] [ 2021-06-15 04:56:12.240 EDT ] [InitialSetup.<init>:4201]  Admin location is: /opt/oracle/product/19c/dbhome_1/network/admin/
[main] [ 2021-06-15 04:56:12.254 EDT ] [ConfigureProfile.setProfileParam:140]  Setting NAMES.DIRECTORY_PATH: (TNSNAMES, EZCONNECT)
[main] [ 2021-06-15 04:56:12.262 EDT ] [Version.isPre:757]  version to be checked 19.0.0.0.0 major version to check against 10
[main] [ 2021-06-15 04:56:12.262 EDT ] [Version.isPre:768]  isPre.java: Returning FALSE
[main] [ 2021-06-15 04:56:12.263 EDT ] [Version.isPre:757]  version to be checked 19.0.0.0.0 major version to check against 10
[main] [ 2021-06-15 04:56:12.263 EDT ] [Version.isPre:768]  isPre.java: Returning FALSE
[main] [ 2021-06-15 04:56:12.263 EDT ] [Version.isPre:757]  version to be checked 19.0.0.0.0 major version to check against 11
[main] [ 2021-06-15 04:56:12.263 EDT ] [Version.isPre:768]  isPre.java: Returning FALSE
[main] [ 2021-06-15 04:56:12.263 EDT ] [Version.isPre:789]  version to be checked 19.0.0.0.0 major version to check against 11 minor version to check against 2
[main] [ 2021-06-15 04:56:12.263 EDT ] [Version.isPre:798]  isPre: Returning FALSE for major version check
[main] [ 2021-06-15 04:56:12.264 EDT ] [UnixSystem.isHAConfigured:3609]  olrFileName = /etc/oracle/olr.loc
[main] [ 2021-06-15 04:56:12.264 EDT ] [InitialSetup.checkHAConfiguration:4914]  HA Server is NOT configured.
[main] [ 2021-06-15 04:56:12.266 EDT ] [NetCAResponseFile.<init>:75]  Response file initialized: /opt/oracle/product/19c/dbhome_1/network/install/netca_typ.rsp
[main] [ 2021-06-15 04:56:12.266 EDT ] [NetCAResponseFile.getInstalledComponents:114]  Installed components from response file: server, net8, javavm
[main] [ 2021-06-15 04:56:12.266 EDT ] [NetCAResponseFile.getVirtualHost:171]  Virtual Host from response file: null
[main] [ 2021-06-15 04:56:12.266 EDT ] [SilentConfigure.performSilentConfigure:226]  Custom listener configuration.
[main] [ 2021-06-15 04:56:12.267 EDT ] [SilentConfigure.silentConfigureListener:292]  Listener name from command line: LISTENER
[main] [ 2021-06-15 04:56:12.267 EDT ] [SilentConfigure.silentConfigureListener:315]  Listener port from command line: 1521, Address: TCP;1521
[main] [ 2021-06-15 04:56:12.267 EDT ] [ConfigureListener.isHASConfigured:1707]  Calling SRVM api to check if Oracle Restart is configured ...
[main] [ 2021-06-15 04:56:12.267 EDT ] [Version.isPre:757]  version to be checked 19.0.0.0.0 major version to check against 10
[main] [ 2021-06-15 04:56:12.267 EDT ] [Version.isPre:768]  isPre.java: Returning FALSE
[main] [ 2021-06-15 04:56:12.267 EDT ] [Version.isPre:757]  version to be checked 19.0.0.0.0 major version to check against 10
[main] [ 2021-06-15 04:56:12.268 EDT ] [Version.isPre:768]  isPre.java: Returning FALSE
[main] [ 2021-06-15 04:56:12.268 EDT ] [Version.isPre:757]  version to be checked 19.0.0.0.0 major version to check against 11
[main] [ 2021-06-15 04:56:12.268 EDT ] [Version.isPre:768]  isPre.java: Returning FALSE
[main] [ 2021-06-15 04:56:12.268 EDT ] [Version.isPre:789]  version to be checked 19.0.0.0.0 major version to check against 11 minor version to check against 2
[main] [ 2021-06-15 04:56:12.268 EDT ] [Version.isPre:798]  isPre: Returning FALSE for major version check
[main] [ 2021-06-15 04:56:12.268 EDT ] [UnixSystem.isHAConfigured:3609]  olrFileName = /etc/oracle/olr.loc
[main] [ 2021-06-15 04:56:12.269 EDT ] [ConfigureListener.isHASConfigured:1717]  Is Oracle Restart configured: false
[main] [ 2021-06-15 04:56:12.269 EDT ] [ConfigureListener.isHASRunning:1746]  Is Oracle Restart running: false
[main] [ 2021-06-15 04:56:12.270 EDT ] [ConfigureListener.listenerExists:443]  Is listener "LISTENER" already exists: false
[main] [ 2021-06-15 04:56:12.271 EDT ] [SilentConfigure.silentConfigureListener:358]  Protocol TCP;1521
[main] [ 2021-06-15 04:56:12.271 EDT ] [SilentConfigure.silentConfigureListener:368]  ProtocolName 0 tcp
[main] [ 2021-06-15 04:56:12.271 EDT ] [SilentConfigure.silentConfigureListener:369]  PortValue 0 1521
[main] [ 2021-06-15 04:56:12.271 EDT ] [ConfigureListener.validateEndPoint:1127]  Validating end-point: TCP:1521
[main] [ 2021-06-15 04:56:12.273 EDT ] [ConfigureListener.validateEndPoint:1146]  Address String : (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
[main] [ 2021-06-15 04:56:12.310 EDT ] [ConfigureListener.validateEndPoint:1150]  AddressBusy return code : 0
[main] [ 2021-06-15 04:56:12.310 EDT ] [ConfigureListener.isPortFree:1211]  Checking if port 1521 is free on local machine...
[main] [ 2021-06-15 04:56:12.310 EDT ] [ConfigureListener.isPortFree:1226]  InetAddress.getByName(127.0.0.1): /127.0.0.1
[main] [ 2021-06-15 04:56:12.310 EDT ] [ConfigureListener.isPortFree:1228]  Local host IP address: iZj6c55u1570vkjx6biy49Z/127.0.0.1
[main] [ 2021-06-15 04:56:12.311 EDT ] [ConfigureListener.isPortFree:1230]  Local host name: iZj6c55u1570vkjx6biy49Z
[main] [ 2021-06-15 04:56:12.311 EDT ] [ConfigureListener.isPortFree:1241]  Address iZj6c55u1570vkjx6biy49Z
[main] [ 2021-06-15 04:56:12.311 EDT ] [ConfigureListener.isPortFree:1303]  No IP address returned for host. iZj6c55u1570vkjx6biy49Z
[main] [ 2021-06-15 04:56:12.311 EDT ] [SilentConfigure.silentConfigureListener:398]  oracle.net.ca.IllegalEndpointException: No valid IP Address returned for the host iZj6c55u1570vkjx6biy49Z.
[main] [ 2021-06-15 04:56:12.311 EDT ] [SilentConfigure.silentConfigureListener:420]  Start listeners LISTENER
[main] [ 2021-06-15 04:56:12.313 EDT ] [SilentConfigure.silentConfigureListener:426]  Following Listeners were configured : 
[main] [ 2021-06-15 04:56:12.313 EDT ] [SilentConfigure.silentConfigureListener:427]  Following Listeners will be started, if they are found in configured list : LISTENER
[main] [ 2021-06-15 04:56:12.313 EDT ] [NetCAResponseFile.getNamingMethods:318]  Naming methods from response file: TNSNAMES, ONAMES, HOSTNAME
[main] [ 2021-06-15 04:56:12.313 EDT ] [SilentConfigure.performSilentConfigure:236]  Custom profile configuration.
[main] [ 2021-06-15 04:56:12.313 EDT ] [NetCAResponseFile.getNamingMethods:318]  Naming methods from response file: TNSNAMES, ONAMES, HOSTNAME
[main] [ 2021-06-15 04:56:12.313 EDT ] [NetCAResponseFile.getNSNNumbers:347]  NSN Numbers from response file: 0

qiaofeng1227 commented 3 years ago

https://www.cnblogs.com/piwefei/p/11171063.html

qiaofeng1227 commented 3 years ago

oracle 版本排名调查

qiaofeng1227 commented 3 years ago

提示用户自行下载软件包放在固定路径，运行ansible命令一键安装

qiaofeng1227 commented 3 years ago

https://blog.csdn.net/wujiandao/article/details/103470585

chendelin1982 commented 3 years ago

用户体验设计参考：

用户远程桌面到Linux
打开桌面的浏览器Firefox
下载安装包到服务中
启动安装脚本

qiaofeng1227 commented 3 years ago

[root@iZj6ca8gubfjvuivk7lhlvZ ~]# cat /etc/sysconfig/oracledb_ORCLCDB-19c.conf
#This is a configuration file to setup the Oracle Database. 
#It is used when running '/etc/init.d/oracledb_ORCLCDB configure'.
#Please use this file to modify the default listener port and the
#Oracle data location.

# LISTENER_PORT: Database listener
LISTENER_PORT=1521

# ORACLE_DATA_LOCATION: Database oradata location
ORACLE_DATA_LOCATION=/opt/oracle/oradata

# EM_EXPRESS_PORT: Oracle EM Express listener
EM_EXPRESS_PORT=5500
[root@iZj6ca8gubfjvuivk7lhlvZ ~]#

qiaofeng1227 commented 3 years ago

ORACLE_DATA_LOCATION=/data/apps/oracle

qiaofeng1227 commented 3 years ago

[root@iZj6ca8gubfjvuivk7lhlvZ init.d]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

zengxc-1996 commented 3 years ago

[oracle@iZj6c5lfa9l895etuoks5tZ ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 19 14:37:41 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> select username,password from dba_users;
select username,password from dba_users
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORACLE.ora'

cp /opt/oracle/product/19c/dbhome_1/dbs/init.ora /opt/oracle/product/19c/dbhome_1/dbs/initORACLE.ora

[oracle@iZj6c5lfa9l895etuoks5tZ ~]$ sqlplus  sys/change_on_install as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 19 14:58:00 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup open hstestdb
ORA-00845: MEMORY_TARGET not supported on this system
SQL>

zengxc-1996 commented 3 years ago

解决方案

1.初始化参数MEMORY_TARGET或MEMORY_MAX_TARGET不能大于共享内存(/dev/shm),为了解决这个问题，可以增大/dev/shm

如：

mount -t tmpfs shmfs -o size=8g /dev/shm

2.修改/etc/fstab文件

tmpfs /dev/shm tmpfs defaults,size=1G 0 0

size的值小于/dev/shm即可

然后重启数据库即可

zengxc-1996 commented 3 years ago

[oracle@iZj6c5lfa9l895etuoks5tZ ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 19 16:17:22 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux-x86_64 Error: 2: No such file or directory
SQL>

zengxc-1996 commented 3 years ago

oracledb can startup

but thereis a error:

SQL> startup
ORACLE instance started.

Total System Global Area 1073737800 bytes
Fixed Size          8904776 bytes
Variable Size         616562688 bytes
Database Buffers      440401920 bytes
Redo Buffers            7868416 bytes
ORA-00205: error in identifying control file, check alert log for more info

zengxc-1996 commented 3 years ago

Oracle启动需要经历四个状态:SHUTDOWN 、NOMOUNT 、MOUNT 、OPEN

Oracle关闭的四种方式：Normal, Immediate, Transactional, Abort

startup

shutdown abort

zengxc-1996 commented 3 years ago

报错参考

zengxc-1996 commented 3 years ago

control file:

SQL> show parameter control_files;

NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
control_files                string  /opt/oracle/oradata/ORCLCDB/co
                         ntrol01.ctl, /opt/oracle/orada
                         ta/ORCLCDB/control02.ctl

zengxc-1996 commented 3 years ago

aliyun centos 7.x: 2c 4g

[oracle@iZj6cdcdal1ed4cqd32o1pZ dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 21 14:39:29 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00104: '/opt/oracle' is not a legal integer for 'db_recovery_file_dest_size'
SQL>

aliyun centos 7.x: 4c16g

[oracle@iZj6cdy96p2tjgceyevws4Z ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 21 14:42:08 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1073737800 bytes
Fixed Size          8904776 bytes
Variable Size         616562688 bytes
Database Buffers      440401920 bytes
Redo Buffers            7868416 bytes
ORA-00205: error in identifying control file, check alert log for more info

zengxc-1996 commented 3 years ago

alert log file:

/opt/oracle/diag/rdbms/orcl/ORACLEDB/trace/alert_ORACLEDB.log

qiaofeng1227 commented 3 years ago

https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/using-sql-plus-to-unlock-accounts-and-reset-passwords.html#GUID-1147D2B9-8FFC-4F91-A774-E97066B4E9C5

qiaofeng1227 commented 3 years ago

- name: Oracle DB ENV configure, defeaut SID is ORCLCDB
  blockinfile:
    path: /home/oracle/.bash_profile
    owner: oracle
    block: |
      export ORACLE_BASE=/opt/oracle
      export ORACLE_HOME=/opt/oracle/product/{{oracledb_version}}/dbhome_1
      export ORACLE_SID=ORCLCDB
      export PATH=$PATH:$ORACLE_HOME/bin
  become: true
  become_user: oracle

qiaofeng1227 commented 3 years ago

listener.ora

# listener.ora Network Configuration File: /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = iZj6cdy96p2tjgceyevws4Z)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
         (GLOBAL_DBNAME=ORCLCDB)
         (SID_NAME=ORCLCDB)
         (ORACLE_HOME=/opt/oracle/product/19c/dbhome_1)
       )
   )

ADR_BASE_LISTENER = /opt/oracle/

qiaofeng1227 commented 3 years ago

sqlnet.ora

# sqlnet.ora Network Configuration File: /opt/oracle/product/19c/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11

qiaofeng1227 commented 3 years ago

tnsnames.ora

# tnsnames.ora Network Configuration File: /opt/oracle/product/19c/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCLCDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = iZj6cdy96p2tjgceyevws4Z)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCLCDB)
    )
  )

LISTENER_ORCLCDB =
  (ADDRESS = (PROTOCOL = TCP)(HOST = iZj6cdy96p2tjgceyevws4Z)(PORT = 1521))

qiaofeng1227 commented 3 years ago

Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/iZj6cdy96p2tjgceyevws4Z/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=iZj6cdy96p2tjgceyevws4Z)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "ORCLCDB" has 1 instance(s).
  Instance "ORCLCDB", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

qiaofeng1227 commented 3 years ago

重启配置后需要更改用户名：ALTER USER system IDENTIFIED BY Qiaofeng1228;

qiaofeng1227 commented 3 years ago

1, system user, remote access

oracle listener
em https，desktop

zengxc-1996 commented 3 years ago

how to connection oracle web gui ?

https://47.242.198.228:5500/em/login

qiaofeng1227 commented 3 years ago

install need linux of gui

 Oracle SQL Developer
 Copyright (c) 2005, 2020, Oracle and/or its affiliates. All rights reserved.

Exception in thread "main" java.awt.AWTError: Can't connect to X11 window server using 'localhost:10.0' as the value of the DISPLAY variable.
    at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
    at sun.awt.X11GraphicsEnvironment.access$200(X11GraphicsEnvironment.java:65)
    at sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:115)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:74)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:264)
    at java.awt.GraphicsEnvironment.createGE(GraphicsEnvironment.java:103)
    at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:82)
    at javax.swing.RepaintManager.<clinit>(RepaintManager.java:233)
    at javax.swing.JComponent.repaint(JComponent.java:4792)
    at java.awt.Component.repaint(Component.java:3311)
    at javax.swing.AbstractButton.setModel(AbstractButton.java:1784)
    at javax.swing.JToggleButton.<init>(JToggleButton.java:171)
    at javax.swing.JCheckBox.<init>(JCheckBox.java:174)
    at javax.swing.JCheckBox.<init>(JCheckBox.java:96)
    at oracle.ide.osgi.boot.LauncherUtil.verifyJdkVersion(LauncherUtil.java:173)
    at oracle.ide.osgi.boot.LauncherUtil.checkLaunchPrerequisites(LauncherUtil.java:129)
    at oracle.ide.osgi.boot.LauncherUtil.initialize(LauncherUtil.java:101)
    at oracle.ide.osgi.boot.OracleIdeLauncher.main(OracleIdeLauncher.java:80)
[root@iZ8vb9fnmvw0uo7n2i2dtvZ sqldeveloper]#

qiaofeng1227 commented 3 years ago

https://www.oracle.com/database/technologies/appdev/db-actions.html https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html

Formerly known as SQL Developer Web, Database Actions brings you your favorite Oracle Database https://www.oracle.com/database/technologies/appdev/rest-data-services-downloads.html

qiaofeng1227 commented 3 years ago

step:

install jdk
form above url download ords-21.1.3.153.1102.zip and unzip

server:

Using SQLcl or SQL*Plus, connect to Oracle PDB or 11g database with SYSDBA privileges.
Execute the following script providing the database user:
SQL> @/path/to/installer/ords_installer_privileges.sql exampleuser
SQL> exit

java -jar ords.war install advanced（Enter the parameters according to the prompts）


Connecting to database user: xuwei url: jdbc:oracle:thin:@47.243.191.167:1521:ORCLCDB
ORA-01017: invalid username/password; logon denied
Try again. Enter the administrator username:system
Enter the database password for system:
Confirm password:
Connecting to database user: system url: jdbc:oracle:thin:@47.243.191.167:1521:ORCLCDB
Install, upgrade, validate or uninstall ORDS in the CDB requires you to login as SYS AS SYSDBA
Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA:
Confirm password:
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@47.243.191.167:1521:ORCLCDB

Error cannot install/upgrade ORDS into the CDB because the container requires to be in READ WRITE mode. PDB ORCLPDB1 - MOUNTED

qiaofeng1227 commented 3 years ago

simple mode & no Interactive

java -jar ords.war install --parameterFile /path/to/my_params.properties simple

db.hostname=localhost
db.port=1521
db.servicename=orcl.example.com
plsql.gateway.add=false
rest.services.apex.add=false
rest.services.ords.add=true
schema.tablespace.default=SYSAUX
schema.tablespace.temp=TEMP
standalone.https.port=8443
standalone.mode=true
standalone.ssl.cert.path=/path/to/ssl/cert
standalone.ssl.host=mysecurehost
standalone.ssl.key.path=/path/to/ssl/key
standalone.use.https=true
standalone.use.ssl.cert=true
user.public.password=password
user.tablespace.default=SYSAUX
user.tablespace.temp=TEMP

zengxc-1996 commented 3 years ago

update container read write: ALTER PLUGGABLE DATABASE ORCLPDB1 OPEN READ WRITE;

check: show pdbs;

Install ords:

Unable to access after installation

qiaofeng1227 commented 3 years ago

从oracle12c开始em控制台只需简单启用即可。不过19c em只能查看性能页，而12c的em包括配置，用户所有功能都可以操作。精简掉太多功能了。

chendelin1982 commented 2 years ago

use docker

Websoft9Archive / ansible-oracledatabase

oracle enterprise version download installation #1