Home » Infrastructure » Unix » Error while attempting to create database on Solaris 10
Error while attempting to create database on Solaris 10 [message #300898] Mon, 18 February 2008 10:31 Go to next message
ifedolapo.atinmo
Messages: 7
Registered: February 2008
Location: Lagos Nigeria
Junior Member

Sad Sad

Hello,

I have been trying to create an oracle database after installing oracle 10.1.0.2 on my solaris v 5.10 system.
During the database creation it gives an error and I am forced to abort..

The error is ORA-01041: internal error. hostdef extension does not exist.

I saw a solution that there are some unneccessary patches that hinder the database from being created. I would like to know these patches so I can uninstall them..

Please if anybody has a solution for me.. Help!!!!
Re: Error while attempting to create database on Solaris 10 [message #300901 is a reply to message #300898] Mon, 18 February 2008 10:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is a very generic error usually involved with your environment and accompanied by more errors / trace. Look into your aler_sid.log. Post relevant details.
>>I saw a solution that there are some unneccessary patches that hinder the database from being created. I would like to know these patches so I can uninstall them..
Not sure what you are talking about. It is your machine. You should be knowing the installed patches. Try lsinventory?
Re: Error while attempting to create database on Solaris 10 [message #301051 is a reply to message #300901] Tue, 19 February 2008 01:28 Go to previous messageGo to next message
ifedolapo.atinmo
Messages: 7
Registered: February 2008
Location: Lagos Nigeria
Junior Member

Hey Mahesh,

Thank you for your response..
Please find below the contents of my alert_SID.log files.
I tried to create 2 different databases..
I am really new to oracle and need assistance..
And also I did not put any new patches but learnt that some of the preinstalled patches will not allow oracle 10.1.0.2 to work properly on Solaris 10..
Sad Sad Sad


oracle @ SYS02-ZONE01 /opt/oracle/app/oracle/product/rdbms/log > cat alert_orcl.log
Mon Feb 18 05:30:09 2008
Errors in file /opt/oracle/app/oracle/product/rdbms/log/orcl_ora_9762.trc:
ORA-07445: exception encountered: core dump [kcbbnwa()+448] [SIGFPE] [Integer divide by zero] [0x100ECCFE0] [] []
Mon Feb 18 05:30:33 2008
Shutting down instance (abort)
oracle @ SYS02-ZONE01 /opt/oracle/app/oracle/product/rdbms/log > cat alert_bgw.log
Wed Feb 13 05:07:15 2008
Errors in file /opt/oracle/app/oracle/product/rdbms/log/bgw_ora_15107.trc:
ORA-07445: exception encountered: core dump [kcbbnwa()+448] [SIGFPE] [Integer divide by zero] [0x100ECCFE0] [] []
Wed Feb 13 05:29:28 2008
Shutting down instance (abort)
Wed Feb 13 21:49:47 2008
Errors in file /opt/oracle/app/oracle/product/rdbms/log/bgw_ora_6026.trc:
ORA-07445: exception encountered: core dump [kcbbnwa()+448] [SIGFPE] [Integer divide by zero] [0x100ECCFE0] [] []
Wed Feb 13 21:50:47 2008
Errors in file /opt/oracle/app/oracle/product/rdbms/log/bgw_ora_6047.trc:
ORA-07445: exception encountered: core dump [kcbbnwa()+448] [SIGFPE] [Integer divide by zero] [0x100ECCFE0] [] []
Wed Feb 13 21:50:56 2008
Shutting down instance (abort)
Thu Feb 14 00:17:41 2008
Errors in file /opt/oracle/app/oracle/product/rdbms/log/bgw_ora_4285.trc:
ORA-07445: exception encountered: core dump [kcbbnwa()+448] [SIGFPE] [Integer divide by zero] [0x100ECCFE0] [] []
Thu Feb 14 00:18:08 2008
Shutting down instance (abort)
Thu Feb 14 00:18:13 2008
Errors in file /opt/oracle/app/oracle/product/rdbms/log/bgw_ora_4312.trc:
ORA-07445: exception encountered: core dump [kcbbnwa()+448] [SIGFPE] [Integer divide by zero] [0x100ECCFE0] [] []
Thu Feb 14 00:18:49 2008
Errors in file /opt/oracle/app/oracle/product/rdbms/log/bgw_ora_4314.trc:
ORA-07445: exception encountered: core dump [kcbbnwa()+448] [SIGFPE] [Integer divide by zero] [0x100ECCFE0] [] []
Thu Feb 14 00:18:53 2008
Shutting down instance (abort)
Thu Feb 14 00:21:55 2008
Errors in file /opt/oracle/app/oracle/product/rdbms/log/bgw_ora_4393.trc:
ORA-07445: exception encountered: core dump [kcbbnwa()+448] [SIGFPE] [Integer divide by zero] [0x100ECCFE0] [] []
Thu Feb 14 00:22:09 2008
Shutting down instance (abort)
oracle @ SYS02-ZONE01 /opt/oracle/app/oracle/product/rdbms/log >
Re: Error while attempting to create database on Solaris 10 [message #301054 is a reply to message #301051] Tue, 19 February 2008 01:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
metalink note 378258.1
Re: Error while attempting to create database on Solaris 10 [message #301061 is a reply to message #300898] Tue, 19 February 2008 01:47 Go to previous messageGo to next message
ifedolapo.atinmo
Messages: 7
Registered: February 2008
Location: Lagos Nigeria
Junior Member

Thanks once again Mahesh..
I am very very new to Oracle. I have not been able to locate the solution.
Please I would be most grateful if you could help copy and post the solution here.
Thanks once again..
Re: Error while attempting to create database on Solaris 10 [message #301062 is a reply to message #301061] Tue, 19 February 2008 01:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I am not supposed to do it. It is copyrighted material.
Re: Error while attempting to create database on Solaris 10 [message #301063 is a reply to message #301061] Tue, 19 February 2008 01:57 Go to previous messageGo to next message
ifedolapo.atinmo
Messages: 7
Registered: February 2008
Location: Lagos Nigeria
Junior Member



Ok then can you just help with an idea of what to do.. Please!!
Smile
I am on a new job and really need for this to work..
Re: Error while attempting to create database on Solaris 10 [message #301065 is a reply to message #301063] Tue, 19 February 2008 02:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The said is reported only on 10.1.0.2 to 10.1.0.5.
I myself never had any issues with all my recent 10gR2 (10.2.*) installs in Solaris (single and rac).
Try 10gR2?
Re: Error while attempting to create database on Solaris 10 [message #301067 is a reply to message #300898] Tue, 19 February 2008 02:09 Go to previous messageGo to next message
ifedolapo.atinmo
Messages: 7
Registered: February 2008
Location: Lagos Nigeria
Junior Member

10.2.0 works very fine but the server application I need to run works with only 10.1.0.2.. Thats where I have a problem now..
Re: Error while attempting to create database on Solaris 10 [message #301078 is a reply to message #301067] Tue, 19 February 2008 02:47 Go to previous messageGo to next message
ifedolapo.atinmo
Messages: 7
Registered: February 2008
Location: Lagos Nigeria
Junior Member

Any other suggestions for me? Confused
Re: Error while attempting to create database on Solaris 10 [message #301086 is a reply to message #301078] Tue, 19 February 2008 03:05 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:
I have not been able to locate the solution.


Since you said not able to LOCATE, you have a login to metalink and have looked and just haven't found it?

- Log into https://metalink.oracle.com/
- Select "Document ID" in the "Quick Find" drop down.
- Paste "378258.1" into the text field
- Click on "go"
Re: Error while attempting to create database on Solaris 10 [message #301097 is a reply to message #301086] Tue, 19 February 2008 03:32 Go to previous messageGo to next message
ifedolapo.atinmo
Messages: 7
Registered: February 2008
Location: Lagos Nigeria
Junior Member


Hi Thomas,

I do not have a login to metalink.. I am not a frequent Oracle user. I am a Solaris system Administrator. I would be most grateful if you could assist...
Re: Error while attempting to create database on Solaris 10 [message #301104 is a reply to message #301097] Tue, 19 February 2008 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Noone here can post the solution without violating his license agreement with Oracle.
Is this what you want?

Regards
Michel

[Updated on: Tue, 19 February 2008 03:43]

Report message to a moderator

Re: Error while attempting to create database on Solaris 10 [message #301110 is a reply to message #301104] Tue, 19 February 2008 03:52 Go to previous message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You should check with your supervisor or with the company who is running the database if they have either a Metalink login or a support identifier in the contract or invoice from oracle, which then can than be used to create a Metalink login.

Previous Topic: shell script to check the lsitener
Next Topic: unix script to takes the old data from a TXT file and compress them into new file
Goto Forum:
  


Current Time: Sun Nov 24 23:55:50 CST 2024