Oracle Database knowledge sharing site

Latest Comments

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 @ 21: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 @ 15: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 @ 13: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

24/11/17 @ 01: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 @ 12: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 @ 17:38