| | How to create users using command line utility jazn.jar
If you don't bother with LDAP (i.e. Active Directory) and use file based security for your Oracle Application Server / SOA environment you can use jazn.jar to manage users and roles, which makes it a little easier as opposed to using enterprise manager console.
Below are some examples of using jazn ... | | More...
08/07/08 | | | | | | | | |
|
|
| | How to installl Standalone Resource Adapters in a new OC4J container
This procedure describes how to install AQ and JMS adapters in a new OC4J container - the one you've created for a custom application perhaps. Note: this is applicable to OAS / SOA 10.1.3.x.
cd $ORACLE_HOME/j2ee/[container name]/config
Edit server.xml and add the following lines (replace ORACLE_HOME with the actual directory):
... | | 
More...
07/17/08 | | | | | | | | |
|
| | How to upgrade Oracle 10.2.0.3 to 10.2.0.4
1. Shutdown database running on older version
2. Edit oratab and change ORACLE_HOME to 10.2.0.4 for the database being upgraded
3. Start the database
4. Run the upgrade assistant
$ORACLE_HOME/bin/dbua
... that's it
| |  
More...
07/14/08 | | | | | | | | |
|
|
|
|
| | Get buffer cache hit ratio / miss ratio
SQL> SELECT name, 1-(physical_reads / (consistent_gets + db_block_gets )) "HIT_RATIO"
FROM V$BUFFER_POOL_STATISTICS
WHERE ( consistent_gets + db_block_gets ) !=0
/
NAME HIT_RATIO
-------------------- ----------
DEFAULT .817011081
-- ... | | More...
06/24/08 | | | | | | | | |
|
| | Dropping online redo logs
If you want to move redo logs to another filesystem without shutting down the database you can create new groups on the new filesystem and drop the old groups.
1. Create new online redo log groups
SQL> ALTER DATABASE ADD LOGFILE ('/path2redo/redo4a.log') SIZE 100M;
SQL> ALTER DATABASE ADD LOGFILE ('/path2redo/redo5a.log') SIZE 100M;
SQL> ALTER ... | | More...
06/13/08 | | | | | | | | |
|
| | How to enable autoextend on tablespaces and datafiles
-- Create tablespace with a datafile that will be auto extended to 10Gb
create tablespace TABLESPACE_NAME datafile '/path/to/datafile.dbf' size 2000M AUTOEXTEND ON MAXSIZE 10000M extent management local uniform size 5M segment space management auto;
If you want to enable autoextend on a smallfile tablespace (if you are trying to alter tablespace to ... | |
More...
06/04/08 | | | | | | | | |
|
<< 1 | 2 | 3 | 4 | Page 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 >>
|
