Month: March 2017

Cloning Oracle EBS 12.2 VIS on Linux RHEL 6

Cloning R12.2 environment See Oracle Support Doc: Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1) Additionally patching to R12.AD.C.Delta.7 and TXK provides some new functionality that eases the clone process – see dualfs at the end of this post. Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.7 and …

Cloning Oracle EBS 12.2 VIS on Linux RHEL 6 Read More »

Stop / shutdown and start Oracle EBS r12 VIS

After logging in as applmgr to linux, I run an environment setup script before the start or shutdown… that looks like this: Start / Stop of Everything on the Appl Tier [applmgr@oel66-79 ~]$ cat setApplEnv.sh . /d01/oracle/VIS/fs1/EBSapps/appl/VIS_oel66-79.env cd /d01/oracle/VIS/fs1/inst/apps/VIS_oel66-79/admin/scripts adstrtal.sh adstpall.sh [applmgr@oel66-79 scripts]$ . ./adstpall.sh This stop script will prompt you for the apps/apps, and …

Stop / shutdown and start Oracle EBS r12 VIS Read More »

Encrypting passwords in GoldenGate parameter files Linux

Encrypting passwords in GoldenGate parameter files on Linux generate keys, run the keygen command from the GoldenGate software installation home KEYGEN key length n Where: (key length) is the encryption key length (n) represents the number of keys to generate. # cd into your goldengate home – oraInventory knows where that is if you don’t …

Encrypting passwords in GoldenGate parameter files Linux Read More »

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 …

SSH to your DBaaS in Oracle's cloud Read More »

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 …

Starting 12c OBIEE from the command line on RHEL 6 Read More »

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 …

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

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 …

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