1748165 Members
3712 Online
108758 Solutions
New Discussion юеВ

Re: dbca problem

 
Pinki Meggi
Frequent Advisor

dbca problem

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
7 REPLIES 7
Peter Godron
Honored Contributor

Re: dbca problem

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.
Hein van den Heuvel
Honored Contributor

Re: dbca problem

>> 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
Yogeeraj_1
Honored Contributor

Re: dbca problem

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Pinki Meggi
Frequent Advisor

Re: dbca problem

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
Oviwan
Honored Contributor

Re: dbca problem

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
Pinki Meggi
Frequent Advisor

Re: dbca problem

As attach the init.ora file.

I will try then create the database thru sql.
Pinki Meggi
Frequent Advisor

Re: dbca problem

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