I Recreate the temp tablespace coz my temp tablespace was corrupt,
you can do to the following bellow

1. c r e a t e temporary tablespace temp2 tempfile ‘/rdbms/temp01/temp2.dbf’ size 10M extent mangement local uniform size 1M;
2. alter d a t a b a s e default temporary tablespace temp2;
3. d r o p tablespace temp including contents and datafiles;

now change back to temp again with following step bellow:

1. c r e a t e temporary tablespace temp tempfile ‘/rdbms/temp01/temp2_01.dbd’ size 1000M extent management local uniform size 1M;
2. a l t e r database default temporary tablespace temp;
3. d r o p tablespace temp2 including contens and datafiles;
4. a l t e r tablespace temp add tempfile ‘/rdbms/temp01/temp2_02.dbf’ size 1000M;

Popularity: 26% [?]

Yesterday,
During Installation of Oracle database 9i base on RHEL 4 ES,
I got Found error occurred when create the database using dbca,
and it keeps failing at the same point (Creating data dictionary Views)
This the error number Detail “ORA 29807 - specified operator does not exist”

Workaround;
just ignore the error and DBCA proceeds normally. Once the database is ready,
login as SYS and run this script manually:

$ORACLE_HOME/rdbms/admin/prvtxml.plb
SQL> @?/rdbms/admin/prvtxml.plb

Popularity: 22% [?]

Q. How do I mount ISO FILE, And Read under it?
A. You can Use lofi(7D)/lofiadm the loopback file driver

Mounting an Existing CD-ROM Image Or File image
Use lofiadm to attach a block device to it:
# lofiadm -a /path/to/file.iso

/dev/lofi/1

And Then Use the mount command to mount the image:
# mount -F hsfs -o ro /dev/lofi/1 /path/output

lofiadm picks the device and prints the device name to the standard output.
# lofiadm

Block Device File
/dev/lofi/1 /path/to/file.iso

Check to ensure that Solaris understands the image:
# df -h

Filesystem size used avail capacity Mounted on
/dev/lofi/1 0K 0K 0K 0% /path/output

As a final step, unmount and detach the images:
# umount /path/output
# lofiadm -d /dev/lofi/1
lofiadm

Block Device File

Popularity: 15% [?]

path: …/Oracle Home/bin/orakill.exe or find manually
command: orakill <sid> <spid>
example: C:\Oracle9\bin\orakill ORCL 2760

Popularity: 13% [?]

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 or more datafiles. Output of the SQL*Loader is an Oracle database (where the data is loaded), a log file, a bad file, and potentially a discard file.

Requirement..
1. Table
2. Control File
3. Flat File / Data File (optional)

…click here to read more →

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 db rename file ‘/$ora_home/$SID/undo/undo02.dbf’ to ‘/$ora_home/$SID/undo2/undo2.dbf’;
alter db rename file ‘/$ora_home/$SID/index1/idx01.dbf’ to ‘/oradata/$SID/index2/idx01.dbf’;
alter db rename file ‘/$ora_home/$SID/index1/idx02.dbf’ to ‘/oradata/$SID/index3/idx02.dbf’;

6. shutdown immediate
7. startup
8. lsnrctl start

Note:
DB=database

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 and a C compiler.

Installing sudo.

Prefare the source download it from http://www.courtesan.com/sudo/download.html,
# uname -a
SunOS 5.9

# wget ftp://ftp.sudo.ws/pub/sudo/sudo-1.6.9p5.tar.gz
# gunzip -dc sudo-1.6.9p56.tar.gz |tar xvf -
# cd sudo-1.6.9p5
# ./configure
# ./make
# ./make install

Environment Parameter ( .added in .profile User$)
# export PATH=$PATH:/usr/local/bin:/usr/local/sbin:/usr/ccs/bin
# export MANPATH=$MANPATH:/usr/man/:/usr/local/man

Added Sudoers
# visudo

find
# User privilege specification
root ALL=(ALL) ALL

Added
users ALL=(ALL) NOPASSWD:ALL

$ sudo vi /etc/passwd

Done..

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,
…click here to read more →

Popularity: 45% [?]