- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- problem when using dbca to create a database
Operating System - HP-UX
1752482
Members
5909
Online
108788
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО05-30-2002 09:05 AM
тАО05-30-2002 09:05 AM
problem when using dbca to create a database
I have this error when I tried to create
the database using dbca ORA-01092, instance terminated force..
what causes this? and why?
the database using dbca ORA-01092, instance terminated force..
what causes this? and why?
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-30-2002 04:51 PM
тАО05-30-2002 04:51 PM
Re: problem when using dbca to create a database
I also met this error using dbca to create db,so I just generate scripts,and use scripts to create db manually.may be your orapwd file or remote_login parameter need changed
xysco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-31-2002 01:24 AM
тАО05-31-2002 01:24 AM
Re: problem when using dbca to create a database
Hi,
What platform and what version of oracle are you running? If it is Oracle Server - Enterprise Edition 9.0.1.0.1 on MS Windows NT
then:
*************
symptom: Errors creating database
symptom: ORA-01092: ORACLE instance terminated. Disconnection forced.
symptom: Database is created from using scripts which the Database
Configuration Assistant generated
symptom: Parameter remote_login_passwordfile is set to shared or exclusive
symptom: Oracle Database Configuration Assistant has not created a password
file
cause: <2012202>
When creating a database using scripts generated by the DBCA, the password file does not get created, therefore creation fails as the DBCA sets the parameter remote_login_passwordfile to exclusive by default.
fix:
Fixed in 9.2
Workarounds:Use orapwd to create a password file.
orapwd file=%ORACLE_HOME%\database\PWD.ora password=
or Set parameter remote_login_passwordfile to none
*******************
Hope this helps.
Rgds,
Kawah
What platform and what version of oracle are you running? If it is Oracle Server - Enterprise Edition 9.0.1.0.1 on MS Windows NT
then:
*************
symptom: Errors creating database
symptom: ORA-01092: ORACLE instance terminated. Disconnection forced.
symptom: Database is created from using scripts which the Database
Configuration Assistant generated
symptom: Parameter remote_login_passwordfile is set to shared or exclusive
symptom: Oracle Database Configuration Assistant has not created a password
file
cause: <2012202>
When creating a database using scripts generated by the DBCA, the password file does not get created, therefore creation fails as the DBCA sets the parameter remote_login_passwordfile to exclusive by default.
fix:
Fixed in 9.2
Workarounds:Use orapwd to create a password file.
orapwd file=%ORACLE_HOME%\database\PWD
or Set parameter remote_login_passwordfile to none
*******************
Hope this helps.
Rgds,
Kawah
If in doubt, ask!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-04-2002 10:07 PM
тАО06-04-2002 10:07 PM
Re: problem when using dbca to create a database
Hello deanna,
Searched the metalink database for you.
Hope this helps.
Best Regards
Yogeeraj
Searched the metalink database for you.
Hope this helps.
Best Regards
Yogeeraj
Doc ID: Note:159324.1
Subject: ORA-1092 Instance Terminated When Creating A Database Via DBCA
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 29-SEP-2001
Last Revision Date: 04-JUN-2002
Problem Description
-------------------
While creating a database with the Oracle Database Configuration
Assistant (DBCA), it fails with the following message:
ORA-1092: oracle instance terminated. Disconnection forced.
Reviewing the alert.log for the database, you find the following
messages:
ORA-00379: no free buffers available in buffer pool
DEFAULT for block size 8K
Thu Sep 20 07:01:46 2001
Error 379 happened during db open, shutting down database
USER: terminating instance due to error 379
Instance terminated by USER, pid = 15683
ORA-1092 signalled during: alter database XBMS open resetlogs...
NOTE: If the ORACLE_BASE environment variable is set, then
the alert.log will be in $ORACLE_BASE/admin//bdump.
If not set, look in $ORACLE_HOME/admin//bdump or
wherever you changed the BACKGROUND_DUMP_DEST database
initialization parameter.
Solution Description
--------------------
Do not change the DB_BLOCK_SIZE if creating a database using one
of the Oracle9i templates which include datafiles. Go back in DBCA
and set DB_BLOCK_SIZE to 8k (8192).
If you need the DB_BLOCK_SIZE to be different then the default
of 8k, you will have to use the 'New Database' template instead.
Explanation
-----------
The DBCA offers 4 Database Templates: 'Data Warehouse', 'Transaction
Processing', 'General Purpose', and 'New Database'.
Except for 'New Database', they all come with a set of pre-created
database files, commonly referred to as seed or starter datafiles.
These files were created with a DB_BLOCK_SIZE of 8k (8192). Once
created, the block size cannot be changed for these files.
The 'New Database' template does not include datafiles and it will
create the database from scratch.
References
----------
Oracle9i Administrator's Guide, Chapter 2 "Creating an Oracle
Database", "Setting the Buffer Cache Initialization Parameters"
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP