Posts Tagged ‘DBA’

For Multiple Server Connections – Single Putty Window – Multiple Tabs

January 28th, 2018, posted in Oracle, Solaris, Windows
Share

Is it possible to have a tabbed putty like firefox or internet explorer ?? Single Putty Window,Multiple Tabs,For Multiple Server Connections,Putty Window,Multiple Tab,Multiple Server Connections,Putty,Multiple Server,DBA,Oracle DBA,Oracle Database,Oracle,Oracle SQL,
Yes you can, check out below URL !!

http://www.thegeekstuff.com/2008/08/turbocharge-putty-with-12-powerful-add-ons-software-for-geeks-3/

Look for Putty connection Manager.

Share

Disable Auditing In A 11G Database

November 18th, 2017, posted in Oracle Queries
Share

In a RAC Database :

 

SQL> ALTER SYSTEM SET audit_trail=NONE SCOPE=spfile sid='*';
System altered.
SQL>

Note : Restart the database to have the change take affect, or do a rolling restart, one instance at a time.




In a Single Instance Database :

 

SQL> ALTER SYSTEM SET audit_trail=NONE SCOPE=spfile ;
System altered.
SQL>

Note : Restart the database to have the change take affect.

Share

Query To Find Users Who Have A Responsibility

October 22nd, 2017, posted in Oracle Queries
Share

Enabling And Checking the Status of Flashback On Database,Oracle Database,Oracle DBA,Enabling Flashback On Database,Checking the Status of Flashback On Database, Status of Flashback On Database, Enable Flashback On Database, Enabling Flashback On Database,Enable Flashback On Oracle Database, Enabling Flashback On Oracle Database,ORA-01153: an incompatible media recovery is active,ORA-01153,Oracle Error,Ora Error,Oracle DBA,Oracle Database Error,Oracle Database Solution,an incompatible media recovery is active,Ora : an incompatible media recovery is active,Oracle an incompatible media recovery is active,Oracle Error Solution,Database DBA,oracle data guard,oracle data guard issues,oracle data guard error

select usr.user_id, usr.user_name, res.RESPONSIBILITY_ID, res.RESPONSIBILITY_NAME
from apps.FND_USER usr, apps.FND_RESPONSIBILITY_TL res, apps.FND_USER_RESP_GROUPS grp
where upper(res.RESPONSIBILITY_NAME) like upper('%' || NVL('&EnterRespName', 'INV')|| '%')
and upper(res.RESPONSIBILITY_NAME) NOT like '%AX%'
and upper(res.RESPONSIBILITY_NAME) NOT like '%OPM%'
and grp.responsibility_id = res.responsibility_id
and grp.user_id = usr.user_id;
Share

Oracle EBS Upgrade 12.1.1 to 12.1.3

September 18th, 2017, posted in Oracle Queries
Share

oracle dba,oracle apps dba,apps dba,dba,oracle application,oracle database,oracle,Oracle EBS Upgrade 12.1.1 to 12.1.3,Oracle EBS Upgrade,12.1.1 to 12.1.3,Oracle EBS Upgrade DBA,DBA EBS Upgrade 12.1.1 to 12.1.3,EBS Upgrade,oracle ebs,oracle upgrade,

Some Links To Oracle EBS Upgrade 12.1.1 to 12.1.3 :

http://sankaramaddi.blogspot.com/2015/11/ebs-upgrade-1211-to-1213.html

http://ermanarslan.blogspot.com/2013/09/ebs-1211-to-1213-upgrade-steps.html

https://oracleminds.wordpress.com/2011/12/22/how-did-i-upgrade-our-oracle-ebs-from-r12-1-1-to-12-1-3/

http://otn-world.blogspot.com/2013/12/upgrade-oracle-ebs-r1211-to-1213.html

http://oracledbawings.blogspot.com/2011/07/upgrade-ebs-1211-to-1213.html

http://chandrasekarsivasamy.blogspot.com/2012/08/oracle-applications-upgrade-from-1211.html

Share

Transferring The DBC File From The Application Server

June 6th, 2017, posted in Oracle, Solaris
Share

We will now transfer the database connection file (DBC) from the application server of our EBS environment. We will transfer this to our local directory so that we can create database connections for JDeveloper so that we can run our OAF pages locally during development.


How to do it :

To transfer the .dbc file, perform the following tasks:

  1. Open WinSCP or FileZilla etc and connect to the application server.
  2. FTP the .dbc file to your local PC from the $INST_TOP/appl/fnd/12.0.0.0/secure dor you can say its path is something like this /u99/appprod52/inst32/apps/PROD_DB/appl/fnd/12.0.0/secure  directory on the application server to the jdevhome\jdev\dbc_files\secure directory as shown in the following screenshot:


    Transferring The DBC File From The Application Server,Oracle DBA,DBA,Oracle Apps,Oracle DBC
Share