- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: dbca problem
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2007 02:13 AM
тАО01-23-2007 02:13 AM
dbca problem
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2007 02:38 AM
тАО01-23-2007 02:38 AM
Re: dbca problem
check in $ORACLE_HOME/assistants/dbca/logs
I tend to create the databases by hand, especially if it is only a dummy test one.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2007 02:42 AM
тАО01-23-2007 02:42 AM
Re: dbca problem
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2007 04:22 PM
тАО01-23-2007 04:22 PM
Re: dbca problem
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2007 07:21 PM
тАО01-23-2007 07:21 PM
Re: dbca problem
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2007 07:27 PM
тАО01-23-2007 07:27 PM
Re: dbca problem
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2007 07:41 PM
тАО01-23-2007 07:41 PM
Re: dbca problem
I will try then create the database thru sql.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2007 01:45 AM
тАО02-02-2007 01:45 AM
Re: dbca problem
Thanks for all replies. I had reinstall the software and after that i didnt have the same problema.
Thanks once again.
Best Regards
Pinki