Re: Create Database Failed

david0420_at_my-deja.com wrote in message <7jgnq3$q1r$1_at_nnrp1.deja.com>...
>I am running oracle server version 7.3.2.3.2 for Alpha OpenVMS and vms
>version 7.1.
>
>When I use oracleins to create a new database it gives a the following
>error:
>
>ORA-01501 CREATE DATABASE failed
>
>The alert log file contains the following message:
>
>** Memory was not reserved for the SGA. SGA size = 1966080 **
>** There might be performance advantages to allocating memory for the
>SGA in the
> VMS reserved memory registry. **
>
>How can I solve this problem? Any Ideas?
>
>Thanks.
>
>Dave
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Dave

The message you refer to is not the reason the database create is failing, it is
simply Oracle telling you that there is no memory under VMS specifically reserved for Oracle, and so the memory used by the SGA and the processes is subject to the same task swapping priority as other processes. Most DBAs want
to keep Oracle from being swapped out, even if it is at the bottom of the LRU
list, cause the performance hit it somewhat big :-)

To find out why your database create failed we will need some more information, but
the fact that this message is there at all suggests that the basic Oracle processes have been created. Try using checking the processes with....

$ @sys$manager:sp ora
00000C8E ORA_MYSID_PMON HIB 6 37 0 00:00:00.08 639 431
00000C8F ORA_MYSID_DBWR HIB 6 1085 0 00:00:00.20 693 454
00000C90 ORA_MYSID_LGWR HIB 6 2565 0 00:00:00.54 688 464
00000C91 ORA_MYSID_SMON HIB 5 169 0 00:00:08.18 966 446
00000C92 ORA_MYSID_RECO HIB 5 40 0 00:00:00.20 4222 229
00000C93 ORA_MYSID_SNP0 HIB 5 778 0 00:00:17.21 4328 745
00000C94 ORA_MYSID_SNP1 HIB 5 115 0 00:00:24.54 1696 714

If they look something like this, you have your instance up and running, so you
can use SVRMGR to connect to it and check the state of the instance by querying
v$database and wether or not you have any database files with v$datafiles.

If you can start SVRMGR, you can always create the database manually without the
use of ORACLEINS, which is way you have to do it if you want more than a 2Kb block size anyway.

HTH, Let me know if you need more.

Graham

--
Empowerment - delegating the responsibility but not the authority.

Opinions expressed do not necessarily reflect those of Abbott Laboratories . Received on Thu Jun 10 1999 - 12:15:47 CDT