If you want to load balance your datafile, you can split your datafile into another mount point,
here’s detail step.
1. lsnrctl stop
2. shutdown immediate
3. copy your datafile

cp /$ora_home/$SID/undo/undo01.dbf /$ora_home/$SID/undo1/
cp /$ora_home/$SID/undo/undo02.dbf /$ora_home/$SID/undo2/
cp /$ora_home/$SID/index1/idx01.dbf /$ora_home/$SID/index2/
cp /$ora_home/$SID/index1/idx02.dbf /$ora_home/$SID/index3/

4. startup exclusive mount
5. rename your old datafile path with alter command

alter db rename file ‘/$ora_home/$SID/undo/undo01.dbf’ to ‘/$ora_home/$SID/undo1/undo1.dbf’;
alter […]

Popularity: 15% [?]

When I want to shutdown the oracle database. I must kill many session client who connect to the database and running in background Os…
# ps -ef|grep -i local=no
oracle 19027 1 0 Sep 07 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 25918 […]

Popularity: 16% [?]

Yesterday, I was export the database for backup mode, Coz the database not in archived log mode, so export was the solved. I used this in HP-UX
Note:
1. Change ‘TABLE’ with your table and ‘SEPT’ with your partition table name.
2. Change ‘SCHEMA’ with your shema where table place.
3. Change ‘compress’ with your ‘compress’ tool, like (g)un(zip), […]

Popularity: 11% [?]

$ su - oracle
SQL> sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate
If No Response
SQL> shutdown abort
Monitoring Instance when restart database
$ tail -f $ORACLE_HOME/admin/bdump/alert_$ORACLE_SID.log

addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F07%2F18%2Fshutdown-oracle%2F’;
addthis_title = ‘Shutdown+Oracle’;
addthis_pub = ”;

Popularity: 9% [?]

Popularity: 9% [?]