Posts Tagged ‘Oracle’

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

FRM-92102 : A Network Error Has Occured

September 19th, 2017, posted in Oracle, Solaris
Share

FRM-92102 is Gerneric Error maybe occur for more than one reasons :

1-Network 
2-Proxy
3-http
4-Session Time 


But today i will discuss the problem On oracle Application server 10g .
Description for the problem like the following when you try to connect on your deploy application On OAS 10g it’s gives the above error from 1-5 minutes.

I will give you more than one solution maybe it will be related to the above problem and you try them separately to see which one will be valid for you : 

1-Netowrk Parameters :

You will find it $ORACLE_HOME/forms/server/default.env
Just increase the value .

2-do the following change in opmn.xml (under $ORACLE_HOME/opmn/conf/):

 

 

3-SET Inbound_connection_timeout In sqlnet.ora to ZERO .

Sqlnet.Inbound_connection_timeout = 0

Note : if your can’t find this parameter in the SQLNET.ORA you cant add it .

5- Change the following $ORACLE_HOME/opmn/conf/opmn.xml

 


Hope this will work 

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

To find the ROW Counts of tables that belongs to a Particular Schema

September 12th, 2017, posted in Oracle Queries
Share
select table_name,num_rows counter from dba_tables where owner=’Schema_name’ order by table_name;
Share