Day: July 13, 2009

Setting up Oracle Statistics Package (STATSPACK)

Leave a Comment / Oracle / By / July 13, 2009 / , , , , ,

To install statspack – you must be connected to database as SYSDBA and execute the script spcreate.sql located under $ORACLE_HOME/rdbms/admin. Additionally, you need have: the password you would like to set for PERFSTATS schema the default tablespace for PERFSTAT schema the temporary tablespace for PERFSTAT schema If you run it through SQL*Plus the output will …

Setting up Oracle Statistics Package (STATSPACK) Read More »

How to create an Oracle User to use both OS Authentication and Password Authentication

2 Comments / Oracle / By / July 13, 2009 / , , , , ,

The initialization parameter REMOTE_OS_AUTHENT offers a trusted authentication model to the network, users can have OS accounts on machines other than the database server and gain access to database, convenience of single sign-on through remote OS authentication REMOTE_OS_AUTHENT accepts BOOLEAN value, FALSE is a default value, which can be altered via ALTER SYSTEM command. This …

How to create an Oracle User to use both OS Authentication and Password Authentication Read More »