In database production, the log of listener was grow rapidly, some times if you move the “listener.log” while the listener is up and running, listener will stop writing to log file after you move/delete the “listener.log”, it won’t create new log file.
The listener log status will be ‘off’, You need to start the “listener log” […]

Popularity: 55% [?]

PART I : Setting up ODBC driver
1. Install mysql-connector-odbc-3.51.12-linux-i686.rpm
# rpm –ivh mysql-connector-odbc-3.51.12-linux-i686.rpm
2. Start Mysql Daemon
# /etc/init.d/mysqld start
Initializing MySQL database: [ OK ]
3. Configure […]

Popularity: 68% [?]

select s1.username || ‘@’ || s1.machine
|| ‘ ( SID=’ || s1.sid || ‘ ) is blocking ‘
|| s2.username || ‘@’ || s2.machine || ‘ ( SID=’ || s2.sid || ‘ ) ‘ AS blocking_status, s1.SQL_ID
from v$lock l1, v$session s1, v$lock l2, v$session s2
where s1.sid=l1.sid and s2.sid=l2.sid
and l1.BLOCK=1 and l2.request > 0
and l1.id1 = l2.id1
and […]

Popularity: 15% [?]

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

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

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 […]

Popularity: 23% [?]

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

addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F11%2F15%2Fkill-sesion-oracle-in-windows%2F’;
addthis_title = ‘kill+sesion+oracle+in+windows’;
addthis_pub = ”;

Popularity: 13% [?]

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 […]

Popularity: 20% [?]

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