Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle error during database creation --- ORA-01092: ORACLE instance terminated. Disconnection forced

Posted on 2004-10-17
3
Medium Priority
?
908 Views
Last Modified: 2008-01-16
Experts,

I am getting this ORA-01092 during database creation  ---- Oracle9i database on Solaris

I tried a bunch of things --- ranging from changing the init.ora parameters ,
tried creating without UNDO, temp tablespaces etc.
this getting this error.

(I created a similar database successfully on Redhat Linux9 with almost identical settings and it worked
But getting this error on Solaris)
---------------------------------------------
THis is the content of the alert log :

ORA-01501: CREATE DATABASE failed
ORA-01526: error in opening file '?/rdbms/admin/sql.bsq'
ORA-07391: sftopn: fopen error, unable to open text file.
Error 1526 happened during db open, shutting down database
USER: terminating instance due to error 1526
Instance terminated by USER, pid = 9056
ORA-1092 signalled during: CREATE DATABASE HANPROD NOARCHIVELOG
      control...
------------------------------------------------
0
Comment
Question by:vsuripeddi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 2000 total points
ID: 12337519
Maybe this bug       3558717 ?

Abstract: CREATE DATABASE FAILS BY ORA-1092 WHEN SPECIFIED "!" OR "-" IN PASSWORD.

*** 04/07/04 05:17 am ***

TAR:
----

.

PROBLEM:
--------

"CREATE DATABASE" causes ORA-1092 and fails

.

[ex.]

CREATE DATABASE toikeda

MAXINSTANCES 1

MAXLOGHISTORY 1

.....

==> ORA-1092 will occurs.

.

is a new function from R9.2.

.

* After finish "CREATE DATABASE" without error,

.

[ex.]

SQL> alter user sys identified by "abcde!";

User altered.

SQL> alter user system identified by "abcde!";

User altered.

SQL> conn sys/abcde! as sysdba

Connected.

SQL> conn system/abcde!

Connected.

.

DIAGNOSTIC ANALYSIS:
--------------------

Based on Alert.log,it seems that ORA-604 occurs in "sql.bsq" line 2130,and we think that this error is the cause.

.

/* Alert.log */

.

Sat Apr 3 17:38:07 2004

Errors in file

/home/ossjp/toikeda/oracle2/admin/toikeda/udump/toikeda_ora_22050.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00922: missing or invalid option

Sat Apr 3 17:38:07 2004

Errors in file

/home/ossjp/toikeda/oracle2/admin/toikeda/udump/toikeda_ora_22050.trc:

ORA-01501: CREATE DATABASE failed

ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 2130

ORA-00604: error occurred at recursive SQL level 1

ORA-00922: missing or invalid option

Error 1519 happened during db open, shutting down database

USER: terminating instance due to error 1519

Sat Apr 3 17:38:08 2004

Errors in file

/home/ossjp/toikeda/oracle2/admin/toikeda/bdump/toikeda_lgwr_22043.trc:

ORA-01519: error while processing file '' near line

Instance terminated by USER, pid = 22050

ORA-1092 signalled during: CREATE DATABASE toikeda

user sys identified by

us...

.

.

Line 2130 in sql.bsq is the following.

.

/* sql.bsq (line 2130) */

.

2130 /

.

.

A test result is the following.

.

[OK]

[without "!"]

user sys identified by "abcde"

user system identified by "abcde"

.

[with "_"]

user sys identified by "abcde_"

user system identified by "abcde_"

.

[NG] ORA-1092 occurs.

[with "!"]

user sys identified by "abcde!"

user system identified by "abcde!"

.

[with "-"]

user sys identified by "abcde-"

user system identified by "abcde-"

.

WORKAROUND:

-----------

And after finish "CREATE DATABASE" without error,

.

[ex.]

1. create database

.

CREATE DATABASE test

user sys identified by "abcde"

user system identified by "abcde"

MAXINSTANCES 1

.....

.

.

alter user sys identified by "abcde!";

alter user system identified by "abcde!";

.

RELATED BUGS:
-------------

None.

.

REPRODUCIBILITY:
----------------

Rep? Platform RDBMS Ver.
------- -------------------------- ----------------

Y(100%) 453 Sun SPARC Solaris 10.1.0.2.0

Y(100%) 453 Sun SPARC Solaris 9.2.0.5

Y(100%) 453 Sun SPARC Solaris 9.2.0.4

Y(100%) 59 HP-UX PA-RISC 9.2.0.3

Y(100%) 59 HP-UX PA-RISC 9.2.0.2

.

TEST CASE:
----------

.

STACK TRACE:
------------

None.

.

SUPPORTING INFORMATION:
-----------------------

We will put testcase on ess30 later.

.

24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------

None.

.

DIAL-IN INFORMATION:
--------------------

None.

.

IMPACT DATE:
------------

None.

.
...

Rediscovery Information:

If create database command fails with ORA-1092 and psssword needs to be double quoted, you're hitting this problem.

Workaround:

Release Notes:

]] double quoted
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question