Modern Oracle DBA

Basically sys and system user called database administrator users The users are created during database installation Both users are automatically granted the DBA role SYS User Sys user can perform all admin operations Owner of the database and data dictionary All base tables and views of the database and dictionary’s stores sys schema When connecting the sys user. Its should be made the sysdba or sysoper privileges Connect sqlplus / as sysdba Sysdba and sysoper users to perform high level of admin tasks Ex : Backup and recovery Startup and shutdown Alter database open/mount Alter database Archivelog/Noarchivelog   SYSTEM User Owner of the additional internal tables and views System user perform all admin tasks except DB upgrade, backup and recovery Default password is manager They contain administrative information used by the oracle tools. Connect syatem/manager Note: For security reasons the de...

Go to System Administrator à Concurrent à Program à Define Search the concurrent program name Click the Enable trace check box and save the concurrent program   Enable Debug from concurrent profile level Navigate to profile -> System Query "Concurrent: Allow Debugging" profile Set profile to "Yes" This should be set in site level. Submit the program Run the below sql query  under APPS User Select concurrent_program_name from fnd_concurrent_programs where enable_trace='N'; TKPROF Below query will provide the process id Select oracle_process_id from fnd_concurrent_requests where request_id=<Request_ID>; Below query will provide the trace file location select value from v$diag_info where name='Diag Trace'; select value from v$parameter where name='user_dump_dest'; Collect the trace file from user_dump_dest location and generate tkprof using below command tkprof <filename>.trc <filename>.txt sys=no  sort...

Step1 : source the EBSapps.env file Step2 : Go to $ADMIN_SCRIPTS_HOME Step 3 : sh admanagedsrvctl.sh stop oacore_server2              sh admanagedsrvctl.sh start oacore_server2              sh admanagedsrvctl.sh status oacore_server2 Ex : sh admanagedsrvctl.sh status oacore_server1 You are running admanagedsrvctl.sh version 120.14.12020000.8 Enter the WebLogic Admin password: oacore_server1 is running. admanagedsrvctl.sh: exiting with status 0 admanagedsrvctl.sh: check the logfile /oracle/PROD/apps/fs1/inst/apps/PROD_prod/logs/appl/admin/log/adoacorectl.txt for more information ... How to start and stop services in R12.2 Click hear