Home » Developer & Programmer » Designer » Database creation manually ...
Database creation manually ... [message #90429] Thu, 14 August 2003 09:30 Go to next message
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


SQL*Plus: Release - 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;


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 Go to previous messageGo to next message
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.
Database creation manually . [message #90716 is a reply to message #90436] Sun, 05 September 2004 23:19 Go to previous message
syed mohd eijaz
Messages: 2
Registered: September 2004
Junior Member
I want each and Evry step of manully Oracle database9i creation in Windowxp OS.
Thanks for u Help ans support.
Previous Topic: ER - Diagram
Next Topic: Modular design
Goto Forum:

Current Time: Sat Jun 12 20:26:06 CDT 2021