移动-AIX营账数据库安装报告oracleracv40-internal.doc

广东移动广东移动 BOSS1 5BOSS1 5 版本扩容及容灾工程版本扩容及容灾工程 营业帐务子系统营业帐务子系统 数据库安装报告数据库安装报告 上海新炬网络技术有限公司上海新炬网络技术有限公司 北京甲骨文软件系统有限公司北京甲骨文软件系统有限公司 2006 年 8 月 文档更改历史记录文档更改历史记录 日期日期版本号版本号描述描述作者作者 2006 9 10V1 0林小勇 2006 09 11V2 0林小勇 2006 09 27 V3 0V2 0基础作修正 并增加one off patch邓越 林小勇 2006 11 21V4 0根据封版检查的要求 增加OS DB参数 设置及网络配置 邓越 林小勇 目目 录录 1硬件配置硬件配置 5 2软件及版本软件及版本 5 3IP 分配置及主机名分配置及主机名 5 4安装安装 REAL APPLICATION CLUSTER 6 4 14 1网络配置网络配置 6 4 24 2共享存储配置共享存储配置 6 4 34 3操作系统环境要求及设置操作系统环境要求及设置 6 4 44 4组及用户建立组及用户建立 9 4 54 5修改修改 OSOS 参数及参数及 SHELLSHELL 限制 限制 9 4 64 6修改用户配置文件修改用户配置文件 10 4 74 7建立安装目录建立安装目录 10 4 84 8所有节点配置所有节点配置 RCPRCP 11 4 94 9在所有节点执行在所有节点执行ROOTPREROOTPRE SHSH脚本脚本 11 4 104 10安装安装 O ORACLERACLE C CLUSTERLUSTER R READYEADY S SERVICEERVICE 12 4 114 11安装安装 O ORACLERACLE D DATABASEATABASE S SERVERERVER 24 5安装安装 ORACLE 10 2 0 2 补丁集补丁集 30 5 15 1分别停止所有主机的分别停止所有主机的 CRSCRS 相关服务相关服务 30 5 25 2确认所有确认所有 CRSCRS 进程均已经停止进程均已经停止 30 5 35 3在其中一台主机上安装在其中一台主机上安装CRSCRS PATCHPATCH 31 5 45 4确定确定 CRSCRS 服务的运行状态服务的运行状态 35 5 55 5在其中一台主机上安装在其中一台主机上安装 D DATABASEATABASE S SERVERERVER 补丁集补丁集 35 6安装安装 ONE OFF PATCH 38 6 16 1ONEONE OFFOFF PATCHPATCH列表列表 38 6 26 2确认所有确认所有ORACLEORACLE进程均已停止 进程均已停止 38 6 36 3安装安装ONEONE OFFOFF PATCHPATCH 39 6 46 4两节点的两节点的ORACLEORACLE文件同步文件同步 43 6 56 5修改配置文件修改配置文件 44 6 66 6修改操作系统的参数修改操作系统的参数 44 6 76 7启动启动 OCROCR 进程进程 44 7建立及配置用户数据库建立及配置用户数据库 44 7 17 1建立数据库建立数据库 44 7 27 2建立必要的用户表空间建立必要的用户表空间 50 8状态检测状态检测 50 8 18 1版本信息版本信息 50 8 28 2CRSCRS 进程状态进程状态 50 8 38 3服务状态服务状态 51 8 48 4实例运行状态实例运行状态 51 8 58 5数据库基本属性数据库基本属性 52 9附录 附录 53 9 19 1数据库参数数据库参数设设置置 53 9 29 2网络连接配置网络连接配置 54 1硬件配置硬件配置 名称名称数量数量配件配件 服务器 2 IBM p595 20CPU 128G RAM CD DVD RROM 本地存储 2 273G SCSI HD 共享存储 1IBM DS8300 2软件及版本软件及版本 软件及版本软件及版本厂商厂商介质介质 AIX5 3 ML4 IBMCD HACMP 5 2 IBMCD Oracle Database Enterprise Edition 企 业版数据库 10G Release2 OracleCD Oracle Cluster Ready Services 集群数据 库选件 OracleCD 3IP 分配置及主机名分配置及主机名 主机名主机名IPIP 地址地址子网掩码子网掩码 10 243 208 5255 255 255 192 10 243 208 6255 255 255 192S3 C YZ YZSJK 192 168 208 5255 255 255 0 10 243 208 7255 255 255 192 10 243 208 8255 255 255 192S4 C YZ YZSJK 192 168 208 7255 255 255 0 4安装安装 Real Application Cluster 4 14 1网络配置网络配置 修改 S3 C YZ YZSJK 及 S4 C YZ YZSJK 的 etc hosts 文件 加入以下内容 127 0 0 1 loopback localhost 10 243 208 5 S3 C YZ YZSJK 192 168 208 5 s3yz pri 10 243 208 6 s3yz vip 10 243 208 131 S3 C YZ YZSJK BEIFEN 10 243 208 7 S4 C YZ YZSJK 192 168 208 7 s4yz pri 10 243 208 8 s4yz vip 10 243 208 132 S4 C YZ YZSJK BEIFEN 注 注 HACMPHACMP 的节点名与的节点名与 RACRAC 所用的主机名保持一致所用的主机名保持一致 4 24 2共享存储配置共享存储配置 根据空间使用规划进行存储划分 建立根据空间使用规划进行存储划分 建立 LV 及符号链接及符号链接 见 营账测试数据库文件链接建立脚本 4 34 3操作系统操作系统环境要求及设置环境要求及设置 内存要求 至少内存要求 至少 512M S3 C YZ YZSJK ora installS3 C YZ YZSJK ora install lsattrlsattr El El mem0mem0 goodsize 127488 Amount of usable physical memory in Mbytes False size 127488 Total amount of physical memory in Mbytes False 本地存储空间要求本地存储空间要求 软件安装目录 4G tmp 目录至少 400M S3 C YZ YZSJK S3 C YZ YZSJK df df k k Filesystem 1024 blocks Free Used Iused Iused Mounted on dev hd4 1310720 873052 34 3606 2 dev hd2 2752512 417124 85 54293 36 usr dev hd9var 1310720 1274524 3 568 1 var dev hd3 1310720 1298216 1 186 1 tmp dev hd1 1310720 1310148 1 10 1 home proc proc dev hd10opt 131072 75336 43 2345 12 opt dev lv00 131072 126912 4 18 1 var adm csd dev ptflv 1310720 396700 70 245 1 ptf dev oracle lv 10485760 10483796 1 12 1 oracle 交换分区要求 最少交换分区要求 最少 400M S3 C YZ YZSJK S3 C YZ YZSJK lsps lsps a a Page Space Physical Volume Volume Group Size Used Active Auto Type paging00 hdisk2 rootvg 32768MB 1 yes yes lv hd6 hdisk0 rootvg 32768MB 1 yes yes lv AIX 5 3 ML 4 所需软件包 所需软件包 确认是否安装已下软件包及补丁 S3 C YZ YZSJK ora installS3 C YZ YZSJK ora install lslpplslpp l l bos adt basebos adt base bos adt libbos adt lib bos adt libmbos adt libm bos perf libperfstatbos perf libperfstat bos perf perfstatbos perf perfstat bos perf proctoolsbos perf proctools rsct basic rtersct basic rte vacpp cmp corevacpp cmp core vac Cvac C Fileset Level State Description Path usr lib objrepos bos adt base 5 3 0 40 COMMITTED Base Application Development Toolkit Path usr lib objrepos bos adt lib 5 3 0 40 COMMITTED Base Application Development Libraries Path usr lib objrepos bos adt libm 5 3 0 40 COMMITTED Base Application Development Math Library Path usr lib objrepos bos perf libperfstat 5 3 0 30 COMMITTED Performance Statistics Library Interface Path etc objrepos bos perf libperfstat 5 3 0 30 COMMITTED Performance Statistics Library Interface Path usr lib objrepos bos perf perfstat 5 3 0 40 COMMITTED Performance Statistics Interface Path etc objrepos bos perf perfstat 5 3 0 40 COMMITTED Performance Statistics Interface Path usr lib objrepos bos perf proctools 5 3 0 30 COMMITTED Proc Filesystem Tools Path usr lib objrepos rsct basic rte 2 4 4 0 COMMITTED RSCT Basic Function Path etc objrepos rsct basic rte 2 4 4 0 COMMITTED RSCT Basic Function Path usr lib objrepos vacpp cmp core 7 0 0 6 APPLIED IBM XL C C Compiler Path etc objrepos vacpp cmp core 7 0 0 0 COMMITTED IBM XL C C Compiler 所需操作系统补丁 所需操作系统补丁 S3 C YZ YZSJK ora installS3 C YZ YZSJK ora install instfixinstfix ik ik IY58143 IY58143 IY59386IY59386 IY60930IY60930 IY66513IY66513 IY61034IY61034 IY62191IY62191 IY60759IY60759 IY70159IY70159 IY68989 IY68989 All filesets for IY58143 were found All filesets for IY59386 were found All filesets for IY60930 were found All filesets for IY66513 were found All filesets for IY61034 were found All filesets for IY62191 were found All filesets for IY60759 were found All filesets for IY70159 were found All filesets for IY68989 were found 2 5 JDK 环境与环境与 APAR required 所需的补丁取决 JDK 的版本 IBM JDK 1 3 1 11 32 bit IY47055 IBM JDK 1 4 1 2 32 bit IY47536 IBM JDK 1 4 1 1 64 bit IY47538 S3 C YZ YZSJK ora installS3 C YZ YZSJK ora install javajava versionversion java version 1 4 2 Java TM 2 Runtime Environment Standard Edition build 1 4 2 Classic VM build 1 4 2 J2RE 1 4 2 IBM AIX build ca142 20050929a SR3 JIT enabled jitc GPFS 所需软件包及补丁所需软件包及补丁 GPFS 2 3 0 1 GPFS 2 3 plus APAR IY63969 or later S3 C YZ YZSJK ora installS3 C YZ YZSJK ora install lslpp lslpp l grep l grep GPFSGPFS gpfs base 2 3 0 15 APPLIED GPFS File Manager gpfs msg en US 2 3 0 10 APPLIED GPFS Server Messages U S gpfs base 2 3 0 15 APPLIED GPFS File Manager gpfs docs data 2 3 0 8 APPLIED GPFS Server Manpages and 4 44 4组及用户建立组及用户建立 利用 smitty 工具分别在两台主机上新建三个组 oinstall dbaoinstall dba hagsuserhagsuser 分别在两台主机上新建 oracle 用户 并加入以上新建的三个组之中 另外将 root 用户添加到 hagsuser 组中 注意 不同主机中所有的注意 不同主机中所有的 groupidgroupid 及及 useriduserid 必须一致 必须一致 修改 oracle 用户口令 S3 C YZ YZSJK ora install su oracle S3 C YZ YZSJK ora install id uid 301 oracle gid 301 dba groups 302 oinstall 207 hagsuser 4 54 5修改修改 OSOS 参数及参数及 SHELLSHELL 限制 限制 在 etc security limits 文件中作以下调整 default fsize 1 core 1 cpu 1 data 1 rss 1 stack 1 nofiles 1 usr sbin chdev l sys0 a ncargs 128 usr sbin lsattr El sys0 a ncargs ncargs 128 ARG ENV list size in 4K byte blocks True usr sbin vmo r o v pinshm 1 lru file repage 0 注 注 AIXAIX 分页不足就从文件系统分页不足就从文件系统 BUFFERBUFFER CACHECACHE 拿内存 而不是使用拿内存 而不是使用 SGASGA 的内存空间的内存空间 MINPERM 10 15 MAXPERM 20 30 MAXCLIENT MAXPERM 4 64 6修改用户配置文件修改用户配置文件 PATH PATH HOME bin export PATH unset USERNAME export ORACLE BASE oracle products export ORACLE HOME ORACLE BASE 10 2 db export ORA CRS HOME ORACLE BASE 10 2 crs export ORACLE TERM xterm export NLS LANG AMERICAN AMERICA ZHS16GBK export ORA NLS33 ORACLE HOME ocommon nls admin data export PATH ORACLE HOME bin ORA CRS HOME bin PATH export AIXTHREAD SCOPE S export ORACLE SID szdb1 unset USERNAME 4 74 7建立安装目录建立安装目录 建立安装目录并修改相关的读写权限 mkdir p oracle products 10 2 crs mkdir p oracle products 10 2 db chown R oracle oinstall oracle products 10 2 db chown R root oinstall oracle products 10 2 crs chmod R 775 oracle products 10 2 crs chmod R 775 oracle products 10 2 db 4 84 8所有节点配置所有节点配置 R RCPCP 为了在集群的某一个节点上安装其他节点的 Oracle 数据库软件 需要设置每个节点 Oracle 用户的同等性 分别在两台主机修改 rhosts exportPATH PATH source one patch OPatch export PATHPATH whichwhich opatchopatch opatch unzipunzip p5087548 10202 AIX64 5L zipp5087548 10202 AIX64 5L zip Archive p5087548 10202 AIX64 5L zip creating 5087548 creating 5087548 files creating 5087548 files install inflating 5087548 files install changePerm sh inflating 5087548 files install restrict lst creating 5087548 etc creating 5087548 etc config inflating 5087548 etc config inventory inflating 5087548 etc config actions creating 5087548 etc xml inflating 5087548 etc xml GenericActions xml inflating 5087548 etc xml ShiphomeDirectoryStructure xml inflating 5087548 README txt cdcd 50875485087548 opatchopatch applyapply local local Invoking OPatch 10 2 0 2 1 Oracle interim Patch Installer version 10 2 0 2 1 Copyright c 2005 Oracle Corporation All rights reserved Oracle Home oracle products 10 2 db Central Inventory oracle products oraInventory from oracle products 10 2 db oraInst loc OPatch version 10 2 0 2 1 OUI version 10 2 0 2 0 OUI location oracle products 10 2 db oui Log file location oracle products 10 2 db cfgtoollogs opatch opatch 00 Sep 27 17 05 31 GMT 08 Wed log ApplySession applying interim patch 5087548 to OH oracle products 10 2 db You selected local option hence OPatch will patch the local system only Backing up files and inventory not for auto rollback for the Oracle Home Backing up files affected by the patch 5087548 for restore This might take a while Backing up files affected by the patch 5087548 for rollback This might take a while Patching component oracle rdbms rsf 10 2 0 2 0 Copying file to oracle products 10 2 db install changePerm sh Copying file to oracle products 10 2 db install restrict lst ApplySession adding interim patch 5087548 to inventory Verifying the update Inventory check OK Patch ID 5087548 is registered in Oracle Home inventory with proper meta data Files check OK Files from Patch ID 5087548 are present in Oracle Home OPatch succeeded unzipunzip p5036588 10202 AIX64 5L zipp5036588 10202 AIX64 5L zip Archive p5036588 10202 AIX64 5L zip creating 5091089 creating 5091089 files creating 5091089 files lib creating 5091089 files lib libserver10 a inflating 5091089 files lib libserver10 a kewm o creating 5091089 etc creating 5091089 etc config inflating 5091089 etc config inventory inflating 5091089 etc config actions creating 5091089 etc xml inflating 5091089 etc xml GenericActions xml inflating 5091089 etc xml ShiphomeDirectoryStructure xml inflating 5091089 README txt cdcd 50910895091089 opatchopatch applyapply local local Invoking OPatch 10 2 0 2 1 Oracle interim Patch Installer version 10 2 0 2 1 Copyright c 2005 Oracle Corporation All rights reserved Oracle Home oracle products 10 2 db Central Inventory oracle products oraInventory from oracle products 10 2 db oraInst loc OPatch version 10 2 0 2 1 OUI version 10 2 0 2 0 OUI location oracle products 10 2 db oui Log file location oracle products 10 2 db cfgtoollogs opatch opatch 00 Sep 27 16 59 46 GMT ApplySession applying interim patch 5091089 to OH oracle products 10 2 db Invoking fuser to check for active processes Invoking fuser on oracle products 10 2 db bin oracle You selected local option hence OPatch will patch the local system only Please shutdown Oracle instances running out of this ORACLE HOME on the local system Oracle Home oracle products 10 2 db Is the local system ready for patching DoDo youyou wantwant toto proceed proceed y n y n y y User Responded with Y Backing up files and inventory not for auto rollback for the Oracle Home Backing up files affected by the patch 5091089 for restore This might take a while Backing up files affected by the patch 5091089 for rollback This might take a while Patching component oracle rdbms 10 2 0 2 0 Updating archive file oracle products 10 2 db lib libserver10 a with lib libserver10 a kewm o Running make for target ioracle ApplySession adding interim patch 5091089 to inventory Verifying the update Inventory check OK Patch ID 5091089 is registered in Oracle Home inventory with proper meta data Files check OK Files from Patch ID 5091089 are present in Oracle Home The local system has been patched and can be restarted OPatch succeeded 查看已安装的补丁查看已安装的补丁 opatchopatch lsinventorylsinventory Invoking OPatch 10 2 0 2 1 Oracle interim Patch Installer version 10 2 0 2 1 Copyright c 2005 Oracle Corporation All rights reserved Oracle Home oracle products 10 2 db Central Inventory oracle products oraInventory from oracle products 10 2 db oraInst loc OPatch version 10 2 0 2 1 OUI version 10 2 0 2 0 OUI location oracle products 10 2 db oui Log file location oracle products 10 2 db cfgtoollogs opatch opatch 00 Oct 09 10 58 28 GMT 08 Mon log Lsinventory Output file location oracle products 10 2 db cfgtoollogs opatch lsinv lsinventory 00 Oct 09 10 58 28 GMT 08 Mon txt Installed Top level Products 2 Oracle Database 10g 10 2 0 1 0 Oracle Database 10g Release 2 Patch Set 1 10 2 0 2 0 There are 2 products installed in this Oracle Home Interim patches 9 Patch 5226383 applied on Mon Oct 09 10 57 51 GMT 08 00 2006 Created on 18 Sep 2006 07 49 57 hrs PST8PDT Bugs fixed 5226383 Patch 5087548 applied on Thu Sep 28 14 17 36 GMT 08 00 2006 Created on 14 Mar 2006 00 22 00 hrs US Pacific Bugs fixed 5087548 Patch 5449513 applied on Thu Sep 28 14 17 09 GMT 08 00 2006 Created on 25 Aug 2006 06 06 34 hrs US Pacific Bugs fixed 5001975 4883174 5123783 5449513 4953737 5098050 4395779 5176453 5127478 4967266 Patch 5467795 applied on Thu Sep 28 14 16 12 GMT 08 00 2006 Created on 15 Sep 2006 01 46 12 hrs PST8PDT Bugs fixed 4682861 4709214 4874273 4690794 5061068 5071492 5127459 5075434 5467795 5310273 4709210 4672266 4960746 4755405 4943406 Patch 5127482 applied on Thu Sep 28 14 15 27 GMT 08 00 2006 Created on 12 Jun 2006 06 45 24 hrs US Pacific Bugs fixed 5127482 5065930 4868650 4935707 4933038 4733738 Patch 5127472 applied on Thu Sep 28 14 14 44 GMT 08 00 2006 Created on 31 May 2006 04 24 17 hrs US Pacific Bugs fixed 5080775 5127472 4928371 Patch 5091089 applied on Thu Sep 28 14 14 06 GMT 08 00 2006 Created on 12 Mar 2006 17 17 38 hrs US Pacific Bugs fixed 5036588 Patch 4518443 applied on Thu Sep 28 14 13 01 GMT 08 00 2006 Created on 4 Sep 2006 23 21 37 hrs US Pacific Bugs fixed 4518443 Patch 4336528 applied on Thu Sep 28 14 12 22 GMT 08 00 2006 Created on 3 May 2006 07 53 37 hrs US Pacific Bugs fixed 4336528 6 46 4两节点的两节点的 oracleoracle 文件同步文件同步 在安装完毕所有的补丁后 将第一个节点 假设安装程序 runInstaller 是在第一 个节点执行的 的 ORACLE HOME 目录打包传送到第二个节点 然后展开在第二个 节点的 ORACLE HOME 下面 否则 两个节点的 ORACLE 执行文件 ORACLE HOME bin oracle 的大小是不一样的 6 56 5修改配置文件修改配置文件 安装完补丁后 需要修改文件 ORACLE HOME sysman lib env sysman mk 将 JRE LIB DIR JRE HOME bin 改为 JRE LIB DIR ORACLE HOME jdk jre bin 6 66 6修改操作系统的参数修改操作系统的参数 usr sbin chdev l sys0 a ncargs 128 usr sbin lsattr El sys0 a ncargs ncargs 128 ARG ENV list size in 4K byte blocks True 6 76 7启动启动 OCROCR 进程进程 7建立及配置用户数据库建立及配置用户数据库 7 17 1建立数据库建立数据库 启动数据配置助手建立数据库 选择建立集群数据库启动数据配置助手建立数据库 选择建立集群数据库 dbca 指定集群数据库节点名 指定集群数据库节点名 S3 C GZ YZSJK S4 C GZ YZSJK 指定数据库全局名及实例名 数据全局名指定数据库全局名及实例名 数据全局名 SZDB S3 C YZ YZSJK 节点实例名节点实例名 SZDB1 S4 C YZ YZSJK 节点实例名 节点实例名 SZDB2 选择数据库管理工具 选择数据库管理工具 database control for database management 设定数据库用户口令设定数据库用户口令 选择数据库文件存储设备 选择数据库文件存储设备 raw devices 选择是归档模式及快速恢复区 非归档模式 不设定恢复区选择是归档模式及快速恢复区 非归档模式 不设定恢复区 设定数据库基本属性 设定数据库基本属性 字符集 ZHS16GBK 国家字符集 AL16UTF16 数据块大小 8K 连接模式 专用服务器 参数文件类型 文本类型 开始数据库建立开始数据库建立 7 27 2建立必要的用户表空间建立必要的用户表空间 创建脚本见 营账测试数据库表空间创建脚本 8状态检测状态检测 8 18 1版本信息版本信息 SQL SQL selectselect comp name version statuscomp name version status fromfrom dba registry dba registry COMP NAME VERSION STATUS Oracle Workspace Manager 10 2 0 1 0 VALID Oracle Enterprise Manager 10 2 0 2 0 VALID Oracle Database Catalog Views 10 2 0 2 0 VALID Oracle Database Packages and Types 10 2 0 2 0 VALID Oracle Real Application Clusters 10 2 0 2 0 VALID 8 28 2CRSCRS 进程状态进程状态 bin crsctlbin crsctl checkcheck crscrs CSS appears healthy CRS appears healthy EVM appears healthy 8 38 3服务状态服务状态 bin crs statbin crs stat t t Name Type Target State Host ora B1 inst application ONLINE ONLINE s3 c zsjk ora B2 inst application ONLINE ONLINE s4 c zsjk ora SZDB db application ONLINE ONLINE s3 c zsjk ora JK lsnr application ONLINE ONLINE s3 c zsjk ora sjk gsd application ONLINE OFFLINE ora sjk ons application ONLINE ONLINE s3 c zsjk ora sjk vip application ONLINE ONLINE s3 c zsjk ora JK lsnr application ONLINE ONLINE s4 c zsjk ora sjk gsd application ONLINE OFFLINE ora sjk ons application ONLINE ONLINE s4 c zsjk ora sjk vip application ONLINE ONLINE s4 c zsjk 8 48 4实例运行状态实例运行状态 srvctlsrvctl statusstatus databasedatabase d d SZDBSZDB Instance SZDB1 is running on node s3 c yz yzsjk Instance SZDB2 is not running on node s4 c yz yzsjk SQL SQL SELECTSELECT inst id inst id instance numberinstance number inst no instance nameinst no instance name inst name inst name 2 2 ParallelParallel status status database statusdatabase status db status db status active stateactive state 3 3 host namehost name hosthost FROMFROM gv instancegv instance ORDERORDER BYBY inst id inst id INST ID INST NO INST NAME STA DB STATUS STATE HOST 1 1 SZDB1 YES ACTIVE NORMAL S3 C YZ YZSJK 2 2 SZDB2 YES ACTIVE NORMAL S4 C YZ YZSJK SQL SQL selectselect NAME LOG MODE OPEN MODE DATABASE ROLE FORCE LOGGING FLASHBACK ONNAME LOG MODE OPEN MODE DATABASE ROLE FORCE LOGGING FLASHBACK ON fromfrom v database v database NAME LOG MODE OPEN MODE DATABASE ROLE FOR FLASHBACK ON SZDB NOARCHIVELOG READ WRITE PRIMARY NO NO 8 58 5数据库基本属性数据库基本属性 SQL SQL selectselect PROPERTY NAME PROPERTY VALUEPROPERTY NAME PROPERTY VALUE fromfrom database properties database properties PROPERTY NAME PROPERTY VALUE DICT BASE 2 DEFAULT TEMP TABLESPACE TMP DEFAULT PERMANENT TABLESPACE SYSTEM DBTIMEZONE 08 00 DEFAULT TBS TYPE SMALLFILE NLS LANGUAGE AMERICAN NLS TERRITORY AMERICA NLS CURRENCY NLS ISO CURRENCY AMERICA NLS NUMERIC CHARACTERS NLS CHARACTERSET ZHS16GBK NLS CALENDAR GREGORIAN NLS DATE FORMAT DD MON RR NLS DATE LANGUAGE AMERICAN NLS SORT BINARY NLS TIME FORMAT HH MI SSXFF AM NLS TIMESTAMP FORMAT DD MON RR HH MI SSXF NLS TIME TZ FORMAT HH MI SSXFF AM TZR NLS TIMESTAMP TZ FORMAT DD MON RR HH MI SSXF NLS DUAL CURRENCY NLS COMP BINARY NLS LENGTH SEMANTICS BYTE NLS NC