Skip to content
Advertisements

Archive for

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 {} \;

 

 

Advertisements

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

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\’\)\”

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.

http://localhost:631

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