Hi

I try manually create database in Oracle 10g on Windows XP prof.
And I get following error:

ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


Udump trace file is following:

Dump file e:\oracle\product\10.1.0\admin\test1\udump\orcl_or a_3400.trc
Sat Sep 23 09:35:01 2006
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Dodatek Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:534M/1023M, PG:3473M/4022M, VA:1765M/2047M
Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 3400, image: ORACLE.EXE (SHAD)


*** SERVICE NAMESYS$USERS) 2006-09-23 09:35:01.890
*** SESSION ID162.1) 2006-09-23 09:35:01.890
*** 2006-09-23 09:35:01.890
All processes have switched to database character set
*** 2006-09-23 09:35:20.078
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Assigned RBS 4 to pool 0
Undo Segment 4 Onlined
Assigned RBS 5 to pool 1
Undo Segment 5 Onlined
Assigned RBS 6 to pool 2
Undo Segment 6 Onlined
Assigned RBS 7 to pool 3
Undo Segment 7 Onlined
Assigned RBS 8 to pool 4
Undo Segment 8 Onlined
Assigned RBS 9 to pool 5
Undo Segment 9 Onlined
Assigned RBS 10 to pool 6
Undo Segment 10 Onlined
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Offending statement at line 6183
CREATE TABLESPACE TBS_1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file
'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 6183
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name

You did read the following segment of the trace file carefully?

ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Offending statement at line 6183
CREATE TABLESPACE TBS_1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file
'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 6183
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name

Do you see a filename?

Am I right in assuming you didn't do any investigation of your own,
and dumped the trace file to this forum right away?

FYI: This is a *volunteer* forum, NOT *Oracle Support*






On 23 Sep 2006 00:44:52 -0700, "radian7" <radian7@poczta.onet.pl>
wrote:

>Hi
>
>I try manually create database in Oracle 10g on Windows XP prof.
>And I get following error:
>
>ERROR at line 1:
>ORA-01092: ORACLE instance terminated. Disconnection forced
>
>
>Udump trace file is following:
>
>Dump file e:\oracle\product\10.1.0\admin\test1\udump\orcl_or a_3400.trc
>Sat Sep 23 09:35:01 2006
>ORACLE V10.1.0.2.0 - Production vsnsta=0
>vsnsql=13 vsnxtr=3
>Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
>With the Partitioning, OLAP and Data Mining options
>Windows XP Version V5.1 Dodatek Service Pack 2
>CPU : 1 - type 586
>Process Affinity: 0x00000000
>Memory (A/P) : PH:534M/1023M, PG:3473M/4022M, VA:1765M/2047M
>Instance name: orcl
>
>Redo thread mounted by this instance: 1
>
>Oracle process number: 12
>
>Windows thread id: 3400, image: ORACLE.EXE (SHAD)
>
>
>*** SERVICE NAMESYS$USERS) 2006-09-23 09:35:01.890
>*** SESSION ID162.1) 2006-09-23 09:35:01.890
>*** 2006-09-23 09:35:01.890
>All processes have switched to database character set
>*** 2006-09-23 09:35:20.078
>Created Undo Segment _SYSSMU1$
>Created Undo Segment _SYSSMU2$
>Created Undo Segment _SYSSMU3$
>Created Undo Segment _SYSSMU4$
>Created Undo Segment _SYSSMU5$
>Created Undo Segment _SYSSMU6$
>Created Undo Segment _SYSSMU7$
>Created Undo Segment _SYSSMU8$
>Created Undo Segment _SYSSMU9$
>Created Undo Segment _SYSSMU10$
>Undo Segment 1 Onlined
>Undo Segment 2 Onlined
>Undo Segment 3 Onlined
>Assigned RBS 4 to pool 0
>Undo Segment 4 Onlined
>Assigned RBS 5 to pool 1
>Undo Segment 5 Onlined
>Assigned RBS 6 to pool 2
>Undo Segment 6 Onlined
>Assigned RBS 7 to pool 3
>Undo Segment 7 Onlined
>Assigned RBS 8 to pool 4
>Undo Segment 8 Onlined
>Assigned RBS 9 to pool 5
>Undo Segment 9 Onlined
>Assigned RBS 10 to pool 6
>Undo Segment 10 Onlined
>ORA-00604: error occurred at recursive SQL level 1
>ORA-02236: invalid file name
>Offending statement at line 6183
>CREATE TABLESPACE TBS_1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL
>ORA-01501: CREATE DATABASE failed
>ORA-01519: error while processing file
>'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 6183
>ORA-00604: error occurred at recursive SQL level 1
>ORA-02236: invalid file name
--
Sybrand Bakker, Senior Oracle DBA

You have right.

But now I have new problem:

Dump file e:\oracle\product\10.1.0\admin\test1\udump\orcl_or a_3108.trc
Sat Sep 23 11:37:51 2006
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Dodatek Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:529M/1023M, PG:3440M/4022M, VA:1764M/2047M
Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 3108, image: ORACLE.EXE (SHAD)


*** SERVICE NAMESYS$USERS) 2006-09-23 11:37:51.765
*** SESSION ID162.1) 2006-09-23 11:37:51.765
*** 2006-09-23 11:37:51.765
All processes have switched to database character set
*** 2006-09-23 11:38:08.296
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Assigned RBS 4 to pool 0
Undo Segment 4 Onlined
Assigned RBS 5 to pool 1
Undo Segment 5 Onlined
Assigned RBS 6 to pool 2
Undo Segment 6 Onlined
Assigned RBS 7 to pool 3
Undo Segment 7 Onlined
Assigned RBS 8 to pool 4
Undo Segment 8 Onlined
Assigned RBS 9 to pool 5
Undo Segment 9 Onlined
Assigned RBS 10 to pool 6
Undo Segment 10 Onlined
ORA-01501: CREATE DATABASE failed
ORA-01991: invalid password file
'E:\oracle\product\10.1.0\Db_1\DATABASE\PWDorcl.OR A'

how can I set other password file ?

Hi

I solve this by change parameter remote_login_passwordfile from
EXCLUSIVE to SHARED...

On 23 Sep 2006 02:48:17 -0700, "radian7" <radian7@poczta.onet.pl>
wrote:

>Hi
>
>I solve this by change parameter remote_login_passwordfile from
>EXCLUSIVE to SHARED...

So Oracle won't use a password file anymore, and only SYS will have
SYSDBA privilege

You can recreate the password file by renaming the current one, and
using the dos orapwd utility

syntax orapwd file=<your file, you *have* to use the name from your
tracefile> password= entries=

--
Sybrand Bakker, Senior Oracle DBA