topic dbca problem in Operating System - HP-UX

dbca problem

Pinki Meggi — Tue, 23 Jan 2007 10:13:36 GMT

Hi,

Im trying to install the Oracle 9i (9.2.0.1.0) on a HP-UX 11.11 machine. The software was installed sucessfully. However, while creating the database using dbca it hangs after the last step ( after reviewing the information, when click OK, nothing appears until long time ).

Im not understanding what's the problem, and need help.
Anyone had a similar problem?
I want to know also where i can see the log information.

Thanks in advance for help.

Best Regards!

Pinki

Re: dbca problem

Peter Godron — Tue, 23 Jan 2007 10:38:08 GMT

Hi,
check in $ORACLE_HOME/assistants/dbca/logs

I tend to create the databases by hand, especially if it is only a dummy test one.

Re: dbca problem

Hein van den Heuvel — Tue, 23 Jan 2007 10:42:16 GMT

>> nothing appears until long time

Did something show up by now?

Please quantify 'long time'.

While nothing appeared, was the system doing something?
CPU cycles being consumed?
Did you ask it to create a large (hundreds GB) database and is it doing heavy (write) IO?

Can you track any progress?
Entries in the alert log?
DB files apprearing in directories?

Personally I don't care much for dbca. It helps too much and thus hides too much.
I prefer to do run my own sql> create database...
That gets me to know my DB better and if something goes wrong it seems more clear (to me) what step failed.

fwiw,
Hein van den Heuvel

Re: dbca problem

Yogeeraj_1 — Wed, 24 Jan 2007 00:22:13 GMT

hi Pinki,

After the failure, did you try to launch the dbca again and retry the operation?

You can get more information about the errors generated by the dbca by reviewing the log files in these two directories:
$ORACLE_HOME/cfgtools/dbca
and
$ORACLE_HOME/cfgtools/dbca/

e.g. /d01/app/oracle/product/10.2.0/db_2/cfgtoollogs/dbca/
/d01/app/oracle/product/10.2.0/db_2/cfgtoollogs/dbca/mydb

below an example of log files corresponding your current installation, that would be available: (/d01/app/oracle/product/10.2.0/db_2/cfgtoollogs/dbca/mydb)
-rw-r----- 1 oracle oinstall 43385 Jan 23 21:02 CreateDB.log
-rw-r----- 1 oracle oinstall 42534008 Jan 23 21:27 CreateDBCatalog.log
-rw-r----- 1 oracle oinstall 25404 Jan 23 21:27 sqlPlusHelp.log
-rw-r----- 1 oracle oinstall 443729 Jan 23 21:34 JServer.log
-rw-r----- 1 oracle oinstall 587730 Jan 23 21:35 odm.log
-rw-r----- 1 oracle oinstall 1631344 Jan 23 21:35 context.log
-rw-r----- 1 oracle oinstall 685542 Jan 23 21:37 xdb_protocol.log
-rw-r----- 1 oracle oinstall 80366 Jan 23 21:37 ordinst.log
-rw-r----- 1 oracle oinstall 614328 Jan 23 21:44 interMedia.log
-rw-r----- 1 oracle oinstall 5177480 Jan 23 21:47 cwmlite.log
-rw-r----- 1 oracle oinstall 2150550 Jan 23 21:51 spatial.log
-rw-r----- 1 oracle oinstall 6548806 Jan 23 21:53 emRepository.log
-rw-r----- 1 oracle oinstall 25158 Jan 23 21:53 lockAccount.log
-rw-r----- 1 oracle oinstall 59946 Jan 23 21:54 postDBCreation.log
-rw-r----- 1 oracle oinstall 1527 Jan 23 21:54 mydb152.log

Please go through the files and identify the error.

if you need any further assistance, please let us know

kind regards
yogeeraj

Re: dbca problem

Pinki Meggi — Wed, 24 Jan 2007 03:21:05 GMT

Hi,
Thanks for all replies.

First of all, im sorry i didint find the logs for dbaca. There is nothing in $ORACLE_HOME/assistants/dbca/logs. And strangly there is no cfgtools directory.

I had tried to launch the dbca again and the same things happen again.

It did not show anything and when i said long time its about 30 minutes and after that i cancel the application.

Im not creating a large database.

One thing that i have noticed that is it creates database directories ( oradata/siges ) and the admin directory with database information in init.ora file. Nothing more.

The logs would help me, but i cant find them.

Please any idea?

May i have to reinstall the software?!

Need help.

Best Regards

Pinki

Re: dbca problem

Oviwan — Wed, 24 Jan 2007 03:27:25 GMT

Hy

what size has the sga_max_size in init.ora? perhaps this is too large.

I recommend you to use a create database script...

Regards

Re: dbca problem

Pinki Meggi — Wed, 24 Jan 2007 03:41:02 GMT

As attach the init.ora file.

I will try then create the database thru sql.

Re: dbca problem

Pinki Meggi — Fri, 02 Feb 2007 09:45:39 GMT

Hi all,

Thanks for all replies. I had reinstall the software and after that i didnt have the same problema.

Thanks once again.

Best Regards

Pinki