ORA-03113 ORA-24323 ORA -01041 ( Startup Nomount Error)

Hi Experts,

I have installed Oracle 10.1.0.2.0 on Solaris 10 (SPARC). As soon as i have installed Oracle, i have applied Oracle 10.1.0.5.0 patch. Now when i try to connect the the database for the FIRST time to create my database, this is the error i am getting:

################################################
[oracle@sun4 ~]$ cd $ORACLE_HOME/dbs
[oracle@sun4 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Feb 9 19:44:58 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORA-03113: end-of-file on communication channel
SQL> startup nomount pfile = /u01/app/oracle/product/10.1.0/dbs/initXBRTEST.ora
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
################################

I have checked initXBRTEST.ora file which is the parameter file again and again and i cant see any mistakes. Could you please let me know what is going on and how i can solve this problem. This is the first time i am getting such sort of problem. Also in the $ORACLE_HOME/dbs directory there are core directories being generated whenver i try to startup nomount.


#######################

[oracle@sun4 dbs]$ ls
core_520          core_529          core_560          core_575          core_591          init.ora          initXBRTEST.ora
core_522          core_532          core_562          core_582          core_599          initdw.ora        initXBRTEST1.ora

##############################################

Thanks in advance

LVL 4
vamsi_ukAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dianep01Commented:
This may be related to unpublished Bug 375230, try the following:-
Oracle say to try any of the following:-
Solution
Any one of the following solutions may resolve the problem:
1. Upgrade the database. This problem has been corrected in database versions 9.2.0.7, 10.1.0.4, and 10.2.0.1.
2. Check the sqlnet.ora located in $ORACLE_HOME/network/admin or in the TNS_ADMIN location for leading spaces in front of parameters.
3. Verify all hosts in protocol.invited_nodes do not have unresolvable hosts listed.
4. Comment out the parameters protocol.validnode_checking and protocol.invited_nodes.
5. Set protocol.validnode_checking = no in the sqlnet.ora file.
6. Apply one-off Patch 3752301 if available for your platform/version from MetaLink.
0
rbrookerCommented:
try looking at this link, it may help.

http://www.orafaq.com/forum/t/38256/0/
0
schwertnerCommented:
As usually this may be connected with missing registration of the service.
Solution here: http://www.experts-exchange.com/Database/Oracle/10.x/Q_22684219.html

If this doesn't help check for firewalls and antiviruses ON the server machine and turn the OFF!

Next step: Read carefully the installation manual and check if ALL steps are done.
                  Pay attention to all environment variables: ORACLE_HOME, ORACLE_BASE, ORACLE_SID, PATH

See how many products you have on the server. Is your installation on different Oracle Home? What are the first entries in PATH? Do they point to the new $ORACLE_HOME/bin.

Do you use exotic way to access the server? Console, terminal or other remote tools? Try to run your commands directly from the server machine.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

schwertnerCommented:
Also have you upgraded the Catalog, after upgrading the software.
Did you run catupgrd.sql script in ..../rdbms/admin directory?
Is it run correctly?
0
hamitaCommented:
Simply re-connect as SYSDBA and perform STARTUP again:

1. SQL> CONNECT / AS SYSDBA
Connected to an idle instance.

2. SQL> STARTUP
ORACLE instance started.

3. SQL> SHOW PARAMETERS SPFILE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      %ORACLE_HOME%\DATABASE\SPFILE%
                                                 ORACLE_SID%.ORA
0
vamsi_ukAuthor Commented:
hi guys,

schwertner:
 there are no firewalls or any anti virus products on the server. I have just installed the operating system and then immediately installed Oracle software, and applied 10.1.0.5.0 patch even before i have created my first database. Also, i have tried to create the database after removing the patch just to m ake sure that it is not an  issue caused by the patch. i have chcked ORACLE_HOME and ORACLE_SID and they are fine. Woudl it help you guys to  paste my init.ora file?

hamita:
I am trying to create the database for the first time on my system.  I need to execute my create database script from the nomount state
0
vamsi_ukAuthor Commented:
Here is a screenshot of the commands i am executing and also my init.ora file
############################################################
[oracle@sun4 ~]$ echo $ORACLE_SID
XBRTEST
[oracle@sun4 ~]$ export ORACLE_SID=XBRTEST
[oracle@sun4 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Feb 11 15:48:05 2008

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile=/u01/app/oracle/product/10.1.0/dbs/initXBRTEST.ora
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
####################################################
initXBRTEST.ora

# replace DEFAULT with your database name
db_name = XBRTEST

db_files = 80                                                         # SMALL

db_cache_size = 8192
db_file_multiblock_read_count = 8                                     # SMALL
db_block_buffers = 100                                                 # SMALL
shared_pool_size = 3500000                                            # SMALL
log_checkpoint_interval = 10000
processes = 50                                                        # SMALL
parallel_max_servers = 5                                              # SMALL
log_buffer = 32768                                                    # SMALL
max_dump_file_size = 10240      # limit trace file size to 5 Meg each
global_names = TRUE


# define two control files by default
control_files = (/u04/app/oracle/oradata/XBRTEST/control01/ctl, /u01/app/oracle/oradata/XBRTEST/control02.ctl)

background_dump_dest = /u01/app/oracle/admin/XBRTEST/bdump
core_dump_dest = /u01/app/oracle/admin/XBRTEST/cdump
user_dump_dest = /u01/app/oracle/admin/XBRTEST/udump


undo_management = AUTO
undo_tablespace = UNDOTBS
undo_retention = 900

0
schwertnerCommented:
Old trap!
You have to install Oracle choosing the option "Create database"
The installer will create the database.
I think the troubles you run into are caused by your decision to install
only the software.
After you install the software and it creates the DB you can:
1. Upgrade the software to what you want
2. Drop the DB using
% dbca
3. Create a new DB using
% dbca
4. For your suprise you need to upgrade the DB using catupgrd.sql script

I would ask you why you choose to install the old 10g R1 version (10.1.0.2.0 )
instead of enhacent 10g R2 (10.2.0.1) version and then upgrade
to 10.2.0.3 that is the current stable and enhanced release of 10g?
0
vamsi_ukAuthor Commented:
We have a client whose infrastructure is managed by my company. They have a primary database and a standby database running on Oracle 10.1.0.5. I am trying to replicate the same setup on our lab to familiarise myself.

From your suggestions, Am i right in saying that if we install Oracle 10.1.0 with "only software install", we cannot create the databse manually?
0
schwertnerCommented:
You can create DB manually after you have a working Oracle Installation.
But to have working (right now you have no working) installation
you have to choose "create DB" option and to check that you have
working installation. After that you can drop the DB and create
(using DBCA tool, this is GUI tool, invoke it using graphical environment)
a new DB with parameters and especially CHARACTER SET (most important
parameter) you need. Nevertheles you obligatory need to upgrade the created DB
to 10.1.0.5 (if you have upgraded the software to 10.1.0.5) using
catupgrd.sql script (please read the instruction how to do this,
there are important prerequisites like SYSTEM tablespace 50 MB free space,
java_pool_size and shared_pool_size at least 150 MB big and so on).
Dont hurry and follow to advicess in order to not suffer old issues.
0
vamsi_ukAuthor Commented:
I will try your suggestion right away. Since we use standard builds on all the client systems, we have all the packages and patches on our build server. Originally when i installated the software, even before trying to create the first database i have used runInstaller for the patchset.

Now i will first try your suggestion and reinstall the software with default database option and let you know if i can startup the databse.

thanks
0
schwertnerCommented:
As I recall you are not the first who complains that things go bad
after installing the software only. Pay attention to the version of
installation kit (Sun Solaris, 32 or 64 bits, etc)
Good Luck!
0
vamsi_ukAuthor Commented:
Its really getting wierd..

while installation of the software i have chosen the "create databse2 options too. now the software got installed and whi;e databsae creation, it crashed again with ORA-0141: internal error. hostdef doesn't exist  (this is at creating and starting oracle instance state)

0
jwittenmCommented:
Make sure your environment variables are set when creating the database.  ORACLE_SID, ORACLE_HOME.
0
schwertnerCommented:
Check the Java version you have installed.
Check the Oracle distribution kit you use - is it for this OS and CPU?

Read carefully the installation documentation and check every parameter.
Download it from the OTN.
0
schwertnerCommented:
Possibly your SWAP partition on the hard disk is not big enough.
Read the Installation manuall - it has to about 3 times the size of the RAM.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vamsi_ukAuthor Commented:
Hi guys,

sorry for the late response. I have tried everything, checked all the parameters are set properly and all memory values are also set accordingly. but nothing worked.

however, when i tried Oracle 10g R2, it worked like a charm. So im not sure why R1 fails and R2 installs without any problem. Anyway, for now i have decided that i will stick to R2 for a while.

thanks for all the suggestions guys

0
schwertnerCommented:
10g R1 is starter version of a new Oracle family.
This explains some troubles.
For instance Data Pump is working stable only in 10g R2.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.