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 - https://fritshoogland.wordpress.com/2016/02/19/oracle-linux-7-disks-and-udev/

Regards,
Krasimir Kovachki

25/07/18 @ 15:41
Julien Andonov

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

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

24/11/17 @ 01:04

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

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

20/01/17 @ 17:38