Archive

Archive for February, 2012

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

February 29, 2012 7 comments

I installed oracle XE  on redhat 5.5. The installation is successfully and the /etc/init.d/oracle-xe configure is completed successfully. But when I start, it show

1. ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [],

2. There is no process listening 8080 port

3. There is nothing under /usr/lib/oracle/xe/oradata/XE/

Finally, I find out the cause. Since the server hostname is not matching the name in /etc/hosts. After correct, reinstall Oracle XE

root@yecvm_dblinkgw sysop]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Preparing…                ########################################### [100%]
1:oracle-xe-univ         ########################################### [100%]
Executing Post-install steps…

You must run ‘/etc/init.d/oracle-xe configure’ as the root user to
configure the database.

[root@yecvm_dblinkgw sysop]# /etc/init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener…Done
Configuring Database…

Categories: ORA-XXX

ORA-16072: a minimum of one standby database destination is required

February 29, 2012 Leave a comment

Today, I try to restore a production database to a testing server. When I opened the database, it showed the ERRORS below

“ORA-16072: a minimum of one standby database destination is required”.

Since there is no standby in testing environment, I try to workaround as the following

SQL> startup mount;
ORACLE instance started.

Database mounted.
SQL> alter database set standby database to maximize performance;

Database altered.

SQL> alter database open ; <– I successfully open the database

Database altered.

Categories: ORA-XXX, RMAN, Standby database

Fix “InnoDB: Unable to lock ./ib_logfile0, error: 11”

February 27, 2012 Leave a comment

Symptoms

1. The mySQL database hung

2. Reboot the server try to restart the mySQL database

3. After that, the mySQL database couldn’t start, and showed following errors

120226 12:23:59 [Note] Plugin ‘FEDERATED’ is disabled.

120226 12:23:59 InnoDB: The InnoDB memory heap is disabled

120226 12:23:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins

120226 12:23:59 InnoDB: Compressed tables use zlib 1.2.3

120226 12:23:59 InnoDB: Using Linux native AIO

120226 12:23:59 InnoDB: Initializing buffer pool, size = 8.0G

120226 12:23:59 InnoDB: Completed initialization of buffer pool

InnoDB: Unable to lock ./ib_logfile0, error: 11

InnoDB: Check that you do not already have another mysqld process

InnoDB: using the same InnoDB data or log files.

InnoDB: Error in opening ./ib_logfile0

120226 12:23:59 [ERROR] Plugin ‘InnoDB’ init function returned error.

120226 12:23:59 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

120226 12:23:59 [ERROR] Unknown/unsupported storage engine: InnoDB

120226 12:23:59 [ERROR] Aborting

 

Fixed Procedures

1. Go to the database directory

2. Backup the ./ib_logfile0 and copy a new one

# mv ib_logfile0 ib_logfile0.bkup

# cp -a ib_logfile0.bkup ib_logfile0

3 Restart the mySQL database

# /etc/init.d/mysql.server start

 

Categories: mySQL troubleshooting