精华内容
下载资源
问答
  • 首先查看asm进程ps aux|grep asmasm进程没起进行下面操作su - gridsrvctl start asmexit查看ora进程ps aux|grep oraora进程没起进行下面操作su - oraclesqlplus / as sysdba>startupexit查状态lsnrctl status ...

    首先查看asm进程
    ps aux|grep asm
    asm进程没起进行下面操作
    su - grid
    srvctl start asm
    exit
    查看ora进程
    ps aux|grep ora
    ora进程没起进行下面操作
    su - oracle
    sqlplus / as sysdba
    >startup
    exit
    查状态
    lsnrctl status

    转载于:https://www.cnblogs.com/Dev0ps/p/8848412.html

    展开全文
  • 启动ASM 实例报错

    2021-05-08 19:46:00
    在一个10G的环境下,启动 ASM INSTANCE 报错:$ export ORACLE_SID=+ASM$ sqlplus "/ as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 25 22:33:51 2009Copyright (c) 1982, 2005, Oracle....

    在一个10G的环境下,启动 ASM INSTANCE 报错:

    $ export ORACLE_SID=+ASM

    $ sqlplus "/ as sysdba"

    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 25 22:33:51 2009

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.

    Connected to an idle instance.

    SQL> startup

    ORA-29701: unable to connect to Cluster Manager

    SQL> select * from v$instance;

    select * from v$instance

    *

    ERROR at line 1:

    ORA-01034: ORACLE not available

    第一次遇到unable to connect to Cluster Manager 这样的错误,有点不知所措的。

    后来翻阅了文档,报错是因为没有启动CSS进程造成的。 原来是需要启动css 后台进程。

    下面是启动的步骤:

    1) 用root用户登录;

    2) 确认 $ORACLE_HOME/bin 在环境变量PATH中;

    3) 输入下面的命令:

    #  localconfig add

    如果使用localconfig add 有报错,那尝试使用:[B]localconfig reset[/B]

    # ./localconfig reset

    Successfully accumulated necessary OCR keys.

    Creating OCR keys for user 'root', privgrp 'system'..

    Operation successful.

    Configuration for local CSS has been initialized

    Adding to inittab

    Startup will be queued to init within 30 seconds.

    Checking the status of new Oracle init process...

    Expecting the CRS daemons to be up within 600 seconds.

    CSS is active on these nodes.

    h3cap61

    CSS is active on all nodes.

    Oracle CSS service is installed and running under init(1M)

    ./localconfig 会在inittab中加入一个项内容,让进程在服务器启动后会自动运行:

    h1:2:respawn:/etc/init.cssd run >/dev/null 2>&1 检查进程是否在运行,可以通过ps命令来检查:

    # ps -ef|grep css

    root 122976 102866   0 22:53:30  pts/0  0:00 grep css

    oracle 303132      1   0 22:44:43      -  0:00 /oracle/product/10g/bin/ocssd.bin

    或者通过oracle 用户的crsctl  命令来检查。

    $       crsctl check cssd

    Failure 1 contacting CSS daemon (这样的反馈为css进程没有运行)

    $ crsctl check cssd

    CSS appears healthy (css进程已经在运行)

    css进程已经在运行,这时可以起到ASM实例:

    $ ORACLE_SID=+ASM

    $ sqlplus "/ as  sysdba"

    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 25 22:58:10 2009

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.

    Connected to an idle instance.

    SQL> startup

    ASM instance started

    Total System Global Area  130023424 bytes

    Fixed Size                  2019136 bytes

    Variable Size             102838464 bytes

    ASM Cache                  25165824 bytes

    ASM diskgroups mounted

    ADMINISTRATOR MUNUAL关于CSS进程的说明:

    [Size=11]CSS requirement:

    The Cluster Synchronization Services (CSS) daemon is required to enable synchronization between ASM and its client database instances. The CSS daemon is normally started (and configured to start upon reboot) when you use Database Configuration Assistant (DBCA) to create your database. If you did not use DBCA to create the database, you must ensure that the CSS daemon is running before you start

    the ASM instance.

    [/Size]

    展开全文
  • 11gR2启动ASM实例时遭遇ORA-29701  早上启动asm 报错,马上google 发现这个好东东,保存下前辈的成功,呵呵 原文地址:http://tomszrp.itpub.net/post/11835/493005 [grid@vm11gr2] /home/grid...
     
    

    早上启动asm 报错,马上google 发现这个好东东,保存下前辈的成功,呵呵

    原文地址:http://tomszrp.itpub.net/post/11835/493005

    [grid@vm11gr2] /home/grid> sqlplus "/as sysasm"

        SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:16:21 2009

        Copyright (c) 1982, 2009, Oracle. All rights reserved.

        Connected to an idle instance.
        SQL> startup
        ORA-01078: failure in processing system parameters
        ORA-29701: unable to connect to Cluster Synchronization Service
        SQL> 
        无法连接到CSS服务上.到操作系统上检查一下看看

        [grid@vm11gr2] /home/grid> crsctl check css
        CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
        [grid@vm11gr2] /home/grid> 
        [grid@vm11gr2] /home/grid> ps -ef|grep cssd
        果然没有CSS的服务daemon进程,再看一下HAS(High Availability Service)的状态

        [grid@vm11gr2] /home/grid> crsctl check has
        CRS-4638: Oracle High Availability Services is online

        [grid@vm11gr2] /home/grid> ps -ef|grep d.bin
        grid 5886 1 0 10:06 ? 00:00:01 /u01/app/grid/product/11.2/grid/bin/ohasd.bin reboot
        [grid@vm11gr2] /home/grid> 
        发现HAS的服务确实启动了的,而ora.cssd和ora.diskmon这2个服务是依赖于HAS维护的.
        

        进一步查看各资源的状态
        [grid@vm11gr2] /home/grid> crs_stat -t
        Name                Type                 Target    State Host 
        --------------------------------------------------------------
        ora.FLASH_DATA.dg   ora.diskgroup.type   OFFLINE OFFLINE vm11gr2 
        ora.SYS_DATA.dg     ora.diskgroup.type   OFFLINE OFFLINE vm11gr2 
        ora.asm             ora.asm.type         OFFLINE OFFLINE vm11gr2 
        ora.cssd            ora.cssd.type        OFFLINE OFFLINE vm11gr2 
        ora.diskmon         ora.diskmon.type     OFFLINE OFFLINE vm11gr2 
        [grid@vm11gr2] /home/grid> 
        
        [grid@vm11gr2] /home/grid> crsctl status resource -t
        --------------------------------------------------------------------------------
        NAME               TARGET          STATE        SERVER     STATE_      DETAILS 
        --------------------------------------------------------------------------------
        Local Resources
        --------------------------------------------------------------------------------
        ora.FLASH_DATA.dg
                          OFFLINE          OFFLINE     vm11gr2 
        ora.SYS_DATA.dg   

                          OFFLINE          OFFLINE     vm11gr2 
        ora.asm           

                          OFFLINE          OFFLINE     vm11gr2 
        --------------------------------------------------------------------------------
        Cluster Resources
        --------------------------------------------------------------------------------
        ora.cssd         

                1         OFFLINE          OFFLINE 
        ora.diskmon      

                1         OFFLINE          OFFLINE 

        再看一下ora.cssd和ora.diskmon的属性
        [grid@vm11gr2] /home/grid> crs_stat -p ora.cssd
        NAME=ora.cssd
        TYPE=ora.cssd.type
        ACTION_SCRIPT=
        ACTIVE_PLACEMENT=0
        AUTO_START=never
        CHECK_INTERVAL=30
        DESCRIPTION="Resource type for CSSD"
        FAILOVER_DELAY=0
        FAILURE_INTERVAL=3
        FAILURE_THRESHOLD=5
        HOSTING_MEMBERS=
        PLACEMENT=balanced
        RESTART_ATTEMPTS=5
        SCRIPT_TIMEOUT=600
        START_TIMEOUT=600
        STOP_TIMEOUT=900
        UPTIME_THRESHOLD=1m

        [grid@vm11gr2] /home/grid> crs_stat -p ora.diskmon
        NAME=ora.diskmon
        TYPE=ora.diskmon.type
        ACTION_SCRIPT=
        ACTIVE_PLACEMENT=0
        AUTO_START=never
        CHECK_INTERVAL=20
        DESCRIPTION="Resource type for Diskmon"
        FAILOVER_DELAY=0
        FAILURE_INTERVAL=3
        FAILURE_THRESHOLD=5
        HOSTING_MEMBERS=
        PLACEMENT=balanced
        RESTART_ATTEMPTS=10
        SCRIPT_TIMEOUT=60
        START_TIMEOUT=60
        STOP_TIMEOUT=60
        UPTIME_THRESHOLD=5s
        [grid@vm11gr2] /home/grid> 
        到这里基本就找到了原因了,可以看到这两个资源的AUTO_START属性默认都设置为never,也就是说他们不会随着HAS服务的启动而自动启动的,

    尽管默认情况下HAS服务是开机自动启动的.好了,那我们就手动启动一下吧:
        [grid@vm11gr2] /home/grid> crsctl start resource ora.cssd
        CRS-2672: Attempting to start 'ora.cssd' on 'vm11gr2'
        CRS-2679: Attempting to clean 'ora.diskmon' on 'vm11gr2'
        CRS-2681: Clean of 'ora.diskmon' on 'vm11gr2' succeeded
        CRS-2672: Attempting to start 'ora.diskmon' on 'vm11gr2'
        CRS-2676: Start of 'ora.diskmon' on 'vm11gr2' succeeded
        CRS-2676: Start of 'ora.cssd' on 'vm11gr2' succeeded
        [grid@vm11gr2] /home/grid> 

        :ora.cssd和ora.diskmon这两个服务是有依赖关系的,启动哪个都会把两个都起来.

        [grid@vm11gr2] /home/grid> crs_stat -t
        Name                Type                 Target    State Host 
        --------------------------------------------------------------
        ora.FLASH_DATA.dg   ora.diskgroup.type   OFFLINE OFFLINE vm11gr2 
        ora.SYS_DATA.dg     ora.diskgroup.type   OFFLINE OFFLINE vm11gr2 
        ora.asm             ora.asm.type         OFFLINE OFFLINE vm11gr2 
        ora.cssd            ora.cssd.type        ONLINE  ONLINE  vm11gr2 
        ora.diskmon         ora.diskmon.type     ONLINE  ONLINE  vm11gr2 
        [grid@vm11gr2] /home/grid> 
        CSS服务起来了,重启动asm instance   

        [grid@vm11gr2] /home/grid> sqlplus "/as sysasm"

        SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:30:03 2009

        Copyright (c) 1982, 2009, Oracle. All rights reserved.

        Connected to an idle instance.

        SQL> startup
        ASM instance started

        Total System Global Area 284565504 bytes
        Fixed Size 1336036 bytes
        Variable Size 258063644 bytes
        ASM Cache 25165824 bytes
        ASM diskgroups mounted
        SQL> exit
        Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
        With the Automatic Storage Management option
        [grid@vm11gr2] /home/grid> crs_stat -t 
        Name                Type                 Target    State Host 
        --------------------------------------------------------------
        ora.FLASH_DATA.dg   ora.diskgroup.type   ONLINE  ONLINE  vm11gr2 
        ora.SYS_DATA.dg     ora.diskgroup.type   ONLINE  ONLINE  vm11gr2 
        ora.asm             ora.asm.type         ONLINE  ONLINE  vm11gr2 
        ora.cssd            ora.cssd.type        ONLINE  ONLINE  vm11gr2 
        ora.diskmon         ora.diskmon.type     ONLINE  ONLINE  vm11gr2 
        [grid@vm11gr2] /home/grid> 

        tips

          1)默认情况下HAS(High Availability Service)是自动启动的.通过如下命令可以取消和启用自动启动
            crsctl disable has
            crsctl enable has
          2)HAS手动启动和停止
            crsctl start has
            crsctl stop has
          3)查看HAS的状态
            crsctl check has
          4)如果想让ora.css和ora.diskmon服务随着HAS的启动而自动启动,那么你可以这两个服务的AUTO_START属性
            crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
            or 
            crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
          5)如果想取消ora.css和ora.diskmon的Auto start 
            crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
            crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"

    展开全文
  • 这几天在实验室里做rac+asm+Linux,在配置asm时,节点2的分区不能被mount,看来只有手动来mount了:[oracle@server2 ~]$ ps -ef | grep asmoracle 6339 1 0 10:06 ? 00:00:00 asm_pmon_+ASM2oracle 6341 1 0 10:06 ?...

    这几天在实验室里做rac+asm+Linux,在配置asm时,节点2的分区不能被mount,看来只有手动来mount了:

    [oracle@server2 ~]$ ps -ef | grep asm

    oracle    6339     1  0 10:06 ?        00:00:00 asm_pmon_+ASM2

    oracle    6341     1  0 10:06 ?        00:00:00 asm_diag_+ASM2

    oracle    6343     1  0 10:06 ?        00:00:00 asm_psp0_+ASM2

    oracle    6345     1  0 10:06 ?        00:00:01 asm_lmon_+ASM2

    oracle    6347     1  0 10:06 ?        00:00:00 asm_lmd0_+ASM2

    oracle    6349     1  0 10:06 ?        00:00:00 asm_lms0_+ASM2

    oracle    6359     1  0 10:06 ?        00:00:00 asm_mman_+ASM2

    oracle    6361     1  0 10:06 ?        00:00:00 asm_dbw0_+ASM2

    oracle    6363     1  0 10:06 ?        00:00:00 asm_lgwr_+ASM2

    oracle    6365     1  0 10:06 ?        00:00:00 asm_ckpt_+ASM2

    oracle    6367     1  0 10:06 ?        00:00:00 asm_smon_+ASM2

    oracle    6369     1  0 10:06 ?        00:00:00 asm_rbal_+ASM2

    oracle    6371     1  0 10:06 ?        00:00:00 asm_gmon_+ASM2

    oracle    6399     1  0 10:06 ?        00:00:00 asm_lck0_+ASM2

    oracle    6442     1  0 10:06 ?        00:00:00 /app/oracle/10g/bin/racgimon daemon ora.server2.ASM2.asm

    oracle    7097     1  0 12:36 ?        00:00:00 asm_pz99_+ASM2

    oracle    7144     1  0 12:36 ?        00:00:00 asm_pz98_+ASM2

    oracle   13954  8392  0 12:40 pts/2    00:00:00 grep asm

    [oracle@server2 ~]$ export ORACLE_SID=+ASM2

    [oracle@server2 ~]$ sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 8 12:41:18 2009

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.

    SQL> conn /as sysdba

    Connected.

    SQL> shutdown immediate

    ORA-15100: invalid or missing diskgroup name

    ASM instance shutdown

    SQL> startup

    ASM instance started

    Total System Global Area   92274688 bytes

    Fixed Size                  1217884 bytes

    Variable Size              65890980 bytes

    ASM Cache                  25165824 bytes

    ASM diskgroups mounted

    SQL> select count(*) from v$asm_disks;

    select count(*) from v$asm_disks

    *

    ERROR at line 1:

    ORA-01219: database not open: queries allowed on fixed tables/views only

    SQL> select count(*) from v$asm_group;

    select count(*) from v$asm_group

    *

    ERROR at line 1:

    ORA-01219: database not open: queries allowed on fixed tables/views only

    SQL> select count(*) from v$asm_diskgroup;

    COUNT(*)

    ----------

    1

    这样就ok了,这个问题解决;

    展开全文
  • 启动关闭注意顺序启动...CSS,HAS启动:一 启动ASM 之前应该确保css,has 服务已经启动检查CSS 服务是否启动:[grid@node1 ~]$ crsctl check css检查HAS 服务是否启动:[grid@node1~]$ crsctl check hasora.cssd和or...
  • Oracle集群管理-ASM实例启动过程详细

    千次阅读 2019-08-23 15:49:28
    1 从gpnp profile中读取ASM初始化参数文件,获取启动实例所需要的参数。 2 根据参数分配sga并启动后台进程。 3 从参数asm_diskstring指定的位置检索磁盘,挂载ASM磁盘组。 ...
  • ASM实例主要参数

    2021-05-04 04:30:08
    ASM instance 与 Database instance 的版本兼容性说明1. Oracle 11gR2 的ASM 支持11g和10g的数据库实例。...2. 如果要使用Oracle 11.2 的数据库实例,那么ASM 实例的版本必须是11.2的。即,ASM i...
  • ASM三 管理ASM实例

    千次阅读 2014-07-17 21:08:44
    1.不同版本ASM与数据库实例 11.2的ASM支持旧版本的数据库,如10G。在群集(Oracle Clusterware)中使用ASM时,群集的版本必须大于等于ASM的版本。  V$ASM_CLIENT 视图的...ASM实例也有一个参数文件spfile或pfil...
  • 关闭ASM实例 先登陆ASM sqlplus / as sysasm 查看版本和状态 select host_name,instance_name,version,status,archiver from v$instance; 关闭ASM实例,无法关闭,有连接 shutdown immediate; 查看连接到ASM实例...
  • ASM重启实例

    2018-06-18 23:17:26
    ASM 实例重启方案,个人随笔,希望对大家有帮助,一分也是爱。哈哈
  • Oracle ASM实例介绍

    2021-05-04 00:55:06
    ASM:Automatic Storage Management, 是Oracle主推的一种面向Oracle的存储解决方案,ASM也是ORACLE实例,它管理asm盘阵,可通过...ASM 实例需要CSS进程,如果是非RAC 环境,在启动ASM实例之前会报ORA-29701: un...
  • 主要为了验证11gR2 RAC中ASM实例通过gpnp profile获得spfile信息来启动ASM实例,同时验证了gpnp profile的修改等内容;结论与实验如下: 验证结论: 1. /u01/app/11.2.0/grid/gpnp/profiles/peer下的cat profile.xml...
  • 环境:单结点安装grid, database, database存储在asm上。 ...
  • 1、前提条件需要知道以下信息:1)、节点数量2)、ASM磁盘组包括的磁盘所在位置3)、实例有那几个磁盘组2、步骤及重建脚本1)成功的脚本:*.cluster_database_instances=2+ASM1.instance_name='+ASM1'+ASM1.instance_...
  • 适用于:Oracle Server - 企业版 - 版本:10.1.0.2 基于Intel的服务器LINUX症状当CRS启动时,您发现无法启动数据库实例,因为ASM实例尚未运行。- CRS日志文件显示:2004-06-01 13:41:51.294: [RTI:376877] Start...
  • ASM CRS 实例启动和关闭

    千次阅读 2014-09-09 13:06:04
    11gR2 + ASM 实例启动和关闭,需要采用如下命令:  crs_stop -all crs_start -all [Hywdatadg]/home/grid$>crs_stat -t -v Name Type R/RA F/FT Target State Host  ---------------
  • 环境:windows server 2003 SP2 ORACLE 11g 11.0.6内存大小:1200M在安装数据库时,创建ASM磁盘组,创建ASM实例,创建数据库实例都很正常。数据库安装完成后,登录数据库、登录OEM都很正常,并做了添加表空间、添加...
  • Oracle DB 管理ASM实例

    2018-11-04 01:04:03
    分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow也欢迎大家转载本篇...分享知识,造福人民,实现我们中华民族伟大复兴!   ... • 描述使用ASM
  • 一:ASM实例 后台进程: ASM实例中的后台进程和数据库实例大致相同,但是由于ASM实例需要完成对磁盘组合asm元数据的管理,所以存在一些特有的后台进程。ASM实例特有的后台进程如下。 1)GMON(ASM Disk Group ...
  • CRS-1016: Resources depending on 'ora.node2.ASM2.asm' are running CRS-0223: Resource 'ora.node2.ASM2.asm' has placement error. [oracle@node2 bin]$ ./crs_stop ora.node2.LISTENER_NODE2.lsnr ...
  • 大牛些的问题,你膜拜学习呀!搭建Oracle 11gR2单实例+ASM实例的生产与测试环境
  • 在11.2的ASM实例上,执行show parameter spfile:[grid@rac1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.1.0 Production on Sun MAY 11 15:56:12 2014Copyright (c) 1982, 2009, Oracle. All rights reserved....
  • 如何手工删除ASM实例

    2021-05-05 07:24:21
    2节点RACCRS-->...ASM实例到这里时,ASM实例创建好了,crs_stat -t也可以看到这ASM实例:[oracle@db1 ~]$ crs_stat -tName Type Target State Host-----------------------------------------------...
  • 20.4 创建、启动和停止ASM实例(1)就像RDBMS实例一样,一个ASM实例由一个实例参数文件控制,但是对能够包括的参数有严格的限制。许多参数会造成ASM实例启动时出现错误,因此保持参数文件尽可能小。 表20-1中列出了...
  • 1.先启动asm相关服务: crsctl start resource ora.cssd2.启动asm实例; sqlplus /nolog SQL> conn / as sysasm3.启动数据库: sqlplus /nolog SQL> conn / as sysdba.
  • 进入正题,万一碰到asm内存分配不合理,asm实例无法启动咋整: 比如:ORA-00823: Specified value of sga_target greater than sga_max_size 下面是最常见和最常用的ASM初始化参数配置: | +ASM1.asm_diskgroups=...

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 23,403
精华内容 9,361
关键字:

启动asm实例