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
