APPS DBA
ERROR
APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your system administrator.
Real Application Cluster Acronyms
GCS |
Global Cache Services | in memory database containing current locks and awaiting locks, also known as PCM |
GES |
Global Enqueue Services | coordinates the requests of all global enqueues uses the GCS, also known as non-PCM |
GRD |
Global Resource Directory | all resources available to the cluster (formed and managed by GCS and GES), see GRDfor more details |
GRM |
Global Resource Manager | helps to coordinate and communicate the locks requests between Oracle processes |
GSD |
Global Services Daemon | runs on each node with one GSD process per node. The GSD coordinates with the cluster manager to receive requests from clients such as the DBCA, EM, and the SRVCTL utility to execute administrative job tasks such as instance startup or shutdown. The GSD is not an Oracle instance background process and is therefore not started with the Oracle instance |
PCM (IDLM) |
Parallel Cache Management | formly know as (integrated) Distributed Lock Manager, its another name for GCS |
Resource |
n/a | it is a identifiable entity it basically has a name or a reference, it can be a area in memory, a disk file or an abstract entity |
Resource (Global) |
n/a | a resource that can be accessed by all the nodes within the cluster examples would be the following
Data Buffer Cache Block Transaction Enqueue Database Data Structures |
LVB |
Lock Value Block | contains a small amount of data regarding the lock |
TRFC |
Traffic Controller | controls the DLM traffic between instances (messaging tickets) |
Compiling Objects Manually Through SQL Commands
First find the Invalid Objects in the Database by below given query.
SELECT COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = ‘INVALID’;
For a more detailed query, use the following script :
SELECT OWNER, OBJECT_TYPE, COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = ‘INVALID’
GROUP BY OWNER, OBJECT_TYPE;
To recompile an individual object, connect to SQL*PLUS as the owner of the object (generally apps) and use one of the following depending on the object type :
alter package <package_name> compile; (package specification)
alter package <package_name> compile body; (package body)
alter view <view_name> compile; (view)
If the object compiles with warnings, use either of the following to see the errors that caused the warnings :
show errors
OR
select * from user_errors where name = ‘<OBJECT_NAME>’;
Compiling Objects Through ADADMIN Utility
1. Login OS with APPS owner.
2. Start the ADADMIN Utility from the Unix prompt with this command :
$adadmin
3. Under the Maintain Applications Database Objects Menu, select Compile APPS schema(s)
Syntax:
fnd_user_pkg.addresp(username => v_user_name
,resp_app => ‘SYSADMIN’
,resp_key => ‘SYSTEM_ADMINISTRATOR’
,security_group => ‘STANDARD’
,description => ‘Auto Assignment’
,start_date => SYSDATE – 10
,end_date => SYSDATE + 1000);
Usage:
BEGIN
fnd_user_pkg.addresp (‘OPERATIONS’,’SYSADMIN’,’SYSTEM_ADMINISTRATOR’,’STANDARD’,
‘Add Sysadmin Responsibility to OPERATIONS user using pl/sql’, SYSDATE, SYSDATE + 100);
COMMIT;
DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( ‘ Responsibility is not added due to ‘ || SQLCODE || SUBSTR (SQLERRM, 1, 100));
ROLLBACK;
END;