orcale学习

1orcale大字段查询

1identifier is too long 错误

解决办法:

原因在于字段超过了Oracle本身设定的30个字符.

 

2orcale赋权限

 

 

3设置Oracle数据库客户端字符集以及系统中的NLS_LANG环境变量

4oracle监听

[oracle@erzhen ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-AUG-2019 20:56:00

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                20-AUG-2019 05:17:17
Uptime                    2 days 15 hr. 38 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /data/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File         /data/oracle/diag/tnslsnr/erzhen/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.109.66)(PORT=1521)))
Services Summary...
Service "orcl.test" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.test" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@erzhen ~]$ 

[oracle@erzhen ~]$ tnsping 10.10.109.66/orcl

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 22-AUG-2019 21:01:57

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

Used parameter files:
/data/oracle/product/11.2.0/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcl))(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.109.66)(PORT=1521)))
OK (0 msec)
[oracle@erzhen ~]$ tnsping 10.10.109.66/orcl

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 22-AUG-2019 21:02:48

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

Used parameter files:
/data/oracle/product/11.2.0/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcl))(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.109.66)(PORT=1521)))
OK (0 msec)
[oracle@erzhen ~]$