Generate tnsnames.ora from up to date OEM using sqlcl
No it is not required to use sqlcl for this. sqlplus or any other sql execution tool of your choice […]
No it is not required to use sqlcl for this. sqlplus or any other sql execution tool of your choice […]
Is there an equivalent Windows command to the Linux command which ? Yep, it is “where”. C:\sqldeveloper-17.2.0.188.1159-x64\sqlcl-17.2.0.184.1230-no-jre\sqlcl\bin>where java C:\ProgramData\Oracle\Java\javapath\java.exe or
For large Oracle Database footprints – say 8GB or above (not really too large any more) configure Linux huge pages
While using dataguard broker is optional with Dataguard, using it adds some complexity and flexibility – expect a little learning
# When DATABASE_ROLE=”PHYSICAL STANDBY” AND “MOUNTED” is the result for OPEN_MODE – the standby is NOT in active dataguard mode,
Start Task Manager – Ctl-Alt-Del or search for control panel. Select performance Select CPU – Up Time is a the
ALTER SESSION SET CURRENT_SCHEMA = <schema name>;
Show ASM status srvctl status asm Show more detailed ASM configuration srvctl config asm sqlplus login to ASM sqlplus /
Prerequisites On the new host… RMAN backups are run on the source – level 0 full, and 5 incremental level
511 disk groups 10,000 disks across all disk groups 128GB – The largest Oracle database datafile that can be created