Skip to main content

Posts

Showing posts from February, 2018

Issue running adcfgclone.pl on Database Oracle home.

   While running adcfgclone.pl as oracle user, the session just hangs without giving any error in the log file. The issue was that it wasn’t able to connect to the database as : sqlplus "/as sysdbaa This can be  occur due to improper shutdown of the database. While in the course of a database shutdown, if any of the oracle process is not completed killed and it holds a large shared memory segment, such issues can occur which would prevent from normal database operation. So next time when an instance tries to start it is not able to grab a large chunk of memory to get started. This can be checked as follows: After the database has been shut down , there shouldn’t be any processes running as oracle on the server level: ipcs -m | grep <oracle user> eg: ipcs -m | grep oracle key              shmid          owner   perms ...

Audit An Oracle Applications'

How To Audit An Oracle Applications' User? in R12 How To Audit An Oracle Applications' User?   Note: The concurrent program " Purge Signon Audit Data " should be used regularly to purge old sign on data. Sign-On:Audit Level allows you to select a level at which to audit users who sign on to Oracle Applications.  Four audit levels increase in functionality: None, User, Responsibility, and Form.  None is the default value, and means do not audit any users who sign on to Oracle Applications. Auditing at the User level tracks: Who signs on to the system The times users log on and off Auditing at the Responsibility level performs the User level audit functions and tracks: - The responsibilities users choose - How much time users spend using each responsibility Auditing at the Form level performs the Responsibility level audit functions and tracks: The forms users choose How long users spend using each form System Administrator visible, r...

EBS R12 “Unable to Authenticate Session”

Oracle E-Business Suite environment with IE8 and higher, When  cloning the EBS envitorment or you are logging out from your DEV Instance and want to login to  PROD-Instance it happens “Unable to authenticate session” Go to all programs, Right click on your IE icon and add -noframemerging to the end of the link in the Target field e.g.”C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging (shown below) 1)  Start -> Program Files 2)  Right click on the Internet Explorer icon and select Properties 3)  Add -nomerge to the end of the link in the Target field i.e. “C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging 4)  Click the OK button to close the window 5) Stop all Browser sessions. 6) Start a new Browser session and logon to the Instance

EBS Analyzers R12.2

  Doc ID …   Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1) Welcome to the world of EBS Analyzers. The scripts are meant to be part of your Production maintenance program by your Sysadmin, or are to be used by designated end users. The result set is an easy to read html output that provides recommendations, solutions and early warnings about items that should be reviewed and corrected. Each analyzer can be run on demand or scheduled for repeatability and emailed to critical reviewers. Check out the EBS Analyzer Bundle Menu Tool (Note 1939637.1) to manage your Analyzers. The Analyzer Bundle Menu Tool is a perl menu system to easily run analyzers, install as concurrent programs, assign to request groups, and check for new and updated analyzers. Take advantage of these tools from Oracle Premium Support. E-Business Suite Core Analyzers Applications Login Analyzer — Take Action The E...

Database name change using NID (rename DB after cloning)

Database changed name using nid option. 1- Database should be in mount mode 2- issue nid command 3- change db name in init.ora file before starting db in mount stage 3- open with open resetlog option SQL> startup mount pfile=/u01//11.2.0/dbhome_1//dbs/initTESTR121.ora.tmp ORACLE instance started. Total System Global Area 2137886720 bytes Fixed Size                  2230072 bytes Variable Size            1375733960 bytes Database Buffers          754974720 bytes Redo Buffers                4947968 bytes Database mounted. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mini...

ORA-00392: log 4 of thread 2 is being cleared, operation not allowed

Error ORA-00312 and ORA-00312 SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00392: log 4 of thread 2 is being cleared, operation not allowed ORA-00312: online log 4 thread 2: '+DB1_RECO/prod12/onlinelog/log04a.log' ORA-003122: '+DB1_RECO/prod12/onlinelog/log04b.log' SQL> select group#,thread#,status from v$log;     GROUP#    THREAD# STATUS ---------- ---------- ----------------          5          1 CLEARING_CURRENT          6          1 CLEARING          3          2 CLEARING          4          2 CLEARING_CURRENT SQL>  alter database clear unarchived logfile ...

Concurrent Queries

By using below Concurrent Manager and Program rules: --Gives Detail of the Concurrent_queue_name and User_concurrent_program_name SELECT b.concurrent_queue_name, c.user_concurrent_program_name FROM FND_CONCURRENT_QUEUE_CONTENT a, fnd_concurrent_queues b, fnd_concurrent_programs_vl c WHERE a.queue_application_id = 283 and a.concurrent_queue_id = b.concurrent_queue_id and a.type_id = c.concurrent_program_id order by decode(INCLUDE_FLAG, 'I', 1, 2), type_code; Cancelling Concurrent request: --By request id update fnd_concurrent_requests set status_code='D', phase_code='C' where request_id=&req_id; --By program_id update fnd_concurrent_requests set status_code='D', phase_code='C' where CONCURRENT_PROGRAM_ID=&prg_id; Checking last run of a Concurrent Program along with Processed time: -- Useful to find the Details of Concurrent programs which run daily and comparison purpose SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,   ...