Creating Oracle Database 11g on Amazon RDS (video)
In my last post I’ve wrote about the new Oracle Database service provided by Amazon Relational Database Services. Today I’ll demonstrate, with a video, how to create an connect to the Oracle Database service provided by Amazon RDS.
First, you should know that this is “only” a database cloud service, so you won’t have the possibility or the need to managed the Operating System. For instance, the Oracle RDS does not include Oracle Enterprise Manager or Oracle APEX. The only way to access the database is by connecting a compliant oracle client to the listener, running at the port you specified at create time, such as SqlDeveloper, SqlNavigator… or if you prefer, a low level interface like cx_oracle for python.
When you’re specify the username to administer this database be sure to not use any Oracle username here. Avoid using SYS, SYSTEM, OUTLN, CTXSYS, etc. The database creation will take between 5 to 10 minutes to finish.
Obviously, connections to the database are secured by AWS security groups (firewall services), so I’ll need to allow my host to connect to the database. To do that I’ll edit the security group to add my IP address to the allow list.
Last, but not least, I’ll show how to connect to the database with SQLDEVELOPER.
The following video is available on HD… so set it to 720p and go full screen 🙂
Have a nice day… or night!!!