일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 |
Tags
- oracle
- oracle SCN
- sqlnet.allowed_logon_version_client=8
- ora-00439: feature not enabled: partitioning
- oracle hugepage
- oracle dba_profile password_life_time
- supplemental log 활성화
- Oracle Database
- ORA-00020
- ora-39083 ora-00439
- oracle pdb
- oracle install
- partition_options=merge
- sqlnet.allowed_logon_version_server=8
- SSMS
- 오라클
- mssql database 삭제
- oracle 테스트 데이터
- SQL Server
- oracle awr
- Oracle RAC
- oracle sqlnet.ora
- oracle tde
- oracleasm
- ora-28002: the password will expire within 7 days
- oracle system lock
- MSSQL
- oracle supplemental
- oracle account_status expired
- ora-28040: no matching authentication protocol
Archives
- Today
- Total
신문지한장
[Tech] single ASM 기동 및 정지 본문
싱글 DB 환경에서 grid 사용 시 아래 명령으로 grid가 중지되지 않음
[grid@test ~]$ crsctl stop crs
CRS-4013: This command is not supported in a single-node configuration.
CRS-4000: Command Stop failed, or completed with errors.
종료 방법
1. 모든 리소스 종료
[grid@test ~]$ crsctl stop res -all
CRS-2500: Cannot stop resource 'ora.diskmon' as it is not running
CRS-2500: Cannot stop resource 'ora.ons' as it is not running
CRS-2673: Attempting to stop 'ora.evmd' on 'test'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'test'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'test'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'test'
CRS-2675: Stop of 'ora.CRS.dg' on 'test' failed
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'test' succeeded
CRS-2677: Stop of 'ora.evmd' on 'test' succeeded
CRS-5017: The resource action "ora.DATA.dg stop" encountered the following error:
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA" precludes its dismount
. For details refer to "(:CLSN00108:)" in "/grid/diag/crs/test/crs/trace/ohasd_oraag ent_grid.trc".
CRS-2675: Stop of 'ora.DATA.dg' on 'test' failed
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'test'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'test'
CRS-2673: Attempting to stop 'ora.orclasm.db' on 'test'
CRS-2677: Stop of 'ora.DATA.dg' on 'test' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'test' succeeded
CRS-2677: Stop of 'ora.orclasm.db' on 'test' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'test'
CRS-2677: Stop of 'ora.asm' on 'test' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'test'
CRS-2677: Stop of 'ora.cssd' on 'test' succeeded
CRS-4000: Command Stop failed, or completed with errors.
2. ohasd.bin 프로세스 조회
[grid@test ~]$ ps -ef | grep d.bin
grid 12673 1 0 11:04 ? 00:01:47 /oracle/app/grid/bin/ohasd.bin reboot
grid 24540 23012 0 15:41 pts/1 00:00:00 grep --color=auto d.bin
3. ohasd.bin 프로세스 종료
[grid@test ~]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'test'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'test' has completed
CRS-4133: Oracle High Availability Services has been stopped.
4. ohasd.bin 프로세스 재조회
[grid@test ~]$ ps -ef | grep d.bin
grid 25618 23012 0 15:43 pts/1 00:00:00 grep --color=auto d.bin
기동 방법
1. ohasd.bin 먼저 기동
[grid@test ~]$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
2. 일반 프로세스 기동
[grid@test ~]$ crsctl start res -all
CRS-5702: Resource 'ora.evmd' is already running on 'test'
CRS-2501: Resource 'ora.ons' is disabled
CRS-2672: Attempting to start 'ora.diskmon' on 'test'
CRS-2672: Attempting to start 'ora.cssd' on 'test'
CRS-2676: Start of 'ora.diskmon' on 'test' succeeded
CRS-2676: Start of 'ora.cssd' on 'test' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'test'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'test' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'test'
CRS-2676: Start of 'ora.asm' on 'test' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'test'
CRS-2672: Attempting to start 'ora.CRS.dg' on 'test'
CRS-2676: Start of 'ora.CRS.dg' on 'test' succeeded
CRS-2676: Start of 'ora.DATA.dg' on 'test' succeeded
CRS-2672: Attempting to start 'ora.orclasm.db' on 'test'
CRS-2676: Start of 'ora.orclasm.db' on 'test' succeeded
CRS-4000: Command Start failed, or completed with errors.
3. 프로세스 확인
[grid@test ~]$ ps -ef | grep d.bin
grid 26078 1 6 15:44 ? 00:00:10 /oracle/app/grid/bin/ohasd.bin reboot
grid 26364 1 1 15:44 ? 00:00:01 /oracle/app/grid/bin/oraagent.bin
grid 26431 1 0 15:44 ? 00:00:00 /oracle/app/grid/bin/evmd.bin
grid 26599 26431 0 15:44 ? 00:00:00 /oracle/app/grid/bin/evmlogger.bin -o /oracle/app/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /oracle/app/grid/log/[HOSTNAME]/evmd/evmlogger.log
grid 27097 1 0 15:45 ? 00:00:00 /oracle/app/grid/bin/cssdagent
grid 27127 1 1 15:45 ? 00:00:01 /oracle/app/grid/bin/ocssd.bin
grid 27248 1 0 15:45 ? 00:00:00 /oracle/app/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid 28153 23012 0 15:46 pts/1 00:00:00 grep --color=auto d.bin