Re: Instance fails to start

2002-04-10 Thread Big Planet

try giving pfile = 

Bp
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 8:48 AM


> Hi All!
> 
> I have encounterd an interesting problem after attempting to make a
> change in my parameter file.  I made a minor change in the date format,
> and upon shutting down (normal) and starting up, an error in the format
> was reported.  I changed the format back to it's original form so that
> there was no diff between the original pfile and the current one, and
> attempted to restart, and I receive the following error:
> 
> SQL> startup
> ORA-24323: value not allowed
> ORA-03113: end-of-file on communication channel
> 
> There is nothing interesting in the alert log, and I see the same error
> with a startup nomount.
> 
> Any ideas as to what is going on?
> 
> Thanks in advance!!
> 
> Bill Tantzen
> University of Minnesota Libraries
> [EMAIL PROTECTED]
> 612-626-9949 (office)  612-250-6125 (cell)
> 
> I guess the man's a genius, but what
> a dirty mind he has, hasn't he? -- Nora Joyce
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bill Tantzen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Big Planet
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Instance fails to start

2002-04-10 Thread Bill Tantzen

FYI, I discovered the problem here...  I reduced the number of processes
in my init file by half, and I was able to start my instance.
Apparently there was enough resources to start both instances at boot
time, but not after the system has been running for awhile -- we have a
few other services running on this particular server.

I will have the sys admin take a look at some of the system paramters...

Thanks for all the suggestions!

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce


-Original Message-
Tantzen
Sent: Wednesday, April 10, 2002 10:48 AM
To: Multiple recipients of list ORACLE-L


Hi All!

I have encounterd an interesting problem after attempting to make a
change in my parameter file.  I made a minor change in the date format,
and upon shutting down (normal) and starting up, an error in the format
was reported.  I changed the format back to it's original form so that
there was no diff between the original pfile and the current one, and
attempted to restart, and I receive the following error:

SQL> startup
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

There is nothing interesting in the alert log, and I see the same error
with a startup nomount.

Any ideas as to what is going on?

Thanks in advance!!

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Instance fails to start

2002-04-10 Thread Bill Tantzen

The version is 8.1.7, and the original (and current) date format is
nls_date_format = "-MM-DD HH24:MI:SS"  The init file is exactly as
it was pre-edit!

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce


-Original Message-
Lee - lerobe
Sent: Wednesday, April 10, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L


What is the parameter, what was it set to originally pre-change and what
did
you change it to ?

Also, what version of Oracle are you on ?

Lee

-Original Message-
Sent: 10 April 2002 16:48
To: Multiple recipients of list ORACLE-L


Hi All!

I have encounterd an interesting problem after attempting to make a
change in my parameter file.  I made a minor change in the date format,
and upon shutting down (normal) and starting up, an error in the format
was reported.  I changed the format back to it's original form so that
there was no diff between the original pfile and the current one, and
attempted to restart, and I receive the following error:

SQL> startup
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

There is nothing interesting in the alert log, and I see the same error
with a startup nomount.

Any ideas as to what is going on?

Thanks in advance!!

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Instance fails to start

2002-04-10 Thread SRAJENDRAN

Could you please let me know, what is the significance of NTTACH=0 and why
only this one needs to be removed.

Srini

-Original Message-
Sent: Wednesday, April 10, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L


Bill,

Check whether u have any hung shared memory segments by issuing the 
command :

$ ipcs -mobs

Look for an oracle:dba user having NTTACH = 0. If it exists, remove it
using the command :

$ ipcrm -m  

Attempt to restart.

Regards,
Samir

Samir Sarkar
Oracle DBA 
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 10 April 2002 16:48
To: Multiple recipients of list ORACLE-L


Hi All!

I have encounterd an interesting problem after attempting to make a
change in my parameter file.  I made a minor change in the date format,
and upon shutting down (normal) and starting up, an error in the format
was reported.  I changed the format back to it's original form so that
there was no diff between the original pfile and the current one, and
attempted to restart, and I receive the following error:

SQL> startup
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

There is nothing interesting in the alert log, and I see the same error
with a startup nomount.

Any ideas as to what is going on?

Thanks in advance!!

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.
___

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Instance fails to start

2002-04-10 Thread Bill Tantzen

Thanks, this is what I get from ipc status:

IPC status from  as of Wed Apr 10 11:34:18 CDT 2002
T ID  KEYMODEOWNERGROUP NATTCH
SEGSZ
Shared Memory:
m  0   0xf002b74  --rw-rw-rw-  erl  erl  5
131072
m  1   0x10002b74 --rw-rw-rw-  erl  erl  5
290872
m  2   0x11002b74 --rw-rw-rw-  erl  erl  5
131128
m  4   0x876e8460 --rw-rw   oracle  dba  6
84172800
T ID  KEYMODEOWNERGROUP NSEMS
Semaphores:
s 458752   0x619d3e80 --ra-ra   oracle  dba   204
s 196609   0x83713dd0 --ra-ra   oracle  dba   204

(there is another instance running)

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce


-Original Message-
Samir
Sent: Wednesday, April 10, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


Bill,

Check whether u have any hung shared memory segments by issuing the 
command :

$ ipcs -mobs

Look for an oracle:dba user having NTTACH = 0. If it exists, remove it
using the command :

$ ipcrm -m  

Attempt to restart.

Regards,
Samir

Samir Sarkar
Oracle DBA 
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 10 April 2002 16:48
To: Multiple recipients of list ORACLE-L


Hi All!

I have encounterd an interesting problem after attempting to make a
change in my parameter file.  I made a minor change in the date format,
and upon shutting down (normal) and starting up, an error in the format
was reported.  I changed the format back to it's original form so that
there was no diff between the original pfile and the current one, and
attempted to restart, and I receive the following error:

SQL> startup
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

There is nothing interesting in the alert log, and I see the same error
with a startup nomount.

Any ideas as to what is going on?

Thanks in advance!!

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or

copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.

___

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spellin

RE: Instance fails to start

2002-04-10 Thread Bill Tantzen

No luck with that.  However, after editting the file to begin with, I
reverted back to the original copy...

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce


-Original Message-
Gramolini
Sent: Wednesday, April 10, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L


Comment out the date format in the init file and try it.  Ruth
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 11:48 AM


> Hi All!
> 
> I have encounterd an interesting problem after attempting to make a
> change in my parameter file.  I made a minor change in the date
format,
> and upon shutting down (normal) and starting up, an error in the
format
> was reported.  I changed the format back to it's original form so that
> there was no diff between the original pfile and the current one, and
> attempted to restart, and I receive the following error:
> 
> SQL> startup
> ORA-24323: value not allowed
> ORA-03113: end-of-file on communication channel
> 
> There is nothing interesting in the alert log, and I see the same
error
> with a startup nomount.
> 
> Any ideas as to what is going on?
> 
> Thanks in advance!!
> 
> Bill Tantzen 
> University of Minnesota Libraries
> [EMAIL PROTECTED]
> 612-626-9949 (office)  612-250-6125 (cell)
> 
> I guess the man's a genius, but what
> a dirty mind he has, hasn't he? -- Nora Joyce
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bill Tantzen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Instance fails to start

2002-04-10 Thread SARKAR, Samir

Bill,

Check whether u have any hung shared memory segments by issuing the 
command :

$ ipcs -mobs

Look for an oracle:dba user having NTTACH = 0. If it exists, remove it
using the command :

$ ipcrm -m  

Attempt to restart.

Regards,
Samir

Samir Sarkar
Oracle DBA 
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 10 April 2002 16:48
To: Multiple recipients of list ORACLE-L


Hi All!

I have encounterd an interesting problem after attempting to make a
change in my parameter file.  I made a minor change in the date format,
and upon shutting down (normal) and starting up, an error in the format
was reported.  I changed the format back to it's original form so that
there was no diff between the original pfile and the current one, and
attempted to restart, and I receive the following error:

SQL> startup
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

There is nothing interesting in the alert log, and I see the same error
with a startup nomount.

Any ideas as to what is going on?

Thanks in advance!!

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Instance fails to start

2002-04-10 Thread Robertson Lee - lerobe

What is the parameter, what was it set to originally pre-change and what did
you change it to ?

Also, what version of Oracle are you on ?

Lee

-Original Message-
Sent: 10 April 2002 16:48
To: Multiple recipients of list ORACLE-L


Hi All!

I have encounterd an interesting problem after attempting to make a
change in my parameter file.  I made a minor change in the date format,
and upon shutting down (normal) and starting up, an error in the format
was reported.  I changed the format back to it's original form so that
there was no diff between the original pfile and the current one, and
attempted to restart, and I receive the following error:

SQL> startup
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

There is nothing interesting in the alert log, and I see the same error
with a startup nomount.

Any ideas as to what is going on?

Thanks in advance!!

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Tantzen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Instance fails to start

2002-04-10 Thread Ruth Gramolini

Comment out the date format in the init file and try it.  Ruth
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 11:48 AM


> Hi All!
> 
> I have encounterd an interesting problem after attempting to make a
> change in my parameter file.  I made a minor change in the date format,
> and upon shutting down (normal) and starting up, an error in the format
> was reported.  I changed the format back to it's original form so that
> there was no diff between the original pfile and the current one, and
> attempted to restart, and I receive the following error:
> 
> SQL> startup
> ORA-24323: value not allowed
> ORA-03113: end-of-file on communication channel
> 
> There is nothing interesting in the alert log, and I see the same error
> with a startup nomount.
> 
> Any ideas as to what is going on?
> 
> Thanks in advance!!
> 
> Bill Tantzen 
> University of Minnesota Libraries
> [EMAIL PROTECTED]
> 612-626-9949 (office)  612-250-6125 (cell)
> 
> I guess the man's a genius, but what
> a dirty mind he has, hasn't he? -- Nora Joyce
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bill Tantzen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).