윈도우에서 클라이언트 설치 시 INS-30131 에러가 발생

 

[INS-30131] 설치 프로그램 검증 실행에 필요한 초기 설정을 실패했습니다.

 

 

원인 - 임시 위치에 액세스를 실패했습니다.

 

작업 - 현재 사용자에게 임시 위치에 액세스하는 데 필요한 권한이 있는지 확인하십시오.

 

추가 정보:

모든 노드에서 프레임워크 설정 검사를 실패했습니다.

실패한 노드 요약

kjh

 - "kjh" 노드에서 exectask 버전을 검색할 수 없습니다.

 

 

회피 방법

cmd> setup.exe -ignorePrereq -J"-Doracle.install.client.validate.clientSupportedOSCheck=false"

 

에러 없이 설치 완료 된다.

 

 

■ 참고

 

Workaround:

Execute the net share command to ensure that the administrative shares are enabled. If they are disabled, then enable them by following the instructions in the Microsoft Windows documentation. Alternatively, perform the client or server installation by specifying the following options:

-ignorePrereq

-J"-Doracle.install.client.validate.clientSupportedOSCheck=false"

-ignorePrereq -J"-Doracle.install.db.validate.supportedOSCheck=false"

http://docs.oracle.com/database/121/NTDBN/toc.htm#NTDBN213

 


'ETC > WINDOWS' 카테고리의 다른 글

파일내용 검색  (0) 2018.01.03

findstr /S "src=h" *.sql

sql 파일 중에 src=h 문자열이 들어간 파일 찾기

'ETC > WINDOWS' 카테고리의 다른 글

windows client 설치 시 에러  (0) 2018.01.03

grep -r "c_cnt" ./*

현재 디렉토리에서 c_cnt 라는 문자열이 있는 파일명을 찾는다.

'ETC > LINUX' 카테고리의 다른 글

cat 으로 파일 문자열 검색(line 까지 확인)  (0) 2018.01.03

cat /etc/my.cnf -n | grep server-id

 

[mysql@hohoho dump]$ cat /etc/my.cnf -n | grep server-id

    25        server-id                        = 100

    53        server-id                        = 100

'ETC > LINUX' 카테고리의 다른 글

파일내용찾기  (0) 2018.01.03

set line 250

col name format a10

col USABLE_FILE_GB format 999,999.00

col TOTAL_GB format 999,999.00

col FREE_GB format 999,999.00

col USABLE_CALC_GB format 999,999.00

select name

     , USABLE_FILE_MB/1024 USABLE_FILE_GB

     , total_mb/1024 TOTAL_GB, free_mb/1024 FREE_GB

     , 100-round(free_mb/total_mb*100) "usgae(%)"

     , ((FREE_MB - REQUIRED_MIRROR_FREE_MB))/1024 USABLE_CALC_GB

     , state

     , type

     , group_number

  from v$asm_diskgroup;

alter system set log_archive_dest_1='location=/oradata2/arch/DBDB11G/' scope=spfile;

alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;

 

 

alter database archivelog;

'ORACLE > ADMIN' 카테고리의 다른 글

Swing bench  (0) 2017.12.26
파티션 인덱스 rebuild 해도 lock 이 걸릴까~?  (0) 2017.12.26

ORA-39082: Object type PACKAGE BODY:"SOE"."ORDERENTRY" created with compilation warnings

Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at Tue Oct 31 11:55:53 2017 elapsed 0 00:02:51

 

SQL>  GRANT EXECUTE ON SYS.DBMS_LOCK TO SYSTEM;

'ORACLE > ADMIN' 카테고리의 다른 글

Archive mode 변경  (0) 2017.12.26
파티션 인덱스 rebuild 해도 lock 이 걸릴까~?  (0) 2017.12.26

 CREATE TABLE MONDBA.AA

(NO1 NUMBER,

NO2 VARCHAR2(50)

)

PARTITION BY RANGE (NO1)

(

PARTITION V_DATE_201301 VALUES LESS THAN('1000'),

PARTITION V_DATE_201302 VALUES LESS THAN('2000'),

PARTITION V_DATE_201303 VALUES LESS THAN('3000')

);

 

 

 

 

DECLARE

BEGIN

for cnt in 1..1000000 loop

INSERT INTO MONDBA.AA VALUES (dbms_random.value(1,1000),dbms_random.string('U',20));

commit;

end loop;

end;

/

 

CREATE INDEX MONDBA.AA_IDX ON MONDBA.AA(NO1) LOCAL;

 

 

 

ALTER INDEX MONDBA.AA_IDX REBUILD PARTITION V_DATE_201301  하는 도중에 다른 세션이

 

insert into mondba.aa values (2,'aa');

 

select *

  from MONDBA.AA

  where no1 = '10';

 

수행..

 

쿼리

특이사항

insert into mondba.aa values (2,'aa');

Insert hang 걸림. Alter 문 끝나면 같이 hang 풀림

insert into mondba.aa values (2000,'aa');

특이사항 없음

select * from MONDBA.AA  where no1 = '10';

특이사항 없음

select * from MONDBA.AA  where no1 = '1000';

특이사항 없음

 

Select 인 경우 실행 계획도 잘 풀림

 

 

 

SQL_ID  2yh32tdta9r8s, child number 0

-------------------------------------

select *   from MONDBA.AA   where no1 = '1000'

 

Plan hash value: 1637211202

 

----------------------------------------------------------------------------------------------

| Id  | Operation                          | Name   | Starts | A-Rows |   A-Time   | Buffers |

----------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                   |        |      1 |      0 |00:00:00.01 |       2 |

|   1 |  PARTITION RANGE SINGLE            |        |      1 |      0 |00:00:00.01 |       2 |

|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID| AA     |      1 |      0 |00:00:00.01 |       2 |

|*  3 |    INDEX RANGE SCAN                | AA_IDX |      1 |      0 |00:00:00.01 |       2 |

----------------------------------------------------------------------------------------------

 

Predicate Information (identified by operation id):

---------------------------------------------------

 

   3 - access("NO1"=1000)

 

Note

-----

   - dynamic sampling used for this statement (level=2)

 

 

24 rows selected.

 

 

 

 

 

SQL_ID  1647gzucs6y6p, child number 0

-------------------------------------

select *   from MONDBA.AA   where no1 = '10'

 

Plan hash value: 1637211202

 

----------------------------------------------------------------------------------------------

| Id  | Operation                          | Name   | Starts | A-Rows |   A-Time   | Buffers |

----------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                   |        |      1 |      0 |00:00:00.01 |       3 |

|   1 |  PARTITION RANGE SINGLE            |        |      1 |      0 |00:00:00.01 |       3 |

|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID| AA     |      1 |      0 |00:00:00.01 |       3 |

|*  3 |    INDEX RANGE SCAN                | AA_IDX |      1 |      0 |00:00:00.01 |       3 |

----------------------------------------------------------------------------------------------

 

Predicate Information (identified by operation id):

---------------------------------------------------

 

   3 - access("NO1"=10)

 

Note

-----

   - dynamic sampling used for this statement (level=2)

 

 

24 rows selected. CREATE TABLE MONDBA.AA

(NO1 NUMBER,

NO2 VARCHAR2(50)

)

PARTITION BY RANGE (NO1)

(

PARTITION V_DATE_201301 VALUES LESS THAN('1000'),

PARTITION V_DATE_201302 VALUES LESS THAN('2000'),

PARTITION V_DATE_201303 VALUES LESS THAN('3000')

);

 

 

 

 

DECLARE

BEGIN

for cnt in 1..1000000 loop

INSERT INTO MONDBA.AA VALUES (dbms_random.value(1,1000),dbms_random.string('U',20));

commit;

end loop;

end;

/

 

CREATE INDEX MONDBA.AA_IDX ON MONDBA.AA(NO1) LOCAL;

 

 

 

ALTER INDEX MONDBA.AA_IDX REBUILD PARTITION V_DATE_201301  하는 도중에 다른 세션이

 

insert into mondba.aa values (2,'aa');

 

select *

  from MONDBA.AA

  where no1 = '10';

 

수행..

 

쿼리

특이사항

insert into mondba.aa values (2,'aa');

Insert hang 걸림. Alter 문 끝나면 같이 hang 풀림

insert into mondba.aa values (2000,'aa');

특이사항 없음

select * from MONDBA.AA  where no1 = '10';

특이사항 없음

select * from MONDBA.AA  where no1 = '1000';

특이사항 없음

 

Select 인 경우 실행 계획도 잘 풀림

 

 

 

SQL_ID  2yh32tdta9r8s, child number 0

-------------------------------------

select *   from MONDBA.AA   where no1 = '1000'

 

Plan hash value: 1637211202

 

----------------------------------------------------------------------------------------------

| Id  | Operation                          | Name   | Starts | A-Rows |   A-Time   | Buffers |

----------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                   |        |      1 |      0 |00:00:00.01 |       2 |

|   1 |  PARTITION RANGE SINGLE            |        |      1 |      0 |00:00:00.01 |       2 |

|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID| AA     |      1 |      0 |00:00:00.01 |       2 |

|*  3 |    INDEX RANGE SCAN                | AA_IDX |      1 |      0 |00:00:00.01 |       2 |

----------------------------------------------------------------------------------------------

 

Predicate Information (identified by operation id):

---------------------------------------------------

 

   3 - access("NO1"=1000)

 

Note

-----

   - dynamic sampling used for this statement (level=2)

 

 

24 rows selected.

 

 

 

 

 

SQL_ID  1647gzucs6y6p, child number 0

-------------------------------------

select *   from MONDBA.AA   where no1 = '10'

 

Plan hash value: 1637211202

 

----------------------------------------------------------------------------------------------

| Id  | Operation                          | Name   | Starts | A-Rows |   A-Time   | Buffers |

----------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                   |        |      1 |      0 |00:00:00.01 |       3 |

|   1 |  PARTITION RANGE SINGLE            |        |      1 |      0 |00:00:00.01 |       3 |

|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID| AA     |      1 |      0 |00:00:00.01 |       3 |

|*  3 |    INDEX RANGE SCAN                | AA_IDX |      1 |      0 |00:00:00.01 |       3 |

----------------------------------------------------------------------------------------------

 

Predicate Information (identified by operation id):

---------------------------------------------------

 

   3 - access("NO1"=10)

 

Note

-----

   - dynamic sampling used for this statement (level=2)

 

 

24 rows selected. CREATE TABLE MONDBA.AA

(NO1 NUMBER,

NO2 VARCHAR2(50)

)

PARTITION BY RANGE (NO1)

(

PARTITION V_DATE_201301 VALUES LESS THAN('1000'),

PARTITION V_DATE_201302 VALUES LESS THAN('2000'),

PARTITION V_DATE_201303 VALUES LESS THAN('3000')

);

 

 

 

 

DECLARE

BEGIN

for cnt in 1..1000000 loop

INSERT INTO MONDBA.AA VALUES (dbms_random.value(1,1000),dbms_random.string('U',20));

commit;

end loop;

end;

/

 

CREATE INDEX MONDBA.AA_IDX ON MONDBA.AA(NO1) LOCAL;

 

 

 

ALTER INDEX MONDBA.AA_IDX REBUILD PARTITION V_DATE_201301  하는 도중에 다른 세션이

 

insert into mondba.aa values (2,'aa');

 

select *

  from MONDBA.AA

  where no1 = '10';

 

수행..

 

쿼리

특이사항

insert into mondba.aa values (2,'aa');

Insert hang 걸림. Alter 문 끝나면 같이 hang 풀림

insert into mondba.aa values (2000,'aa');

특이사항 없음

select * from MONDBA.AA  where no1 = '10';

특이사항 없음

select * from MONDBA.AA  where no1 = '1000';

특이사항 없음

 

Select 인 경우 실행 계획도 잘 풀림

 

 

 

SQL_ID  2yh32tdta9r8s, child number 0

-------------------------------------

select *   from MONDBA.AA   where no1 = '1000'

 

Plan hash value: 1637211202

 

----------------------------------------------------------------------------------------------

| Id  | Operation                          | Name   | Starts | A-Rows |   A-Time   | Buffers |

----------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                   |        |      1 |      0 |00:00:00.01 |       2 |

|   1 |  PARTITION RANGE SINGLE            |        |      1 |      0 |00:00:00.01 |       2 |

|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID| AA     |      1 |      0 |00:00:00.01 |       2 |

|*  3 |    INDEX RANGE SCAN                | AA_IDX |      1 |      0 |00:00:00.01 |       2 |

----------------------------------------------------------------------------------------------

 

Predicate Information (identified by operation id):

---------------------------------------------------

 

   3 - access("NO1"=1000)

 

Note

-----

   - dynamic sampling used for this statement (level=2)

 

 

24 rows selected.

 

 

 

 

 

SQL_ID  1647gzucs6y6p, child number 0

-------------------------------------

select *   from MONDBA.AA   where no1 = '10'

 

Plan hash value: 1637211202

 

----------------------------------------------------------------------------------------------

| Id  | Operation                          | Name   | Starts | A-Rows |   A-Time   | Buffers |

----------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                   |        |      1 |      0 |00:00:00.01 |       3 |

|   1 |  PARTITION RANGE SINGLE            |        |      1 |      0 |00:00:00.01 |       3 |

|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID| AA     |      1 |      0 |00:00:00.01 |       3 |

|*  3 |    INDEX RANGE SCAN                | AA_IDX |      1 |      0 |00:00:00.01 |       3 |

----------------------------------------------------------------------------------------------

 

Predicate Information (identified by operation id):

---------------------------------------------------

 

   3 - access("NO1"=10)

 

Note

-----

   - dynamic sampling used for this statement (level=2)

 

 

24 rows selected. 

'ORACLE > ADMIN' 카테고리의 다른 글

Archive mode 변경  (0) 2017.12.26
Swing bench  (0) 2017.12.26

+ Recent posts

티스토리툴바