ORA-1034 
Author Message
 ORA-1034

Gentlemen:

I am triying to build a second instance in a Win NT 4.0 Box.

There is 750Mgbs of Ram memory in that box

Existing Instance Y2KD hs an SGA of 475 Mgbts.
There is not any other programs using RAM memory

I have created the OracleServiceY2KP ===> Started      Automatic
and the                   OracleStartY2KP     ===>
Automatic

I have set ORACLE_SID=Y2KP

connect internal

Create database y2kp

*** Error *** ORA-1034: ORACLE not available.

My inity2kp.ora specifies:

db_block_buffers = 5000
shared_pool_size =  1500000
db_block_size = 8192

for about an SGA size of much less than 100 Mgbts.

Any help/comments will be greatly appreciated



Sun, 04 Feb 2001 03:00:00 GMT
 ORA-1034

do a "STARTUP NOMOUNT" first.
Quote:

> Gentlemen:

> I am triying to build a second instance in a Win NT 4.0 Box.

> There is 750Mgbs of Ram memory in that box

> Existing Instance Y2KD hs an SGA of 475 Mgbts.
> There is not any other programs using RAM memory

> I have created the OracleServiceY2KP ===> Started      Automatic
> and the                   OracleStartY2KP     ===>
> Automatic

> I have set ORACLE_SID=Y2KP

> connect internal

> Create database y2kp

> *** Error *** ORA-1034: ORACLE not available.

> My inity2kp.ora specifies:

> db_block_buffers = 5000
> shared_pool_size =  1500000
> db_block_size = 8192

> for about an SGA size of much less than 100 Mgbts.

> Any help/comments will be greatly appreciated



Sun, 04 Feb 2001 03:00:00 GMT
 ORA-1034

Quote:

> Gentlemen:

> I am triying to build a second instance in a Win NT 4.0 Box.

> There is 750Mgbs of Ram memory in that box

> Existing Instance Y2KD hs an SGA of 475 Mgbts.
> There is not any other programs using RAM memory

> I have created the OracleServiceY2KP ===> Started      Automatic
> and the                   OracleStartY2KP     ===>
> Automatic

> I have set ORACLE_SID=Y2KP

> connect internal

> Create database y2kp

> *** Error *** ORA-1034: ORACLE not available.

> My inity2kp.ora specifies:

> db_block_buffers = 5000
> shared_pool_size =  1500000
> db_block_size = 8192

> for about an SGA size of much less than 100 Mgbts.

> Any help/comments will be greatly appreciated

  In the sequence of commands you used I didn't notice the command::
startup nomount pfile="path to init file"\inity2kp.ora
This would cause the error message you describe.

Hope this helps.

Rick



Tue, 06 Feb 2001 03:00:00 GMT
 ORA-1034

Quote:

> Gentlemen:

> I am triying to build a second instance in a Win NT 4.0 Box.

> There is 750Mgbs of Ram memory in that box

> Existing Instance Y2KD hs an SGA of 475 Mgbts.
> There is not any other programs using RAM memory

> I have created the OracleServiceY2KP ===> Started      Automatic
> and the                   OracleStartY2KP     ===>
> Automatic

> I have set ORACLE_SID=Y2KP

> connect internal

> Create database y2kp

> *** Error *** ORA-1034: ORACLE not available.

> My inity2kp.ora specifies:

> db_block_buffers = 5000
> shared_pool_size =  1500000
> db_block_size = 8192

> for about an SGA size of much less than 100 Mgbts.

> Any help/comments will be greatly appreciated

  In the sequence of commands you used I didn't notice the command::
startup nomount pfile="path to init file"\inity2kp.ora
This would cause the error message you describe.

Hope this helps.

Rick



Tue, 06 Feb 2001 03:00:00 GMT
 ORA-1034

Quote:

> Gentlemen:

> I am triying to build a second instance in a Win NT 4.0 Box.

> There is 750Mgbs of Ram memory in that box

> Existing Instance Y2KD hs an SGA of 475 Mgbts.
> There is not any other programs using RAM memory

> I have created the OracleServiceY2KP ===> Started      Automatic
> and the                   OracleStartY2KP     ===>
> Automatic

> I have set ORACLE_SID=Y2KP

> connect internal

> Create database y2kp

> *** Error *** ORA-1034: ORACLE not available.

> My inity2kp.ora specifies:

> db_block_buffers = 5000
> shared_pool_size =  1500000
> db_block_size = 8192

> for about an SGA size of much less than 100 Mgbts.

> Any help/comments will be greatly appreciated

  In the sequence of commands you used I didn't notice the command::
startup nomount pfile="path to init file"\inity2kp.ora
This would cause the error message you describe.

Hope this helps.

Rick



Tue, 06 Feb 2001 03:00:00 GMT
 ORA-1034

Quote:

> Gentlemen:

> I am triying to build a second instance in a Win NT 4.0 Box.

> There is 750Mgbs of Ram memory in that box

> Existing Instance Y2KD hs an SGA of 475 Mgbts.
> There is not any other programs using RAM memory

> I have created the OracleServiceY2KP ===> Started      Automatic
> and the                   OracleStartY2KP     ===>
> Automatic

> I have set ORACLE_SID=Y2KP

> connect internal

> Create database y2kp

> *** Error *** ORA-1034: ORACLE not available.

> My inity2kp.ora specifies:

> db_block_buffers = 5000
> shared_pool_size =  1500000
> db_block_size = 8192

> for about an SGA size of much less than 100 Mgbts.

> Any help/comments will be greatly appreciated

  In the sequence of commands you used I didn't notice the command::
startup nomount pfile="path to init file"\inity2kp.ora
This would cause the error message you describe.

Hope this helps.

Rick



Tue, 06 Feb 2001 03:00:00 GMT
 ORA-1034

Quote:

> do a "STARTUP NOMOUNT" first.


> > Gentlemen:

> > I am triying to build a second instance in a Win NT 4.0 Box.

> > There is 750Mgbs of Ram memory in that box

> > Existing Instance Y2KD hs an SGA of 475 Mgbts.
> > There is not any other programs using RAM memory

> > I have created the OracleServiceY2KP ===> Started      Automatic
> > and the                   OracleStartY2KP     ===>
> > Automatic

> > I have set ORACLE_SID=Y2KP

> > connect internal

> > Create database y2kp

> > *** Error *** ORA-1034: ORACLE not available.

> > My inity2kp.ora specifies:

> > db_block_buffers = 5000
> > shared_pool_size =  1500000
> > db_block_size = 8192

> > for about an SGA size of much less than 100 Mgbts.

> > Any help/comments will be greatly appreciated

 I did not see in your list of commands the following:

startup nomount pfile='path to init file'\inity2kp.ora

This would account for the error you received.

Rick

--
Rick Huyck
Database Administrator
Novalis Technologies
Halifax, N.S., Canada
Tel: 902-423-1800 x238
Fax: 902-429-8988



Tue, 06 Feb 2001 03:00:00 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. NT Server Crash -> ORA-1034

2. dbassist fails with ORA-1034

3. ORA-1034 (Oracle not Available) It's killing me

4. Error: OWS-05566 due to ORA-1034

5. ORA-1034 when connecting from UNIX with account other than oracle

6. ORA-1034:ORACLE not available, LRM-00109

7. ORA-1034 for new SQL-Connections

8. ORA-1034 (not available) when importing from 8 using imp7

9. NT/Oracle Ent. Srv down (1034) following ActiveX VB app install

10. NT/Oracle 8.0 Ent Srv 1034 - incorrect OS variable pointing to the instance?

11. tnsnames.ora, sqlnet.ora, listner.ora


 
Powered by phpBB® Forum Software