• August 11, 2019

VIDEO – Create and connect to Oracle in Azure

Wanted to record a demo of how to create Oracle 12 instance in Azure and connect with GUI tools from Windows client.   Video shows full processing (including troubleshooting) with TCP firewall, DBCA create command, system password, and all.    Great way to build personal dev environment to learn Oracle connection strings and syntax, while staying out of live production corporate Oracle system.

Cheers. 

Video

Code

ssh adminUser@publicipaddress
sudo su - oracle
lsnrctl start
# Find file
find / -name sqlplus -print
# Environment variables
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=cdb1; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin
# Connect Oracle SQL Developer GUI
system
OraPasswd1
# Display Version
SELECT * FROM v$version

Screenshots

References

• https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/oracle/oracle-database-quick-create
• https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-configuring-an-oracle-database.html#GUID-2B89CEDB-DD37-4FB2-BF8E-EA063F5E64C2
• https://martincarstenbach.wordpress.com/tag/dbca/
• ORA-01017: invalid username/password; logon denied
• SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

• August 11, 2019
• No Comments
• Uncategorized