There are a lot of testing on the way how to create RCU schemas on ATP database with the normal Admin user, its look like that there are some tricks :)
I spend a lot of time debugging and testing the issue and the only way that preliminary is visible is that the process should be divided in a few steps.
- script generation
- execute generated scripts with sqlplus
- data load
hmm... after some time I take a look into Oracle Marketplace to check what kind of images with WebLogic are there... and guess what I find out?
WebLogic Standard Edition with the possibility to integrate with ATP database or Database on VM -( Database Service )
If Oracle has already Weblogic integration with ATP database, this means that all that I need is to find out how they manage to create such RCU schemas with admin user.
--- you can check full story for WebLogic creating using an image from Marketplace - here soon
What is the scope of this post?
I will share tips and tricks on how to create RCU schemas with some special parameters in order to avoid prerequisite checks
Let's start
You need to download your ATP Wallet and unzip in the below location ( or change based on your needs )
/opt/oracle/private/wallet |
This is very powerful parameters in order to force RCU to create createRepository with admin user which is not SYSDBA as requirement :)
export RCU_LOG_LOCATION=/opt/oracle;export RCU_SSL_MODE=true;export RCU_SKIP_PRE_REQS=ALL
|
You have to execute the below all at one line, I just add it like this to be easy to read :)
/opt/oracle/java/jdk1.8.0_241/bin/java -Djava.security.egd=file:///dev/./urandom -DRCU_HOME=/opt/oracle/middleware/oracle_common -DSQLPLUS_HOME=/opt/oracle/middleware -DORACLE_HOME=/opt/oracle/middleware -DRCU_LOG_LEVEL=NOTIFICATION -DRCU_TIMESTAMP_LOG_DIR=true -DLAUNCH_MODE=-mx128m -DLD_LIBRARY_PATH=/opt/oracle/middleware/lib32: /opt/oracle/middleware/network/lib32: /opt/oracle/middleware/lib: /opt/oracle/middleware/network/lib -classpath /opt/oracle/middleware/oracle_common/jlib/rcu.jar: /opt/oracle/middleware/oracle_common/jlib/rchlp.jar oracle.sysman.assistants.rcu.Rcu -silent -createRepository -connectString '(description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=XXXXXXXX_testdb_tp.atp.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.eucom-central-1.oraclecloud.com,OU=Oracle BMCS FRANKFURT,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))' -dbUser ADMIN -dbRole normal -useSSL -sslArgs javax.net.ssl.trustStore=/opt/oracle/private/wallet/truststore.jks, javax.net.ssl.keyStoreType=JKS, javax.net.ssl.keyStore=/opt/oracle/private/wallet/keystore.jks, javax.net.ssl.trustStoreType=JKS, oracle.net.ssl_server_dn_match=true, oracle.net.ssl_version=1.2 -sslPasswordArgNames javax.net.ssl.keyStorePassword, javax.net.ssl.trustStorePassword -schemaPrefix FMW12213 -component MDS -tablespace DATA -temptablespace TEMP -component WLS -tablespace DATA -temptablespace TEMP -component STB -tablespace DATA -temptablespace TEMP -component IAU_APPEND -tablespace DATA -temptablespace TEMP -component IAU_VIEWER -tablespace DATA -temptablespace TEMP -component UCSUMS -tablespace DATA -temptablespace TEMP -component IAU -tablespace DATA -temptablespace TEMP -component OPSS -tablespace DATA -temptablespace TEMP -serverDN 'CN=adwc.eucom-central-1.oraclecloud.com,OU=Oracle BMCS FRANKFURT,O=Oracle Corporation,L=Redwood City,ST=California,C=US'
|
The outcome of the execution
RCU Logfile: /u01/logs/RCU2020-01-29_16-28_193725691/logs/rcu.log
RCU-6069:Warning : Database connect string specified is not in recommended format. Refer to RCU help for supported connect string formats. Continuing execution.
Enter the password for SSL property: javax.net.ssl.keyStorePassword < Add here password from the wallet > Enter the password for SSL property: javax.net.ssl.trustStorePassword < Add here password from the wallet > Enter the database password(User:ADMIN): < Add here password for Admin user >
Processing command line .... Repository Creation Utility - Checking Prerequisites Checking Global Prerequisites Enter the schema password for [FMW12213_MDS]: < Add here password for each new schema/user > Enter the schema password for [FMW12213_WLS]: < Add here password for each new schema/user > Enter the schema password for [FMW12213_WLS_RUNTIME]: < Add here password for each new schema/user > Enter the schema password for [FMW12213_STB]: < Add here password for each new schema/user > Enter the schema password for [FMW12213_IAU_APPEND]: < Add here password for each new schema/user > Enter the schema password for [FMW12213_IAU_VIEWER]: < Add here password for each new schema/user > Enter the schema password for [FMW12213_UMS]: < Add here password for each new schema/user > Enter the schema password for [FMW12213_IAU]: < Add here password for each new schema/user > Enter the schema password for [FMW12213_OPSS]: < Add here password for each new schema/user >
Repository Creation Utility - Checking Prerequisites Checking Component Prerequisites Repository Creation Utility - Creating Tablespaces Validating and Creating Tablespaces Repository Creation Utility - Create Repository Create in progress. Percent Complete: 19 ----- CUT ------ Percent Complete: 100
Repository Creation Utility: Create - Completion Summary
Database details: ----------------------------- Connect Descriptor : <Connection string> Connected As : ADMIN Prefix for (prefixable) Schema Owners : FMW12213 RCU Logfile : /u01/logs/RCU2020-01-29_16-28_193725691/logs/rcu.log
Component schemas created: ----------------------------- Component Status Logfile Common Infrastructure Services Success /u01/logs/RCU2020-01-29_16-28_193725691/logs/stb.log Oracle Platform Security Services Success /u01/logs/RCU2020-01-29_16-28_193725691/logs/opss.log User Messaging Service Success /u01/logs/RCU2020-01-29_16-28_193725691/logs/ucsums.log Audit Services Success /u01/logs/RCU2020-01-29_16-28_193725691/logs/iau.log Audit Services Append Success /u01/logs/RCU2020-01-29_16-28_193725691/logs/iau_append.log Audit Services Viewer Success /u01/logs/RCU2020-01-29_16-28_193725691/logs/iau_viewer.log Metadata Services Success /u01/logs/RCU2020-01-29_16-28_193725691/logs/mds.log WebLogic Services Success /u01/logs/RCU2020-01-29_16-28_193725691/logs/wls.log
Repository Creation Utility - Create : Operation Completed
|
Now you can start with the Domain creation using ATP RCU schema which is already created :)
Have fun!