Ok, this is the long winded version of stopping and starting EBS application tier and database tier with some explanation of how to figure out an appl and database tier environments – that you just walked into and don’t necessarily have paths, sids, listener names etc. memorized yet. Start and Stop The Application Tier Here’s …
R12 EBS basics start and stop EBS applmgr and oracle Read More »
Oracle Rest Data Services – used to be called APEX Listener until Oracle realized it isn’t just for APEX. What does it do? Allows Oracle DML (insert, update, delete, select), PL/SQL invocations and other stuff via http get, put and post.
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 …
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 …
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 »
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 …
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 »
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 »
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 »