• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 961
  • Last Modified:

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

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
vsuripeddi
Asked:
vsuripeddi
1 Solution
 
Helena Markováprogrammer-analystCommented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now