Tag Archives: Oracle

Getting List of Users and Roles on Oracle DB

This is a simple SQL statement to get you a list of all users and their roles in the Oracle DB: “SELECT * FROM DBA_role_privs;” And if you want to get the list of users related to a specific role, … Continue reading

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

How to determine history of DB startup in Oracle 11g

SQL> SELECT STARTUP_TIME FROM dba_hist_database_instance ORDER BY startup_time DESC; STARTUP_TIME ————————————————————————— 29-SEP-13 03.43.07.000 AM 29-SEP-13 03.42.31.000 AM 29-SEP-13 03.12.45.000 AM 29-SEP-13 03.11.28.000 AM 28-SEP-13 11.56.35.000 PM 07-SEP-13 10.04.07.000 PM 6 rows selected. Credit goes to Abdulrahman Galal from Oracle.

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

Configuration for BI Publisher Server Level Log

Here are the steps to change your BI Publisher Enterprise Server to be in a debug mode: Login to BIP as Administrator Select Admin -> System Maintenance -> Server Configuration Change Debug Level to ‘Debug’ under General Properties Click on … Continue reading

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

How to get version of Redhat & Oracle Enterprise Linux

Oracle Enterprise Linux: more /etc/enterprise-release, example output: “Enterprise Linux Server release 5.5 (Carthage)” Redhat: more /etc/redhat-release

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

How to manually modify DB initialization parameters by creating pfile from spfile

pfile is the initialization parameters of DB in plain text, while spfile is the binary one, so to be able to change it, you have to: Extract the pfile from the spfile: “create pfile=’my_path/file_name.ora‘ from spfile;” Shutdown the DB: “shutdown … Continue reading

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