Krasimir Kovachki

Hello Shannon Ju,

Yes, this is correct as per the above information this is visible but what is very important here is that you don’t need all this!!!!

Very simple - check this - https://blog.dba.bg/index.php/kkovachki/weblogic/oracle-cloud-with-weblogic-and-atp-database-rcu-schema-creation-silent

The main problem is that RCU is not ready for ATP at all

If you check what I give you as a link, you can see that you don’t execute rcu with sysdba but with normal admin user which is just high privileges user.

Add this special environment:

export RCU_LOG_LOCATION=/opt/oracle;export RCU_SSL_MODE=true;export RCU_SKIP_PRE_REQS=ALL

RCU - in silent mode - we run like this

-dbUser ADMIN

-dbRole normal

-useSSL

-sslArgs

Now let’s go back to RCU with GUI, we don’t have a lot of options compare to rcu in silent mode

Regards,

We found that “script_postDataLoad” should be run AFTER step “perform product load” in RCU. When we ran it before, like what you show here, it generated the same error “ORA-00980″, and we failed to run “dataLoad” using RCU command in silent-mode.

Official document,  https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.3/rcuug/obtaining-and-running-repository-creation-utility.html#GUID-7DBA5CB7-0107-48B1-A154-C01236693E3E , contains the correct information in Table 2-2 Schema Creation Steps for Limited-Privilege Users

You need to download ojdbc-full.. check post section -
Update: 22.01.2020
ATP documentation in regards to connection
Copy ojdbc8-full.tar.gz to $MW_HOME/oracle_common/modules/oracle.jdbc
cp /tmp/ojdbc8-full.tar.gz $MW_HOME/oracle_common/modules/oracle.jdbc
untar ojdbc8-full.tar.gz
tar -zcvf ojdbc8-full.tar.gz
Go inside in the folder ojdbc8-full
cd ojdbc8-full/
Copy all files into $MW_HOME/oracle_common/modules/oracle.jdbc
you need to export TNS_ADMIN location

Also i find the way to be more easy but i will share very soon

I am trying same but getting I/O Error: General SSLEngine in very first step of Start RCU.
Any clue?

Thanks Polya, You are the next one :)

Great article!

Thanks PolyaPro, where is your new post? :)

Great article! Thanks for the knowledge sharing! :)

Hello Simo,
You are very welcome!!!!
Please send us your issue?
Regards,
Krasi

Simo: Krasi , again I used this article, thanks :)

Hello Julien,

Thanks for your feedback!

Unfortunately based on my experience everything depends of the Linux version , virtualization etc.
Such script may not work in some case and i prefere to collect information from command “udevadm info –name sdb” prior selecting one rule or other

ps: check this out - https://fritshoogland.wordpress.com/2016/02/19/oracle-linux-7-disks-and-udev/

Regards,
Krasimir Kovachki

Hey Krasi
Feel free to use the following script for the asm disks:


#!/bin/bash
#file ~/createOracleAsmUdevRules.sh

i=1
# ol7 / rhel7 / centos 7
cmd="/lib/udev/scsi_id -g -u -d"
for disk in sdc sdd sde sdf ; do
cat <<EOF >> /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="$cmd /dev/\$parent", \
RESULT=="`$cmd /dev/$disk`", SYMLINK+="asm-disk$i", OWNER="oracle", GROUP="dba", MODE="0660"
EOF
i=$(($i+1))
done

At least this is what I used :)

Best regards
Julien Andonov

Hello Anuranjan,

Normally you should not specify any changes on local_listener, this will be done automatically, because each local listener has own configuration in regards to network/ip/port.
The only listener configuration which is required is .remote_listener but this is point for all scans which by default is there.

Thanks for your feedback!
Regards,
Krasimir Kovachki

This must be update in case Change local_listener is there -

local_listener as per new node - by below command.

alter system set local_listener=’(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hoexp03-vip.ad.bgep.co.uk)(PORT=1521)))’ sid=’instance_name’;

Good to know ….

I am adding a link that can save us some time trying to find the GI PSU’s download link for GI 12.1.0.2.

12.1.0.2 Grid Infrastructure Patch Set Updates - List of Fixes in each GI PSU (Doc ID 1928853.1)

;)

Hello

Thanks for your feedback, point on the feature usage is absolutely correct..
my test is following

SQL> EXEC DBMS_FEATURE_USAGE_INTERNAL.exec_db_usage_sampling(SYSDATE);
PL/SQL procedure successfully completed.
SQL>
NAME DETECTED_USAGES CURRE VERSION
—————————————————————- ————— —– —————–
Audit Options 2 FALSE 11.2.0.4.0
Automatic Maintenance - Optimizer Statistics Gathering 2 FALSE 11.2.0.4.0
Automatic Maintenance - Space Advisor 2 FALSE 11.2.0.4.0
Automatic SGA Tuning 2 FALSE 11.2.0.4.0
Automatic SQL Execution Memory 2 FALSE 11.2.0.4.0
Automatic Segment Space Management (system) 2 FALSE 11.2.0.4.0
Automatic Undo Management 2 FALSE 11.2.0.4.0
Character Set 2 FALSE 11.2.0.4.0
Deferred Segment Creation 2 FALSE 11.2.0.4.0
HeapCompression 1 TRUE 11.2.0.4.0
Locally Managed Tablespaces (system) 2 FALSE 11.2.0.4.0

NAME DETECTED_USAGES CURRE VERSION
—————————————————————- ————— —– —————–
Locally Managed Tablespaces (user) 2 FALSE 11.2.0.4.0
Oracle Java Virtual Machine (system) 2 FALSE 11.2.0.4.0
Partitioning (system) 2 FALSE 11.2.0.4.0
Recovery Area 2 FALSE 11.2.0.4.0
Restore Point 1 FALSE 11.2.0.4.0
SecureFiles (system) 2 FALSE 11.2.0.4.0
SecureFiles (user) 2 FALSE 11.2.0.4.0
Server Parameter File 2 FALSE 11.2.0.4.0
Services 2 FALSE 11.2.0.4.0
Virtual Private Database (VPD) 2 FALSE 11.2.0.4.0
21 rows selected.

As per the above is visible update on Restore Point 1 FALSE 11.2.0.4.0 but we perform flashback database which is other story, as per the documentation flashback database should be visible if you trigger such action.

Also keep in mind that we did flashback database from enterprise edition and then open resetlogs database from standard edition .

Thanks ones again.
Krasi

Hi Krasi,

Did you force the view to be updated by using the DBMS_FEATURE_USAGE_INTERNAL package? By default the feature usage view is updated about once per week.

EXEC DBMS_FEATURE_USAGE_INTERNAL.exec_db_usage_sampling(SYSDATE);

Very useful trick Krasi!

Hello Dhananjay,

Thanks for your feedback,
Normally you should add in the file for analyzes full inventory information -> after command opatch lsinv, this should perform required checks and will provide possible solution in case of conflicts.
If you have conflicts, then you will see possibility to requires merge patches.

Download All - will be valid only in case if you request merge patches….

Please can you share more information in order to perform such checks from my side.
Regards,
Krasimir Kovachki

Hi Krasmir,

Indeed a very good guide note.
But i’m facing error in section “Download All” as “Patch Request failed - See details”

A request could not be created for this Oracle Home.Retry Request

Hoping a suggestion, thanks