Kelvin Shen's Blog

Created on May 28, 2013

Environment:
Oracle:
Oracle 11g Release 2聽 11.2.0.3
OS:
Oracle Linux 6.3 (64bit)

When start a listener, one error shows that port 1521 has been used, but actually聽 not.

Change to another port 1525, problem again.

I remember that this server is vmware server, clone from an existed vm server, and /etc/hosts should be changed after clone.

Make sure IP is the right one.

[root@orademo01 ~]# cat /etc/hosts

127.0.0.1聽聽 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1聽聽聽聽聽聽聽聽 localhost localhost.localdomain localhost6 localhost6.localdomain6

10.172.10.205聽聽聽 orademo01聽聽聽 orademo01

After that, problem is solved.

Created on May 21, 2013

Environment:
Oracle:
Oracle 10g Release 2聽 10.2.0.1
OS:
Windows 2003

There is a job running for聽 more than 2 days, but normally only 5 minutes is needed.

SQL> SELECT * FROM USER_SCHEDULER_RUNNING_JOBS;

JOB_NAME聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 ELAPSED_TIME
———————-聽聽聽聽聽聽聽聽 ————————-
GETPARTTODISPATCHTABLE聽聽聽聽聽聽聽聽 +002 19:27:47.00聽聽

I want to stop the job, but failed and tells me that the job is not running.

SQL> exec dbms_scheduler.stop_job(‘GETPARTTODISPATCHTABLE’);

begin dbms_scheduler.stop_job(‘GETPARTTODISPATCHTABLE’); end;

ORA-27366: job “RES.GETPARTTODISPATCHTABLE” is not running
ORA-06512: at “SYS.DBMS_ISCHED”, line 164
ORA-06512: at “SYS.DBMS_SCHEDULER”, line 483
ORA-06512: at line 2

And when try to drop the job, it tells me that the job is running so can not be dropped. Very strange.

SQL> exec dbms_scheduler.drop_job(‘GETPARTTODISPATCHTABLE’);

begin dbms_scheduler.drop_job(‘GETPARTTODISPATCHTABLE’); end;

ORA-27478: job “RES.GETPARTTODISPATCHTABLE” is running
ORA-06512: at “SYS.DBMS_ISCHED”, line 178
ORA-06512: at “SYS.DBMS_SCHEDULER”, line 544
ORA-06512: at line 2

I have tried many times to kill the session but failed.
And finally I find drop_job function can be executed forcely.

SQL> exec dbms_scheduler.drop_job’GETPARTTODISPATCHTABLE’,true);

PL/SQL procedure successfully completed

Created on April 23, 2013

Environment:
Oracle:
Oracle 10g Release 2聽 10.2.0.1
OS:
Windows 2003

One customer鈥檚 database crashed and alert.log shows like

Tue Apr 16 04:00:04 2013

Errors in file c:\admin\opcon\bdump\opcon_mmon_5592.trc:

ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kmgs_parameter_update_timeout_1] [27091]

ORA-27091: Message 27091 not found; No message file for product=RDBMS, facility=ORA

ORA-27070: Message 27070 not found; No message file for product=RDBMS, facility=ORA

OSD-04008: WriteFile() failure, unable to write to file

O/S-Error: (OS 5) Access is denied. Read More…

Created on Feb 6, 2013

Environment:
Oracle:
Oracle 10g Release 2聽 10.2.0.5
OS:
Linux
Summary:
Fix Oracle EM problem:Failed to shutdown DBConsole Gracefully

Read More…

oracle 11g聽11.2.0.3 patch聽

oracle support account is not needed, paste the link in xunlei and directly download Read More…

Created on June 8th,2011
Envirement:
Oracle:
Oracle 10g Release 2聽 10.2.0.5
OS:
Windows Server 2008 R2 Enterprise
Summary:
When create db together with dbconsole, the installation will encounter en error, db creatation is successful but dbconsole fails.
After that, create dbconsole manually, repository creatation is successful but when start dbconsole service, it wait a long and report error. Read More…

Created on 04.02.2011
Envirement:
Oracle version:
Oracle 10g Release 2聽 10.2.0.5
OS version:
Windows Server 2003 Enterprise
Summary:

DB is always in quiescing when using EMCA to reinstall OEM, can not connect to db except using sys or system
Read More…

Created on 01.19.2011
Environment:
Oracle Version:
Oracle 9i Release 2 9.2.0.6
OS:
Windows Server 2003 Enterprise
Summary:
Today when I execute a simple sql, a error jump out and tell me “ORA-25153: Temporary Tablespace is Empty”.
Right away, I search temp tablepsace and can not find it.
Where is my temp tablespace? Read More…

Created on 11.26.2010
Environment:
Oracle Version:
Oracle 10g Release 2 10.2.0.5
OS:
Windows 2008 Server R2
Summary:

About how to solve the oracle error like ‘Thread 1 cannot allocate new log, sequence 19, Checkpoint not complete’

Read More…

Created on 09.19.2010
Enterprise:
Windows 2000
Oracle 9.2.0.6
Summary:
One of my customer’s old oracle 9i need to be upgraded to 10g. To prevent damaging source database, I want to clone an environment using rman backup sets.
This is a record of my processes.

Read More…