SSH to your DBaaS in Oracle’s cloud

I first followed the getting started video that is provided once you have an Oracle Cloud account, that showed how to create the SSH keys, the instance, and open network ports to get at it. Here are a couple of links to directions on the 3 steps above: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/videos.html http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_QS/oracle_database_cloud_service_dbaas_quick_start.html   Then: C:\Cloud>c:\putty\putty.exe -i myOracleKey.ppk…

Starting 12c OBIEE from the command line on RHEL 6

I’ll do another post on the entire install later – but for now – java was installed by root as an RPM – and OBIEE was installed as the Linux user oracle.oinstall. I did a default installation of 12c 12.2.0.2 OBIEE with java, weblogic and OBIEE deployed as follows (note: the environment variables are in…

A most excellent document on restoring a controlfile and your options – from Oracle

https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/osrecov005.htm Yes, it’s an oldie but a goodie… Here are quotes directly from Oracle online documentation: Restoring Control Files This section contains the following topics: Restore Lost Copy of a Multiplexed Control File Restore Control File from Backup After Loss of All Current Control Files Create New Control File After Losing All Current and Backup…

12c sqlplus / as sysdba ORA-01017: invalid username/password; logon denied

You are trying to connect / as sysdba and get an error like this: [oracle@vbgeneric dbs]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 3 10:06:58 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied The issue is likely it’s a pluggable database you are trying to…