Oracle Database knowledge sharing site

Latest Comments

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 -

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



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


12/06/20 @ 15:14
Shannon Ju

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, , contains the correct information in Table 2-2 Schema Creation Steps for Limited-Privilege Users

12/06/20 @ 14:50

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

05/02/20 @ 19:56

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 -

Krasimir Kovachki

25/07/18 @ 12:41
Julien Andonov

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

#file ~/

# 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"

At least this is what I used :)

Best regards
Julien Andonov

25/07/18 @ 10:16

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!
Krasimir Kovachki

23/11/17 @ 23:04


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

PL/SQL procedure successfully completed.
—————————————————————- ————— —– —————–
Audit Options 2 FALSE
Automatic Maintenance - Optimizer Statistics Gathering 2 FALSE
Automatic Maintenance - Space Advisor 2 FALSE
Automatic SGA Tuning 2 FALSE
Automatic SQL Execution Memory 2 FALSE
Automatic Segment Space Management (system) 2 FALSE
Automatic Undo Management 2 FALSE
Character Set 2 FALSE
Deferred Segment Creation 2 FALSE
HeapCompression 1 TRUE
Locally Managed Tablespaces (system) 2 FALSE

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

As per the above is visible update on Restore Point 1 FALSE 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.

03/03/17 @ 10:25

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.
Krasimir Kovachki

20/01/17 @ 15:38