Oracle 10g create database hiba

Oracle Server-Enterprise and Standard Edition/DBA Administration Technical Forum

Displayed below are the messages of the selected thread.

Thread Status: Active

From: Herbert KRUMHUS 25-Apr-06 07:56
Subject: Not able to create database via dbca

RDBMS Version:
Operating System and Version: SUN SOLARIS 10
Error Number (if applicable): 1041 and 7445
Product (i.e. SQL*Loader, Import, etc.): DBCA
Product Version: 10.1.0.5

Not able to create database via dbca

Hello,
I'm not able to create any database using the dbca.
Everytime I received a message box with the following error:
"ORA-01041: internal error.hostdef extension doesn't exist"
In the alert logfile I found this message:
"ORA-07445: exception encountered: core dump [kcbbnwa()+360] [SIGFPE] [Integer divide by zero] [0x
100F245E8] [] []"
In the corrosponding trace file are the following entries:
"Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/oracle/prg
System name: SunOS
Node name: mssnsrp5
Release: 5.10
Version: Generic_118822-20
Machine: sun4u
Instance name: oratest
Redo thread mounted by this instance: 0
Oracle process number: 0
1341

kstwlb: SGA is no longer mapped
Exception signal: 8 (SIGFPE), code: 1 (Integer divide by zero), addr: 0x100f245e8, PC: [0x100f245
e8, kcbbnwa()+360]
*** 2006-04-25 08:52:30.246
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kcbbnwa()+360] [SIGFPE] [Integer divide by zero] [0x
100F245E8] [] []
Current SQL information unavailable - no SGA."

What's my fault?
Are there any problems with the installation of ORACLE?

From: Andrew Allen 25-Apr-06 13:30
Subject: Re : Not able to create database via dbca

It looks to me like you have three options here:
1) try creating the database using scripts / from the command line to see exactly at what stage the problem is occuring -- also creates database using a different method than dbca, so it may work where dbca does not.

2) reinstall oracle to see if this does not solve the problem -- but only if you do not have a working database on tha server already.

3) contact support for help

From: Herbert KRUMHUS 25-Apr-06 14:11
Subject: Re : Re : Not able to create database via dbca

Thanks for your help, but the error will not disappear.
Not even after a reinstallation of ORACLE, the same behaviour.
No database will be created, not during the installation and not by using the dbca.

I think the instance can't be started in a correct way.

From: Andrew Allen 25-Apr-06 15:51
Subject: Re : Re : Re : Not able to create database via dbca

Try this, in a script -- edit file names as appropriate to your server:

# connect SYS/change_on_install as SYSDBA
set echo on
spool CreateDB.log
startup nomount pfile="/u01/app/oracle/product/10.1.0/dbs/initMY_DB.ora"
CREATE DATABASE MY_DB
USER SYS IDENTIFIED BY DoNotUse
USER SYSTEM IDENTIFIED BY getfired
LOGFILE GROUP 1 ('/w01/oradata/MY_DB/redo01a.log',
'/w05/oradata/MY_DB/redo01b.log') SIZE 4M,
GROUP 2 ('/w02/oradata/MY_DB/redo02a.log',
'/w05/oradata/MY_DB/redo02b.log') SIZE 4M,
GROUP 3 ('/w03/oradata/MY_DB/redo03a.log',
'/w05/oradata/MY_DB/redo03b.log') SIZE 4M,
GROUP 4 ('/w04/oradata/MY_DB/redo04a.log',
'/w05/oradata/MY_DB/redo04b.log') SIZE 4M
/* check these parameters for sufficiency */
MAXINSTANCES 8
MAXLOGFILES 16
MAXLOGMEMBERS 5
MAXLOGHISTORY 3276
MAXDATAFILES 4096
MAXLOGHISTORY 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u04/oradata/MY_DB/system_01.dbf' SIZE 512M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u04/oradata/MY_DB/sysaux_01.dbf' SIZE 120M REUSE
AUTOEXTEND OFF
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u05/oradata/MY_DB/temp_01.dbf' SIZE 512M REUSE
AUTOEXTEND OFF
DEFAULT TABLESPACE users
DATAFILE '/u04/oradata/MY_DB/users_01.dbf' SIZE 64M REUSE
AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
UNDO TABLESPACE undo
DATAFILE '/u07/oradata/MY_DB/undo_01.dbf' SIZE 1024M REUSE
AUTOEXTEND OFF;
spool off
-- exit;

to use this script;
1. edit your oratab file to make an entry for your database.
2. set ORACLE_SID to your database name (MY_DB)
3. Make sure you have an initMY_DB.ora file in the right place -- usually ORACLE_HOME/dbs directory
4. Put the above create db command in a sql file and edit it to put correct paths and change 'MY_DB' to your database name.
Make sure your ORACLE_HOME is set properly and is included in your PATH variable.
5. determine if you need LD_LIBRARY_PATH set for your os and do so if necessary.

from the same directory as the file you just created -- step 4,
login to oracle as SQLPLUS "/ as sysdba". You will be connected to an idle instance. Then execute the create db sql file, something like @createdb.sql

It will either work -- and take a couple of minutes to create the files and then return with 'database created', or it will fail and give you a message in the spool file.

If this works, then all you need do is run the catalog and options scripts.

good luck

From: Herbert KRUMHUS 26-Apr-06 06:27
Subject: Re : Re : Re : Re : Not able to create database via dbca

Hi Andrew,
I tried the script and the command
"startup nomount pfile ..."
brings up the described problem. In the sqlplus environment the following error appears:
"ORA-01041: internal error. hostdef extension doesn't exist"
and in the corresponding trace file I have the same entries as described before.
"Exception signal: 8 (SIGFPE), code: 1 (Integer divide by zero), addr: 0x100f24648, PC: [0x100f24648, kcbbnwa()+360]
*** 2006-04-26 07:20:32.548
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kcbbnwa()+360] [SIGFPE] [Integer divide by zero] [0x100F24648] [] []
Current SQL information unavailable - no SGA."

Perhaps there is something wrong in the system (SOLARIS 10)?
Perhaps the kernel parameters are not set in a correct way.

Thanks for your help.
Best Regards.

From: Oracle, imran qureshi 26-Apr-06 12:57
Subject: Re : Not able to create database via dbca

Hi
Have you applied any patch recently? Sun Solaris x86 OS Patch 119565-01 or Sun SPARC OS Patch 119564-01.
See article 312533.1 for details.
Thanks
Imran

From: Herbert KRUMHUS 27-Apr-06 05:47
Subject: Re : Re : Not able to create database via dbca

Hi,
I've seen that there is another SUN SOLARIS patch (119564-01) and I wanted to download it from sun, but this patch is no longer available.
It is withdrawn by sun, so is there another patch which I have to install in place of 119564-01?

Thanks a lot and
best regards.

From: Herbert KRUMHUS 27-Apr-06 07:06
Subject: Re : Not able to create database via dbca

Hi,
now I'm able to create databases with the dbca!
With a SUN-Admin I analyzed the OS and he told me that there several patches in the system which are not necessary.
So I removed any installed patches and now everything works fine.
I don't know which patch raised the problem, but now everything works as wanted :-)))))

Thanks a lot to all!

Best Regards.

--
God bless IQ

Subject: ORA-1041 AND ORA-7445 AFTER APPLYING SUN OS PATCH 119565-01 OR OS PATCH 119564-01
Doc ID: Note:312533.1 Type: PROBLEM
Last Revision Date: 16-JUN-2005 Status: REVIEW_READY

In this Document
Symptoms
Changes
Cause
Solution
References

@ (AuthWiz 2.2)
@ Click here to edit in wizard.

Applies to:
Oracle Server - Enterprise Edition - Version:
Solaris Operating System (x86)
Solaris Operating System (SPARC 64-bit)
Solaris Operating System (SPARC 32-bit)
Symptoms

You are running 10g on Solaris Release 10_x86 or Solaris SPARC Release 10 and after applied the OS Patch 119565-01 on 10_x86 or OS Patch 119564-01 on SPARC Release 10 you cannot startup the database and you receive ORA-1041 and ORA-7445. The stack trace looks like the following:

ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [0] [] [] []
Current SQL information unavailable - no SGA.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------

ksedmp
ssexhd
sighndlr
call_user_handler
sigacthandler
prune_cpus
prune_tree
lgrp_init
skgsnisize
kcbsnu
lrmpsvp
lrmpsvp
lrmpsvp
lrmpsvp
lrmpsvp
lrmpsvp
lrmpsvp
lrmpsvp
lrmpsvp
lrmpsvp
lrmpsvp
lrmsmv
kspptsp
kpoparsp
opiodr
ttcpip
opitsk
opiino
opiodr
opidrv
sou2o
main
start

--------------------- Binary Stack Dump ---------------------
Changes
Applied the Sun Solaris x86 OS Patch 119565-01 or Sun SPARC OS Patch 119564-01
Cause

This is a Sun bug:

"adding patch 119564-01 to my Solaris 10 system, causes Oracle 10g to dump core"
Solution

The solution is to install patch:

118822-03 (SPARC)
118844-02 (x86)

However, at the time this article is written, these patches are not released yet.
The solution would be to backout that patch until the above patches are released.

References
Bug 4392885 - Ora-1041 And Ora-7445 Are Caused After Applying Os Patch 119565-01
http://sunsolve.sun.com/search/document.do?assetkey=1-21-119565-01
http://sunsolve.sun.com/search/document.do?assetkey=1-21-119564-01
Sun Alert ID: 101757
Errors
ORA-7445:SIGSEGV
ORA-1041 "internal error. hostdef extension doesn't exist"
ORA-7445 "exception encountered: core dump [%s] [%s]"

Key Facts

'119564-01' '119565-01' 'LGRP_INIT' 'PRUNE_CPUS' 'PRUNE_TREE' 'SKGSNISIZE'

Help us improve our service. Please email us your comments for this document. .
--
God bless IQ