| Database creation manually ... [message #90429] |
Thu, 14 August 2003 09:30  |
Rajendra Karanje
Messages: 3
Registered: July 2003
|
Junior Member |
|
|
I have created database manually and executed catalog.sql and catproc.sql. But when I try to open
database from it gives error
ora-01092 ( ORA-01092 ORACLE instance terminated. Disconnection forced )
At command prompt I used following commands:
****************************************************
G:>set oracle_sid=rajdb
G:>sqlplus/nolog
SQL*Plus: Release 9.0.1.0.1 - Production on Thu Aug 14 20:21:16 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
SQL> select name from v$database;
NAME
---------
RAJDB
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced.
*****************************************************
Due to this database is not accessible. What could be the reason.
Kindly suggest me the solution for my problem .....
|
|
|
|
| Re: Database creation manually ... [message #90436 is a reply to message #90429] |
Fri, 19 September 2003 22:36  |
LaDawn Meade
Messages: 1
Registered: September 2003
|
Junior Member |
|
|
Check your alert log and trace files; you will get a more reasonable error message there that may point you in the right direction.
I have encountered this before in Oracle 9i version 2 because the temporary tablespace was not allocated enough space in the create database script. If you use at least 4M, it seems to work. This may not be even remotely related to your question, it is just one reason for that error. You really need to check your alert log for a true error message before you can figure out the cause.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
