12
返回列表 发新帖
楼主: vision

Solaris 8上安装817出现ora-01034

[复制链接]
论坛徽章:
126
咸鸭蛋
日期:2011-08-22 23:47:37优秀写手
日期:2013-12-18 09:29:152014年新春福章
日期:2014-02-18 16:41:11马上有车
日期:2014-02-18 16:41:11马上有车
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有对象
日期:2014-02-19 11:55:14马上加薪
日期:2014-02-19 11:55:142015年新春福章
日期:2015-03-04 14:19:11
11#
发表于 2002-4-5 00:58 | 只看该作者
1.  请你将你的 oracle user porfile 内容贴出来
2.  如果你能回忆起来的话,贴出你的安装过程
3.  你的server 上面现在的磁盘分区情况,那个区你建立raw device?

如果是一个新安装的server,我觉得你现在花费时间找问题,不如把已经安装好的oracle 全部deinstall,把server 清理干净,重新安装一次。我会再贴一份安装概要出来。

使用道具 举报

回复
论坛徽章:
126
咸鸭蛋
日期:2011-08-22 23:47:37优秀写手
日期:2013-12-18 09:29:152014年新春福章
日期:2014-02-18 16:41:11马上有车
日期:2014-02-18 16:41:11马上有车
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有对象
日期:2014-02-19 11:55:14马上加薪
日期:2014-02-19 11:55:142015年新春福章
日期:2015-03-04 14:19:11
12#
发表于 2002-4-5 01:03 | 只看该作者
Doc ID:  Note:108306.1
Subject:  SOLARIS: Quick Start Guide - 8.1.X RDBMS Installation
Type:  BULLETIN
Status:  PUBLISHED
Content Type:  TEXT/PLAIN
Creation Date:  11-MAY-2000
Last Revision Date:  14-MAR-2002


PURPOSE
=======

This document is designed to be a quick reference that can be used when
installing Oracle 8.1.x on the Sun Solaris platform.  It is NOT designed to
take the place of the installation guide.  Please refer to the Installation
Guide, IG, for additional information on any of the steps
listed below.


OVERVIEW
========

Quick and easy steps for installing Oracle 8.1.x on Sun Solaris.

Each step should be done in the order that it is listed.  These steps are the
bare minimum that is necessary for a typical install of the product.

Verification of Version Certification:
======================================

Steps required to verify the version of Oracle is certified with the version
of the Operating System.

1. Enter http://metalink.oracle.com into a web brower

2. Click button labeled "Product Lifecycle"

3. Click button labeled "Certification"

4. Click link "View Certifications by Product"

5. Select "Oracle Server" ... Click Submit

6. Select "Oracle Server - Enterprise Edition" ... Click Submit

7. Select "Sun SPARC Solaris" ... Click Submit

8. Select the version of Oracle ... Click Submit

9. Check the column "Status" for Certification Status

10. Click link "Yes" in the column "Addtl. Info." for PatchSet information.

我已经核对过,这部份没有已经发现的安装问题,你可以忽略。[/COLOR]

Pre-requisite Requirements for System Administrator:
====================================================

For assistance with system administration issues please contact your system
administrator or Operating System, O/S, vendor.

Steps required as the Root User (login as root to perform each of these items):


1. Configure System Resources:

      Ensure that the system has at least the following resources:

         · 400 MB in /tmp *
         · 256 MB of Physical Memory (RAM)
         · Three times the amount of Physical Memory for Swap space (unless the
           system exceeds 1 GB of Physical Memory, and in this case, two times
           the amount of Swap space is sufficient)

         * You may also redirect /tmp by setting the TEMP environment variable.
         This is only recommended in rare circumstances where /tmp cannot be
         expanded to meet free space requirements.

2. Create a Software Owner and Group:

      Create a Unix user and group that will own the Oracle software
      (oracle = user, dba = group)

         · Use the "useradd" Solaris script or vi the /etc/password file and
           add user manually.
         · Use the "groupadd" Solaris script or vi the /etc/group file and add
           group manually.
         · This user must be local to the machine.


3. Create a Software Mount Point and DataFile Mount Points:

      Create a mount point for the Oracle software installation (at least 1.2
      GB, typically /u01)

      Create a second, third and fourth mount point for the database files,
      control files, etc. to be created, (typically /u02, /u03, /u04).

         · The oracle user should own these mount points and all files
           below this directory.


4. Create a directory for the oratab file:

Create the directory: /var/opt/oracle and ensure that the oracle user has
write permissions in this directory.


5. Test the Permissions:

Ensure that the oracle user can write to the new mount points

        · cd to each of the new mount point directories as the oracle user and
          create a file or directory as a test.


6. Configure Kernel Resources:

Add the following kernel parameters to the /etc/system file (this is the bare
minimum recommendations required)

            set shmsys:shminfo_shmmax=4294967295

            set shmsys:shminfo_shmmin=1

            set shmsys:shminfo_shmseg=10

            set shmsys:shminfo_shmmni=100

            set semsys:seminfo_semmns=1000

            set semsys:seminfo_semmni=100

            set semsys:seminfo_semmsl=200


7. Reboot System:

      After modifications are made to the /etc/system file, you must reboot the
      system for the new kernel parameters to take affect.

8. Mount CD-ROM:

      Mount the Oracle 8.1.x CD-ROM.  Typically, the CD-ROM will automount when
      placing it into the Solaris CD-ROM drive.


INSTALLATION STEPS
==================

Steps required to be performed as the Oracle Unix user.

1. Set up the Environment Variables:

   Set the following environment variables in the .profile or .login file of
   the oracle account, (whichever file you use when logging in), before
   starting the Installer.

   The values in the examples are assuming that your software mount point is
   /u01 and you are installing 8.1.7.

            Parameter                                 Value

            ORACLE_HOME           /u01/app/oracle/product/8.1.7

            ORACLE_BASE           /u01/app/oracle

            LD_LIBRARY_PATH       /u01/app/oracle/product/8.1.7/lib:/usr/lib

            ORACLE_TERM           vt100

            PATH                  /01/app/oracle/product/8.1.7/bin:/usr/ccs/bin:
                                  /usr/openwin/bin:
                                   and whatever else you want to have set
                                   follows these three items in the PATH

            ORACLE_SID            Set this to what you will call your
                                  database instance.
                                  (Typically 4 characters in length)
   
            DISPLAY                  <ip-address>:0.0

            ENSURE THAT CLASS_PATH IS NOT SET IN THE ENVIORNMENT


2. Set the umask:
  
      Set the oracle user's umask to 022 in your .login or .profile file.


3. Verify the Environment:
  
     Log-off and log-on as the Oracle user to ensure all environment settings
     are present.

     Type env at the Unix prompt to view all the environment variables.

     Before attempting to run the Oracle Universal Installer, verify that
     you can successfully run the following command:

        /usr/openwin/bin/xclock


4.   Start the Installer and Install the Oracle Software:

     Change directories to the CD-ROM and start the Installer.

     cd /cdrom/cdrom0

        ./runInstaller will start the Oracle Universal Installer

        · Verify that the Destination listed for File Location is your
          ORACLE_HOME.

          NOTE: If this is the first installation of Oracle 8i on this machine,
                you will be prompted to run the script,
                /tmp/orainstRoot.sh, before proceeding.
                It creates a pointer file to the oraInventory directory
                location.

        · Select "Enterprise Edition" for the Install Category.

        · Select Typical to install the software, create a database and start
          the database (Other selections are available for minimal or custom
          installs).

        · The install will begin.

        · Follow instruction regarding running root.sh and other prompts.

        · When completed, the install will have created a default database,
          configured a Listener, and started both for you.

Note: If you are installing 8.1.7, depending on the products that are being
      installed, the installer may prompt you to "insert Oracle8i disk 2
      into your disk drive or supply an alternative location".
      You may run into the following problems:

         - You may get "Device busy" messages when attempting to unmount/eject
           the 1st cdrom of the product set, because on the session that started
           the installer the current working directory is the cdrom mount point.

           To overcome this problem:
            . Return to the session/window where the installer was launched.  
            . Press the Return key once or twice to get the unix prompt.
            . Change directory to a location other than the cdrom mount point,
              for example 'cd /tmp'.
            . You should now be able to 'umount' or 'eject' the 1st cd-rom.

         - After ejecting the first cdrom, mounting the second, and selecting 'OK'
           in the dialog box, the dialog box displays again as if the cdrom was
           not changed.
           This happens because when the cdrom  is automounted, it's mount point
           contains the volume label of the cdrom.  For example when cdrom #1
           is mounted, the mount point may be /cdrom/oracle8i#1.  When cdrom #2
           is mounted, the mount point may change to /cdrom/oracle8i#2. In this
           situation it will be necessary to change the cdrom "path" when
           prompted by the installer.   

           To workaround this problem:
            . Use the 'mount' command without any options to display currently
              mounted filesystems.  
            . Check the first column of the output of the mount command and
              locate the cdrom mount point
            . Use this information to correct the "path" specified in the dialog
              box.  
            . Select OK and the install will proceed.


When the installer completes, you should have a working database
running along with the listener.

    Should the installer fail, note the error given.  If it was during
    relinking, you can check $ORACLE_HOME/install/make.log for more
    detailed information.  Otherwise, check InstallActions.log in the
    oraInventory location which can be determined by viewing the
    /var/opt/oracle/oraInst.loc file.

使用道具 举报

回复
论坛徽章:
126
咸鸭蛋
日期:2011-08-22 23:47:37优秀写手
日期:2013-12-18 09:29:152014年新春福章
日期:2014-02-18 16:41:11马上有车
日期:2014-02-18 16:41:11马上有车
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有对象
日期:2014-02-19 11:55:14马上加薪
日期:2014-02-19 11:55:142015年新春福章
日期:2015-03-04 14:19:11
13#
发表于 2002-4-5 01:04 | 只看该作者
APPENDIX A
==========

Documentation is available from the following resources:

       · You can find the "Installation Guide" on:

            · MetaLink - http://metalink.oracle.com
           
                Click on 'Technical Libraries' > 'Data Server'
                > 'System Administration and Platforms: UNIX'
                > 'Documentation' > 'Platform Specific Guides'

            . The Oracle 8i Server cdrom.

                There are .pdf files, which can be viewed.
                There are html files in the part number directory
                which can be viewed using your browser.
                Depending on the version, you can find them at:
                  
                  · 8.1.5 CD-ROM - Under the directory: /doc/solaris.815
                  . 8.1.6 CD-ROM - Under the directory: /doc/unixdoc/solaris.816
                  . 8.1.7 CD-ROM # 1 - Under the directory: /doc/unixdoc/solaris.817

            . The Oracle Documentation Center - http://docs.oracle.com

                Click on 'Database' > 'Oracle8i'


        · You can find the "Release Notes" on:

            · MetaLink - http://metalink.oracle.com
           
                Click on 'Technical Libraries' > 'Data Server'  
                > 'System Administration and Platforms: UNIX'
                > 'Release Notes/ReadMe'

            . The Oracle 8i Server cdrom.
                There is a pdf and an html version of the Release Notes.
                Depending on the version, you can find them at:

                  . 8.1.6 CD-ROM - Under the directory: /doc
                  · 8.1.7 CD-ROM # 1 - Under the directory: /doc

            . The Oracle Documentation Center - http://docs.oracle.com

                Click on 'Database' > 'Oracle8i'
.

使用道具 举报

回复
论坛徽章:
18
授权会员
日期:2005-10-30 17:05:33马上有对象
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有车
日期:2014-02-19 11:55:142012新春纪念徽章
日期:2012-02-13 15:10:582012新春纪念徽章
日期:2012-02-13 15:10:582012新春纪念徽章
日期:2012-02-13 15:10:582012新春纪念徽章
日期:2012-02-13 15:10:582012新春纪念徽章
日期:2012-02-13 15:10:58
14#
发表于 2002-4-5 08:55 | 只看该作者
我的意见如下:

你的机器配置已经知道

但你的交换分区是否太小了 oracle建议是物理内存的3倍


而你的操作系统的内核参数如下:

set shmsys:shminfo_shmmax = 4294967296
set shmsys:shminfo_shmmin = 1
set shmsys:shminfo_shmseg = 10
set shmsys:shminfo_semmni = 100
set shmsys:shminfo_semnsl = 100
set shmsys:shminfo_semopm= 100
set shmsys:shminfo_semvmx= 32767

其中有疑问的是:
1、set shmsys:shminfo_shmmax = 4294967296  (0.5(physical memory present in machine)
2 、set shmsys:shminfo_semnsl = 100  而你在initsid.ora的进程数却是150

3、set shmsys:shminfo_semmes=?这个值是多少呢


请你将以上参数作适应的调整,然后再试试

使用道具 举报

回复
论坛徽章:
18
授权会员
日期:2005-10-30 17:05:33马上有对象
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有车
日期:2014-02-19 11:55:142012新春纪念徽章
日期:2012-02-13 15:10:582012新春纪念徽章
日期:2012-02-13 15:10:582012新春纪念徽章
日期:2012-02-13 15:10:582012新春纪念徽章
日期:2012-02-13 15:10:582012新春纪念徽章
日期:2012-02-13 15:10:58
15#
发表于 2002-4-5 09:26 | 只看该作者
SHMMAX 最大共享内存段尺寸(字节)
SHMMIN 最小共享内存段尺寸(字节)
SHMSEG 每进程最大共享内存段数量
SHMMNI 系统范围最大共享内存段数量  
SEMMNI 信号灯标识符的最小数量
SEMMNS 系统范围的最大信号灯数量
SEMMSL 每套信号灯最小信号灯数量
SEMMAP 信号灯映射里的记录数量  
SEMVMX 信号灯的最大值



这个参数值是多少呢  至少要大于你initsid.ora进程数
 SEMMNS 系统范围的最大信号灯数量

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 未成年人举报专区 
京ICP备16024965号-8  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表