Oracle

Oracle November 18, 2009 0

How to increase SGA_MAX_SIZE

CASE: Cannot change sga_max_size ORA–02095: specified initialization parameter cannot be modified (Cause: The specified initialization parameter is not modifiable) Simulation: SQL>…

Oracle March 19, 2009 0

Data Files: moving renaming deleting

Let’s have a look at what do we have after default database installation: SQL> SELECT name FROM v$datafile; NAME ——————————————————— /u01/app/oracle/product/10.2.0/oradata/DBSID/SYSTEM01.DBF…

Oracle March 18, 2009 0

Redo Online Logs: add clear move delete

After default database 10g installation usually we’ve got 2-3 redo log files in 2-3 groups: SQL>select GROUP#, member from v$logfile; GROUP#…

Oracle, Oracle SOA Suite June 6, 2008 5

Session timeout Oracle Application Server Control

Using the Application Server Control to change the session timeout. To change the session timeout for an Application Server users perform…

Oracle, Oracle SOA Suite June 6, 2008 0

How to change password for Application Server users

To change the oc4jadmin password for a remote account without using Application Server Control: 1. Log in to the operating system…

Oracle, Oracle Database April 4, 2008 0

Passwords in Oracle Database

Fact sheet about Oracle database passwords Oracle Password Algorithm (7-10g Rel.2) (Designed by Bob Baldwin) Up to 30 characters long. All…