Monthly Archives: May 2013

How to switch from one user to another in sqlplus

for example, you’re connected as sysdba using “sqlplus / as sysdba”, all you have to do is type “connect”, then enter the desired username and password, and there you go! Advertisements

Posted in Uncategorized | Tagged , , , | 1 Comment

How to get current logged-in user in sqlplus

select user from dual;

Posted in Uncategorized | Tagged , , | 1 Comment

How to create missing table S_ETL_PRD_REL from ddlimp utility

– Login to the server with the Oracle BI Applications installed – Run the following command (in this case it’s a windows server): D:\instance_name\mwh\Oracle_BI1\biapps\dwrep\Bin\DDLIMP /U siebel /P ***** /a SIEBEL /C tp4u12 /G SSE_ROLE /W Y /B SIEBELDATA /X SIEBELINDEX … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 1 Comment

Increasing size of ASM-based bigfile tablespace

Firstly few commands to get you up & running: – Get names of tablespaces: “select name from v$tablespace;” – Get names of disk groups: “select name from v$asm_diskgroup;” – Get names of data files: “select name from v$datafile;” In my … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

How to list the security adapter for an Object Manager in Siebel

list parameter SecAdptMode for comp comp_name e.g. list parameter SecAdptMode for comp eCommunicationsObjMgr_enu sample output for LDAP authentication: PA_ALIAS     PA_VALUE  PA_DATATYPE  PA_SCOPE   PA_SUBSYSTEM      PA_SETLEVEL  PA_DISP_SETLEVEL     PA_EFF_NEXT_TASK  PA_EFF_CMP_RSTRT  PA_EFF_SRVR_RSTRT  PA_REQ_COMP_RCFG  PA_NAME ———–  ——–  ———–  ———  —————-  ———–  ——————-  —————-  —————-  —————–  … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | 1 Comment

How to cut videos from the command line in Ubuntu 12.10 and later (Mint 14 and later)

avconv -i DP4U12.ogv -vcodec copy -acodec copy -ss 00:00:00 -t 00:04:20 DP4U12_complete.ogv The above command preserves the same format of the input file, where: DP4U12.ogv is the input file DP4U12_complete.ogv is the output file The command cuts the video from … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

How to extract multi-part, e.g. .z01, .z02 type of zip files on Ubuntu

I couldn’t extract an archive that I downloaded from edelivery which was in 3 files, 1.zip, 1.z01 and 1.z02: In order to extract on Ubuntu, do the following: zip -s- Input.zip -O output.zip This will gather the Input.zip file and … Continue reading

Posted in Uncategorized | Tagged , , , | 7 Comments