Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

10

主题
1#
发表于 2013-1-9 22:04:12 | 查看: 4397| 回复: 7
When a node that contains Oracle Clusterware is started, the Oracle Clusterware wrapper script is automatically started by the /etc/init.d/ohasd startup script. When the crsctl utility is used to disable Cluster Ready Services (CRS) from automatically starting, state information related to startup is placed in the SLCS_SRC control files, preventing automatic startup on machine reboot.

红色标记的SLCS_SRC control files,这个文件在哪里?
2#
发表于 2013-1-9 22:50:56
要问文档的内容 至少把文档出自哪个章节标注出来!!这是基本常识!!

回复 只看该作者 道具 举报

3#
发表于 2013-1-9 22:58:55
D60488GC10 Oracle 11g RAC and Grid Foundation Administration Release 2
ppt第三章,第5页,备注下面的内容,现在用公司电脑,恕我无法上传文档,公司信息安全非常严格。
这本书应该很容易找,itpub上有,
ppt页面上的内容是:

Controlling Oracle Clusterware

The crsctl utility can be used to control Oracle Clusterware.
To start or stop Oracle Clusterware on a specific node:
# crsctl start crs
# crsctl stop crs

To enable or disable Oracle Clusterware on a specific node:
# crsctl enable crs
# crsctl disable crs

备注页就写着上面那段话。

回复 只看该作者 道具 举报

4#
发表于 2013-1-10 10:19:22
FYI

[root@dm01db02 bin]# strace -o crs.log ./crsctl  disable crs      
CRS-4621: Oracle High Availability Services autostart is disabled.



[root@dm01db02 bin]# grep open crs.log|grep -v so|grep -v msb
open("/dev/tty", O_RDWR|O_NONBLOCK)     = 3
open("/usr/lib/locale/locale-archive", O_RDONLY) = 3
open("/proc/meminfo", O_RDONLY)         = 3
open("/usr/lib64/gconv/gconv-modules.cache", O_RDONLY) = 3
open("./crsctl", O_RDONLY)              = 3
open("/u01/app/11.2.0.3/grid/nls/data/lx1boot.nlb", O_RDONLY) = 3
open("/u01/app/11.2.0.3/grid/nls/data/lx00001.nlb", O_RDONLY) = 3
open("/u01/app/11.2.0.3/grid/nls/data/lx20001.nlb", O_RDONLY) = 3
open("/u01/app/11.2.0.3/grid/nls/data/lx10001.nlb", O_RDONLY) = 3
open("/u01/app/11.2.0.3/grid/nls/data/lx40011.nlb", O_RDONLY) = 3
open("/etc/nsswitch.conf", O_RDONLY)    = 3
open("/etc/passwd", O_RDONLY)           = 3
open("/etc/group", O_RDONLY)            = 3
open("/u01/app/11.2.0.3/grid/network/admin/sqlnet.ora", O_RDONLY) = 3
open("/u01/app/11.2.0.3/grid/network/admin/sqlnet.ora", O_RDONLY) = 3
open("/etc/oracle/olr.loc", O_RDONLY)   = 3
open("/etc/oracle/ocr.loc", O_RDONLY)   = 3
open("/etc/oracle/scls_scr/dm01db02/root/ohasdstr", O_RDONLY) = 3
open("/etc/oracle/scls_scr/dm01db02/root/ohasdstr", O_WRONLY|O_TRUNC) = 3



[root@dm01db02 scls_scr]# cd dm01db02/
[root@dm01db02 dm01db02]# ls
grid  root
[root@dm01db02 dm01db02]# ls -lR *
grid:
total 4
-rw-r--r-- 1 grid root 8 Sep  7 06:14 cssfatal

root:
total 12
-rw-r--r-- 1 root root     7 Sep  7 06:14 crsstart
-rw-r--r-- 1 root oinstall 8 Sep  7 22:10 ohasdrun
-rw-r--r-- 1 root oinstall 8 Jan  9 21:07 ohasdstr

[root@dm01db02 dm01db02]# cd root/

[root@dm01db02 root]# cat ohasdstr
disable


[root@dm01db02 root]# cat crsstart
enable


[root@dm01db02 root]# cat ohasdrun
restart



[root@dm01db02 root]# /u01/app/11.2.0.3/grid/bin/crsctl enable has
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@dm01db02 root]#
[root@dm01db02 root]# cat ohasdstr
enable

回复 只看该作者 道具 举报

5#
发表于 2013-1-10 10:19:32
more reference :




Cause

The ownership/permission of scls_scr and it's sub-directories/files were changed

Solution

Restore correct ownership and permission.

If you have a working Oracle Restart environment, compare the ownership and permission of files/directory of /etc/oracle or /var/opt/oracle; otherwise refer to the following as an example:

$ cd /var/opt; ls -lR oracle
oracle:
drwxrwx--- 2 grid oinstall 4096 Feb 12  2011 lastgasp
-rw-r----- 1 grid oinstall   66 Feb 12  2011 ocr.loc
-rw-r----- 1 root oinstall   70 Feb 12  2011 olr.loc
drwxrwx--- 5 root oinstall 4096 Feb 12  2011 oprocd
drwxr-x--- 3 root oinstall 4096 Feb 12  2011 scls_scr

oracle/lastgasp:
-rwxr--r-- 1 grid oinstall 4096 Feb 12  2011 ag100748_rac1.lgl

oracle/oprocd:
drwxrwx--- 2 root oinstall 4096 Feb 12  2011 check
drwxrwx--- 2 root oinstall 4096 Feb 12  2011 fatal
drwxrwx--- 2 root oinstall 4096 Feb 12  2011 stop

oracle/scls_scr:
drwxr-x--- 4 root oinstall 4096 Feb 12  2011 rac1

oracle/scls_scr/rac1:
drwxr-xr-x 2 grid root 4096 Feb 12  2011 ogrid
drwxr-xr-x 2 root root 4096 Feb 12  2011 root

oracle/scls_scr/rac1/grid:
-rw-r--r-- 1 grid root     8 Feb 12  2011 cssfatal
-rw-r----- 1 grid oinstall 8 Feb 12  2011 ohasdrun
-rw-r----- 1 grid oinstall 7 Feb 12  2011 ohasdstr

oracle/scls_scr/rac1/root:
-rw-r--r-- 1 root root 7 Feb 12  2011 crsstart

Note: The above example is for Oracle Restart, it may not apply to Grid Infrastructure Cluster

回复 只看该作者 道具 举报

6#
发表于 2013-1-10 10:25:37
SLCS_SRC 还是scls_scr ,问题拼错了

回复 只看该作者 道具 举报

7#
发表于 2013-1-10 10:49:11
了解了,多谢刘大。
并非我拼错,PPT上就错了。

回复 只看该作者 道具 举报

8#
发表于 2013-1-10 13:18:50
本帖最后由 Stone 于 2013-1-10 13:21 编辑

PPT上的应该是错啦,正确的应该是“SCLS_SRC”,而非“SLCS_SRC”,应该是把C和L一个字母给弄颠倒啦。
下面的内容可以参考下, 希望有用啦 :)

More reference:
http://deepakkachole.wikispaces.com/oracle-11g-rac-clusterware-administration

Control Files (SCLS_SRC) for Clusterware
Within Oracle 11g Clusterware, key control files exist since release 10g for Oracle RAC that are called SCLS_SRC files which control some important cluster functions. These control files enable and disable processes within the CSSD family of clusterware background processes such as allowing the Oracle 11g Clusterware processes Oprocd and Oslsvmon to be either enabled or disabled as well as stopping key daemons for the clusterware for crsd.bin and ocssd.bin and preventing the Oracle Clusterware from being started up when the machine reboots occur.
For the Linux operating system, these control files are located under the following directories:
/etc/oracle/scls_scr/raclinux1
/etc/oracle/scls_scr/raclinux1/root
The first directory structure under /etc/oracle/scls_scr contains the control file called cssfatal while the second directory structure located under the /etc/oracle/scls_scr/{nodename}/root contains the following control files:
· crsdboot
· crsstart
· cssrun
· noclsmon
· nooprocd


官方文档 Oracle Clusterware: Components installed. [ID 556976.1]
Control files (also know as SCLS_SRC files)

These files are used to control some aspects of Oracle Clusterware like:
- enable/disable processes from the CSSD family (Eg. oprocd, oslsvmon)
- stop the daemons (ocssd.bin, crsd.bin, etc).
- prevent Oracle Clusterware from being started when the machine boots.
- etc.

回复 只看该作者 道具 举报

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

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 14:10 , Processed in 0.046284 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569