Oracle 19c on Linux 8 Installation Tips
Oracle 19c on Linux 8 Installation Tips
Virtualbox Upgrade error Tips
There is the following error after the update virtualbox version and can NOT create network in virutualbox
VBoxNetAdpCtl: Error while adding new interface: failed to open /dev/vboxnetctl: No such file or directory.
Use the following command in command line.
sudo "/Library/Application Support/VirtualBox/LaunchDaemons/VirtualBoxStartup.sh" restart
sudo /Library/Application\ Support/VirtualBox/LaunchDaemons/VirtualBoxStartup.sh restart
Mac System Preferences/security&Privacy/General -> allow and restart!
Have a good work&life! 2021/07 via LinHong
Oracle Index - Statics Tips
Oracle Index - invisible Tips
Oracle sqlplus plugin rlwrap install Tips
Windows 10 Enable Hyper-V Tips
Oracle Create PDB Tips
Using nologging to reduce the time of creating pdb.
21:48:29 SYS@PRODCDB> @1.sql
21:48:30 SYS@PRODCDB> create pluggable database pdbprod3 from pdbprod1 file_name_convert=('PDBPROD1','PDBPROD3') nologging;
Pluggable database created.
21:49:00 SYS@PRODCDB>
21:49:18 SYS@PRODCDB> @2.sql
21:49:18 SYS@PRODCDB> create pluggable database pdbprod6 from pdbprod1 file_name_convert=('PDBPROD1','PDBPROD6');
Pluggable database created.
21:50:02 SYS@PRODCDB>
nologging: 30 seconds
logging : 34 seconds
Create Pluggable database PDB Tips
Administrator's Guide
--> 38 Creating and Removing PDBs with SQL*Plus
--> Creating a PDB by Cloning an Existing PDB or Non-CDB
--> Cloning a Local PDB
Oracle Exadata Startup Shutdown Tips
Shutdown and Startup Exadata
Oracle AWR Exadata Alert Tips
There is Critial alert in AWR report like the following.
Linux network issue Tips
Problems:
Restart Linux 6 in vmware and met “Device eth0 does not seem to be present” for network service.
(All were good for using in another PC, just move to new PC and can NOT use the vm’s network service.)
service network restart
Shutting down loopback insterface: [ OK ]
Bringing up loopback insterface: [ OK ]
Bringing up interface eth0: Device eth0 does not seem to be present,delaying initialization. [FAILED]
Oracle Datapump lob table Tips