find the files older than 30 days in linux
cd /u01/app/12c/oracle/trace
find *.trc -maxdepth 1 -mtime +30 -type f -exec ls -l {} \;
Archive for
Jan 3
Data pump command import exclude
impdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\”
Trigger for open all pdb
create trigger open_all_pdbs
after startup on database
begin
execute immediate ‘alter pluggable database all open’;
end open_all_pdbs;
/
Drop database link using sys
Step 1:
select * from dba_db_links
Step 2: create a procedure
Create or replace procedure Drop_DbLink(schemaName varchar2, dbLink varchar2 ) is
plsql varchar2(1000);
cur number;
uid number;
rc number;
begin
select
u.user_id into uid
from dba_users u
where u.username = schemaName;
plsql := ‘drop database link “‘||dbLink||'”‘;
cur := SYS.DBMS_SYS_SQL.open_cursor;
SYS.DBMS_SYS_SQL.parse_as_user(
c => cur,
statement => plsql,
language_flag => DBMS_SQL.native,
userID => uid
);
rc := SYS.DBMS_SYS_SQL.execute(cur);
SYS.DBMS_SYS_SQL.close_cursor(cur);
end;
/
Step 3: Drop database link using sys
exec Drop_DbLink(‘owner’,’dblinkname’);
Maintenance Mode enabled in obiee
Maintenance Mode enabled in obiee using runcat.sh
[oracle@obidev catalogmanager]$ ./runcat.sh -cmd maintenanceMode -on -online http://10.1.x.xxx:9704/analytics/saw.dll -credentials /u01/oracle/MiddlewareHome/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/login.txt
BIFNDN_LABEL =BIFNDN_11.1.1.7.0_LINUX.X64_130303.2025
Maintenance Mode is now ON
user not able to view responsibility in oracle apps
As a system administrator, you please submit the below request
Workflow Directory Services User/Role Validation
optional
yes
yes
yes
Optional run If it does not work after done above steps
Synchronize WF LOCAL tables
Jan 3
Find out completed concurrent request of SID
Script for find out completed concurrent request of particular SID
SELECT ( select USER_CONCURRENT_PROGRAM_NAME from Fnd_Concurrent_Programs_tl where LANGUAGE=’US’ and CONCURRENT_PROGRAM_ID=a.CONCURRENT_PROGRAM_ID)prog_name
,a.phase_code,a.status_code,a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b, v$process c, v$session d
WHERE a.controlling_manager = b.concurrent_process_id AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid and d.sid= 242
order by a.REQUEST_DATE
Datapump command exclude table
Datapump Command exclude table :
expdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’\)\”
For two table exclude
expdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\”
Jan 3
Printer setup for Oracle EBS r12
you need to do the below steps for printer configuration for oracle ebs r12 running on Linux environment.
Step 1.
Please check CUPS running on your application tier installed server.
[root@hrms-ruh-104-26 ~]# rpm -qa|grep cups
hal-cups-utils-0.6.2-5.2.el5
libgnomecups-0.2.2-9
libgnomecups-0.2.2-9
cups-libs-1.3.7-26.el5
cups-1.3.7-26.el5
cups-libs-1.3.7-26.el5
Its running, If it’r not running, Please install CUPS on your machine.
Step 2: please open your browser in the application tier.
Add printer :
your printer should be on your local network. give your printer IP address
select your printer Driver from the drop-down list. Or If not, choose any one of the drivers of related and test, Still not work, Please install the related driver on the application tier and then select correct ppd file from the driver installed location.
Test page.
Step 3: Configure printer on EBS Application
Responsibility = System Administrator
Navigate –> Install: Register
Query the target printer’s name (add printer name)
Update the printer “Type” field with the “–Pasta Universal Printer Type”
Step 4: Restart concurrent manager
[appluat@hrms-ruh-104-26 scripts]$ ./adcmctl.sh stop
[appluat@hrms-ruh-104-26 scripts]$ ./adcmctl.sh start
Step 5: Run any report, before submitting your request,
Here options –> Style -> “PDF Publisher” and choose your printer and then submit the request.
Your report will print now
DBA 