- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Getting error creating database
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
тАО06-08-2010 01:11 PM
тАО06-08-2010 01:11 PM
Points will be provided
$ mkdir /opt/oracle/oradata
$ mkdir /opt/oracle/oradata/ver11
$ /opt/oracle/product/11.1.0.db/bin/sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jun 8 16:52:48 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> connect SYS/hp as SYSDBA
CREATE SPFILE='/opt/oracle/product/11.1.0.db/dbs/spfilever11.ora' FROM
PFILE='/tmp/oracle/inittemplate.ora';
SHUTDOWN
Connected to an idle instance.
SQL> 2
File created.
SQL> ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HPUX-ia64 Error: 2: No such file or directory
SQL> startup nomount
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2108344 bytes
Variable Size 171967560 bytes
Database Buffers 343932928 bytes
Redo Buffers 3928064 bytes
SQL> CREATE DATABASE ver11
2 USER SYS IDENTIFIED BY hp
3 USER SYSTEM IDENTIFIED BY hp
4 LOGFILE GROUP 1 ('/opt/oracle/oradata/ver11/redo01.log') SIZE 100M,
5 GROUP 2 ('/opt/oracle/oradata/ver11/redo02.log') SIZE 100M,
6 GROUP 3 ('/opt/oracle/oradata/ver11/redo03.log') SIZE 100M
7 MAXLOGFILES 5
8 MAXLOGMEMBERS 5
9 MAXLOGHISTORY 1
10 MAXDATAFILES 100
11 MAXINSTANCES 1
12 CHARACTER SET US7ASCII
13 NATIONAL CHARACTER SET AL16UTF16
14 DATAFILE '/opt/oracle/oradata/ver11/system01.dbf' SIZE 325M REUSE
15 EXTENT MANAGEMENT LOCAL
16 SYSAUX DATAFILE '/opt/oracle/oradata/ver11/sysaux01.dbf' SIZE 325M REUSE
17 DEFAULT TABLESPACE tbs_1
18 DEFAULT TEMPORARY TABLESPACE tempts1
19 TEMPFILE '/opt/oracle/oradata/ver11/temp01.dbf'
20 SIZE 20M REUSE
21 UNDO TABLESPACE undotbs
22 DATAFILE '/opt/oracle/oradata/ver11/undotbs01.dbf'
23 SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE DATABASE ver11
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 4706
Session ID: 1200 Serial number: 5
As you can see oracle dies..
Any help will be appreciated.
Just trying to create a simple instance from a script
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-08-2010 01:15 PM
тАО06-08-2010 01:15 PM
Re: Getting error creating database
with the DCOE OE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-08-2010 02:45 PM
тАО06-08-2010 02:45 PM
Re: Getting error creating database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-08-2010 03:29 PM
тАО06-08-2010 03:29 PM
Re: Getting error creating database
Just trying leaving the "LOGGROUP N (xxxx)"
directives out and re-running.
Reason: I believe I tried this years ago (groups of one), and got the same result, but in an older version of the database (9i).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-08-2010 11:16 PM
тАО06-08-2010 11:16 PM
Re: Getting error creating database
SQL> show parameter dump
Cheers,
Robert.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2010 02:19 AM
тАО06-09-2010 02:19 AM
Re: Getting error creating database
just a simple question. Have you checked your oracle environment variables (ORACLE_HOME, ORACLE_SID, ...).
Any dump file provided ?
Have you tried to create the database with dbca ?
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2010 02:54 AM
тАО06-09-2010 02:54 AM
Re: Getting error creating database
The reason should available in the alert log.
Also ..
Check the syntax in line 17 ..it appear to me like you are missing datafile over there.
Aneesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2010 06:53 AM
тАО06-09-2010 06:53 AM
Re: Getting error creating database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2010 09:30 AM
тАО06-09-2010 09:30 AM
Solutioncheck your init.ora for
parameter UNDO_TABLESPACE.
If it does not match exactly to
21 UNDO TABLESPACE undotbs
CREATE DATABASE will fail.
Assuming possible
undotbs vs. undotbs1
missmatch.
Second point:
17 DEFAULT TABLESPACE tbs_1
without tablespace tbs_1 beeing created...???
Delete the line and do
alter database ...
after creating the tablespace later
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2010 10:53 AM
тАО06-09-2010 10:53 AM
Re: Getting error creating database
The inonsistency between the temp tablespace in the init file was the problem.
Now I cannot seem to start the database normaly without getting a error. WHen looking at the alert file it said to use the upgrade option. so I did and it worked.
I always have to open up the database with
startup nomount
alter database open upgrade
any way to startup the database normally without getting a error.
Thanks for any assistance. Unfortunately I am not a card carrying DBA. This is for some testing we are doing on systems.