Preview a little ’bout sql*loader
SQL*Loader loads data from external files into tables of an Oracle database,
SQL*Loader Can manipulate the data before loading it, using SQL functions,
SQL*Loader Can load data into multiple tables during the same load session, and many more..
SQL*Loader takes as input a control file (*.ctl), which controls the behavior of SQL*Loader, and one […]

Popularity: 18% [?]

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% [?]

Sudo (su “do”) allows a system administrator to give certain users (or groups of users) the ability to run some (or all) commands as root while logging all commands and arguments
Sudo is supplied in source form and you need to compile it.
This isn’t difficult! Before doing so, you need to have installed the g(un)zip program […]

Popularity: 14% [?]

Don’t Panic if you get this error when you start, restart or stop your mysql engine.
I get error like this “/etc/init.d/mysql: /usr/local/bin/hostname: not found
/etc/init.d/mysql: /usr/local/bin/hostname: not found
ERROR! MySQL manager or server PID file could not be found!”
when i restart the mysql, yes..dont panic,

addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F09%2F18%2Ferror-mysql-manager-or-server-pid-file-could-not-be-found%2F’;
addthis_title = ‘ERROR%21+MySQL+manager+or+server+PID+file+could+not+be+found%21′;
[…]

Popularity: 45% [?]

When I was to changed “root” password then come up message like this
“passwd (SYSTEM): Unexpected failure. Password database unchanged”, try adduser, then his come up again this message “UX: useradd: ERROR: Cannot update system files - login cannot be created.”
check your / space, house keeping if its full, then change your root password with
# passwd […]

Popularity: 22% [?]

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% [?]

On Solaris 10 Fibre Channel Management was so easy, cos the storage foundation kit is now integrated into the base OS, name was ” fcinfo “.
” fcinfo ” utility were added to view fibre channel connectivity information.
” fcinfo ” is especially useful, since it provides a tool with the base Operating System to view HBA […]

Popularity: 42% [?]