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!

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