12c – Adamhuan's Data Center – 【逻辑驱动数据】

[oracle@oracleme ~]$ id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)
[oracle@oracleme ~]$ 
[oracle@oracleme ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 10 16:32:03 2018

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> 
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
----------------------------------------
TO STANDBY

SQL> 
SQL> select database_role from v$database;

DATABASE_ROLE
--------------------------------
PRIMARY

SQL>    
SQL> show parameter unique

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_unique_name                       string
orcl
SQL> 
SQL> select instance_name,status from v$instance;

INSTANCE_NAME                    STATUS
-------------------------------- ------------------------
orcl                             OPEN

SQL> 
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@oracleme ~]$

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

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

[oracle@oracleme ~]$ id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)

[oracle@oracleme ~]$

[oracle@oracleme ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 10 16:32:03 2018

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

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

TO STANDBY

SQL>

SQL> select database_role from v$database;

DATABASE_ROLE

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

PRIMARY

SQL>

SQL> show parameter unique

NAME TYPE

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

VALUE

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

db_unique_name string

orcl

SQL>

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

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

orcl OPEN

SQL>

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[oracle@oracleme ~]$

[……]

Posted on: 2018年4月10日 2018年4月10日
Author: Adamhuan
Categories: Oracle Dataguard
Tags: 12c, centos, dataguard, DG, Linux, Oracle, switchover, 主备切换
Leave a comment: Oracle database 12c：DataGuard 主备切换

Oracle Database 12c：Data Guard in CentOS 7.4.1708

开始本文的前提：
1. CentOS Linux 7.4.1708:2台
2. 都安装了Oracle 12c database
3. 主节点已经建好了库

在我的环境里：
Primary – 10.158.1.97
Standby – 10.158.1.161

文件：/etc/h[……]

Posted on: 2018年4月10日 2018年4月10日
Author: Adamhuan
Categories: Oracle Dataguard
Tags: 12c, 7.4.1708, centos, Data Guard, dataguard, DG, Install, Linux, Oracle, 安装, 架构, 部署
Leave a comment: Oracle Database 12c：Data Guard in CentOS 7.4.1708

ORA-12705: Cannot access NLS data files or invalid environment specified

如题所示，在启动SQLPLUS的时候，你可能遇到上面的错误。
具体如下：

[oracle@oracleme ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 4 14:21:08 2018

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

ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


Enter user-name: ^C
[oracle@oracleme ~]$

1

2

3

4

5

6

7

8

9

10

11

12

[oracle@oracleme ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 4 14:21:08 2018

ERROR:

ORA-12705: Cannot access NLS data files or invalid environment specified

Enter user-name: ^C

[oracle@oracleme ~]$

造成这个问题的原因是两个环境变量的配置：
1. NLS_LANG
2. ORA_NLS10

正确的配置：
[crayon-63dd9[……]

Posted on: 2018年4月4日 2018年4月4日
Author: Adamhuan
Categories: Oracle Database
Tags: 12c, error, Linux, NLS_LANG, ORA-12705: Cannot access NLS data files or invalid environment specified, Oracle, SQL*Plus
Leave a comment: ORA-12705: Cannot access NLS data files or invalid environment specified