How to switch from one user to another in sqlplus

Posted on May 29, 2013 by Ahmed Tawfik

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 , , , | 2 Comments

How to get current logged-in user in sqlplus

Posted on May 29, 2013 by Ahmed Tawfik

select user from dual;

Posted in Uncategorized | Tagged , , | 2 Comments

How to create missing table S_ETL_PRD_REL from ddlimp utility

Posted on May 28, 2013 by Ahmed Tawfik

– 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 /F D:\instance_name\mwh\Oracle_BI1\biapps\dwrep\DDL_OLTP.CTL /L D:\instance_name\mwh\Oracle_BI1\biapps\dwrep\DDL_OLTP_instance_name.log

where /C is the ODBC data source name, so take care that you have to create an ODBC system data source first and of course to create it you must have the tnsnames entry first.

Sources:

https://forums.oracle.com/forums/thread.jspa?threadID=2249621

Click to access AnyAppUpgr.pdf

https://cn.forums.oracle.com/forums/thread.jspa?threadID=2257034

Felice Fusada from Oracle

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

Increasing size of ASM-based bigfile tablespace

Posted on May 27, 2013 by Ahmed Tawfik

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 case it was a big file tablespace, which only option is to resize, not to add more data files, so I did the following:

ALTER TABLESPACE tablespace_name RESIZE 40G;

To check for the size, run the following query:

SELECT tablespace_name,file_name, bytes/1024/1024 SIZE_MBYTES
FROM dba_data_files
WHERE tablespace_name IN (‘SIEBELDATA’, ‘SIEBELINDEX’)
ORDER BY tablespace_name

Posted in Uncategorized | Tagged , , | Leave a comment

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

Posted on May 26, 2013 by Ahmed Tawfik

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
———–  ——–  ———–  ———  —————-  ———–  ——————-  —————-  —————-  —————–  —————-  ———————
SecAdptMode  LDAP      String       Subsystem  Security Manager  Comp level   Component level set  N                 Y                 N                  Y                 Security Adapter Mode

Sample output for DB 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
———–  ——–  ———–  ———  —————-  ———–  ——————-  —————-  —————-  —————–  —————-  ———————
SecAdptMode  DB        String       Subsystem  Security Manager  Comp level   Component level set  N                 Y                 N                  Y                 Security Adapter Mode

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