Solaris9 sparc 64bit安装oracle9i

dancingpig

具体系统安装不做研究
ORACLE官方文档：A96167_01
搜索下OTN即可。
关于安装过程基本没碰到问题。
系统情况：
SunOS 5.9 Generic_118558-11 sun4u sparc SUNW,Sun-Fire-280R Solaris
1CPU，2G内存

在创建数据库时候发生的问题：
1.out of memory错误
简单描述：在建立数据库时不论怎么设置内存，典型10%以上总归提示该错误。
自定义模式中如果几个参数设置过大也会导致该错误。

oracle的解释：
Subject:         ORA-27102 when Creating Database using Oracle Database Configuration Assistant
          Doc ID:         Note:125118.1         Type:         PROBLEM
          Last Revision Date:         24-JUL-2002         Status:         PUBLISHED


Problem Description
-------------------

You are attempting to create a new database using Oracle Database Configuration
Assistant when your server has a very large unused memory.  You pick a typical
type of database creation and receive the following error:

   ORA-27102: out of memory

The database creation fails.


Solution Description
--------------------

Pick Custom installation and keep on picking default values if you wish to or
change them upon your requirements until you reach the page where you have to
set your initialization parameters of the newly created database.  Lower the
numbers of shared_pool_size and block_buffers to a reasonable and appropriate
number that can suit your needs as well as your hardware abilities and continue
with the creation.  The database will be created successfully. Here is a simple
formula to assist you in calculating the size of the SGA depending on the
values you will be assigning for your initialization parameters in init.ora:

( ( db_block_size * db_block_buffers ) + log_buffer + shared_pool_size +
large_pool_size + java_pool_size ) / .9


Explanation
-----------

The reason this problem is occuring is because when you have large memory
installed on the server and a large segment of this memory is unused, the
Oracle Database Configuration Assistant will pick a percentage (roughly 30%) of
your unused memory and swap spaces and calculate the SGA to use those 30% of
this unused space.  This calculated percentage may exceed your server hardware
capabilities and may even exceed your requirement on the newly created database.

Additional Search Words
-----------------------

DBCA

手工把百分比设置在8%左右或者把其他自定义模式中的参数设置几乎接近建议值改错误不被返回。

最后经过创建了5次+数据库发现，原因很可能是由于对solaris不熟悉造成设置参数格式错误，没有对系统生效
set shmsys:shminfo_shmmax=2147483648
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=512
set shmsys:shminfo_shmseg=600
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256
set semsys:seminfo_semmns=1024
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
这应该是正确的设置方法，
me原来设置的是
set shmmax=xxx
现在经过更正后，30%也不会报out of memory了


Subject:         SOLARIS: Startup Fails with ORA-27146: post/wait initialization failed
          Doc ID:         Note:135859.1         Type:         PROBLEM
          Last Revision Date:         25-APR-2002         Status:         PUBLISHED



Problem Description
-------------------

After a new installation of Oracle, you try to startup the database and
receive an error: ORA-27146: post/wait initialization failed.  The system
message file shows:
Feb  5 18:28:55 owhqrdw101 unix: sorry, variable 'shminfo_semmni' is not
defined in the 'shmsys'
Feb  5 18:28:55 owhqrdw101 unix: module
Feb  5 18:28:55 owhqrdw101 unix:
Feb  5 18:28:55 owhqrdw101 unix: sorry, variable 'shminfo_semmsl' is not
defined in the 'shmsys'
Feb  5 18:28:55 owhqrdw101 unix: module
Feb  5 18:28:55 owhqrdw101 unix:
Feb  5 18:28:55 owhqrdw101 unix: sorry, variable 'shminfo_semmns' is not
defined in the 'shmsys'
Feb  5 18:28:55 owhqrdw101 unix: module
Feb  5 18:28:55 owhqrdw101 unix:
Feb  5 18:28:55 owhqrdw101 unix: sorry, variable 'shminfo_semopm' is not
defined in the 'shmsys'
Feb  5 18:28:55 owhqrdw101 unix: module
Feb  5 18:28:55 owhqrdw101 unix:
Feb  5 18:28:55 owhqrdw101 unix: sorry, variable 'shminfo_semvmx' is not
defined in the 'shmsys'
Feb  5 18:28:55 owhqrdw101 unix: module
Feb  5 18:28:55 owhqrdw101 unix:



Solution Description
--------------------


Edit the /etc/system file to correct the typing errors.  

In this case the file contained:

set shmsys:shminfo_shmmax=2147483648
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=512
set shmsys:shminfo_shmseg=600
set shmsys:shminfo_semmni=100
set shmsys:shminfo_semmsl=1010
set shmsys:shminfo_semmns=2500
set shmsys:shminfo_semopm=100
set shmsys:shminfo_semvmx=32767

Change to (note the last 5 parameters are 'set semsys:seminfo'):

set shmsys:shminfo_shmmax=2147483648
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=512
set shmsys:shminfo_shmseg=600
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=1010
set semsys:seminfo_semmns=2500
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

  

Explanation
-----------

Any typo in the /etc/system file will generate an ORA-27146 on startup
of the Oracle database.  The system error message points to the
parameters in error identifying them as not present in shmsys, which
they are not.  They should be defined in semsys.




Additional Search Words
-----------------------

ORA-27146 post/wait owhqrdw101 shmsys semsys

花无影

最后经过创建了5次+数据库发现，原因很可能是由于对solaris不熟悉造成设置参数格式错误，没有对系统生效

创建5次才发现，呵呵。

dancingpig

没摸过solaris，认识的人没人很熟悉solaris