After Windows server 2019 Oracle VirtualBox VM has been created as per How to Install Windows Server 2019 on Oracle VirtualBox, now it is time to install SQL server 2019.
Subscribe to get access
Read more of this content when you subscribe today.
Month: June 2020
How to Install Windows Server 2019 on Oracle VirtualBox
This post illustrates step by step on how to build a Windows Server 2019 evaluation VM server on Oracle VirtualBox, also screenshots are provided for every step in details.
Subscribe to get access
Read more of this content when you subscribe today.
To log in, press the host key plus the Delete key to simulate the CTRL + ALT + DELETE key combination. The host key is the right-CTRL key by default.
How to Clone 19c Oracle RAC Home using Gold-Image
As we know “clone.pl ” script has been widely used for cloning Oracle binaries before 19c. But it is now deprecated since 19c.
This post demonstrates how to clone 19c Oracle Database RAC Home from one database server to another.
Subscribe to get access
Read more of this content when you subscribe today.
ORA-20411: Monitoring credentials not set for target
While promoting auto-discovered targets in OEM 13.4, the following errors occur:
“ORA-20411: Monitoring credentials not set for target name RACTESTDB target type rac_database set nameDBCredsMonitoring”
After testing monitoring user DBSNMP credentials , all works fine.
WORKAROUND
Remove the auto discovered targets, and manually add them into OEM again by :
Setup -> Add Target -> Add Targets Manually -> Add Using Guided Process
Install Oracle 19c RAC Software and Create CDB Database
Define ORACLE_HOME and create ORACLE_HOME directory
[oracle@racnode1 ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 [oracle@racnode1 ~]$ mkdir -p $ORACLE_HOME
Unzip oracle database binary into ORACLE_HOME
[oracle@racnode1 19c]$ unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
Run runInstaller as oracle owner
Please note the “runInstaller” script is under $ORACLE_HOME, not the one under $ORACLE_HOME/oui/bin.
[oracle@racnode1 ~]$ cd $ORACLE_HOME [oracle@racnode1 dbhome_1]$ ./runInstaller
Oracle 19c RAC software Installation Steps
Select Configuration Option -> Set Up Software Only
Select Database Installation Option -> Oracle Real Application Clusters database installation
Select List of Nodes
SSH connectivity..
OS Username: oracle
OS Password:
Reuse Private and Public Keys existing in the user home
Select Database Edition -> Enterprise Edition
Specify Installation Location
Oracle base: /u01/app/oracle
Software location:/u01/app/oracle/product/19.0.0/dbhome_1
Privilleged Operating System groups
Database Administator (OSDBA) group: dba
Database Operator (OSOPER) group (Optional): oper
Database Backup and Recovery (OSBACKUPDBA) group: backupdba
Data Guard administrative (OSDGDBA) group: dgdba
Encryption Key Management administrative (OSKMDBA) group: kmdba
Real Application Cluster administrative (OSRACDBA) group: racdba
Root script execution configuration -> No ticking Automatically run configuration scripts
Perform Prerequisite Checks
wait a few minute -> Ignore All -> Next
Summary
Install
Install Product -> Details
wait a fewer minutes -> use root account run shell script on every node
Finish Install database software
Run DBCA to create CDB database
[oracle@racnode1 ~]$ cd $ORACLE_HOME/bin
[oracle@racnode1 bin]$ ./dbca
Database Configuration Assistant Step by Step
Select Database Operation
Create a database
Select Database Creation Mode
Advanced configuration
Select Database Deployment Type
Database type: Oracle Real Application Cluster (RAC) database
Configuration type: Admin Managed
Select a template for your database: General Purpose or Transaction Processing
Select List of Nodes
Select all
Specify Database Identification Details
Global database name: RACDBD
SID Prefix: RACDB
ticking Create as Container database
ticking Use Local Undo tablespace for PDBs
choose Create a Container database with one or more PDBs
Number of PDBs: 1
PDB name:racdbpdb1
Select Database Storage Option
choose Use following for the database storage attributes
Database file storage type: Automatic Storage Mangement(ASM)
Database file location: +DATA/{DB_UNIQUE_NAME}
ticking Use Oracle-Managed Files(OMF)
Select Fast Recovery Option
ticking specify Fast Recovery Area
Recovery file storage type: Automatic Storage Management(ASM)
Fast Recovery Area: +FRA
Fast Recovery Area size: 13332 MB
ticking Enable archiving
Select Oracle Data Vault Config Option
NO ticking “Configure Oracle Database Vault”
NO ticking “Configure Oracle Label Security”
Next>
Specity Configuration Options
Memory: choose Use Automatic Shared Memory Management
SGA size: 3072 MB
PGA size: 512 MB
Sizing
Processes:300
Character set
Choose Use Unicode( AL32UTF8 )
National character set: AL16UTF16 – Unicode UTF-16 Universal character set
Default language: American
Default territory: United States
Connection mode
Choose Dedicated Server mode
Sample schemas
No ticking schema to the database
Next>
Specify Management Options
Tick Run Cluster Verfication Utility(CVU check periodically
Specify Database User Credentials
Choose Use the same administrative password for all accounts
Select Database Creation Option
Tick Create database
Tick Generate database creation scripts
Perform Prerequisite Check
Summary
Finish
Close
Verify CDB and PDB
[oracle@racnode1 ~]$ srvctl status database -d RACDBD Instance RACDBD1 is running on node racnode1 Instance RACDBD2 is running on node racnode2
SQL>select CON_ID, NAME, OPEN_MODE, RESTRICTED, PDB_COUNT
from v$containers;
CON_ID NAME OPEN_MODE RES PDB_COUNT
----- -------- --------- --- -------
1 CDB$ROOT READ WRITE NO 1
2 PDB$SEED READ ONLY NO 0
3 RACDBDPDB1 READ WRITE NO 0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
----- ------- -------- --------
2 PDB$SEED READ ONLY NO
3 RACDBDPDB1 READ WRITE NO
Make DBA Life Easy 