As addition to the OpenWorks: OS Authentication in R5000. You can create default wallet without having to login into OpenWorks by running the script below. Before you run the script, you have to make sure that the following environment variable is populated correctly: OWHOME OWSYSSID ORACLE_HOME OW_HOME_DIR From your linux shell, please run the following: [...]
Posts Tagged ‘Oracle’
382 153Oracle: Default Temporary Tablespace in 9i/10g
May 4th, 2009
No Comments
In Oracle 9i or above, we can create default temporary tablespace. By default, if user doesn’t have any temporary tablespace set, it will automatically use this default temporary tablespace. Before setting up the default temporary tablespace, you have to create the temporary tablespace: SQL> CREATE TEMPORARY TABLESPACE temp TEMPFILE ‘/oradata/tempfile_01.dbf’ SIZE 10M EXTENT MANAGEMENT LOCAL [...]
OpenWorks: OS Authentication in R5000
April 25th, 2009
1 Comment
OpenWorks R2003 use traditional external user as the authentication. By simply, creating user via sqlplus: create user osuser identified externally And you can connect to OpenWorks Oracle database by: sqlplus /@openworksdb In R5000, end user is still able to logon without password but the method is slightly different. R5000 uses Oracle Secure External Password Store. [...]
