-
编辑 删除
Time zone [转]
1. How to check the session time zone ? ======================================= Answer ------ The new SESSIONTIMEZONE built-in SQL function returns the value of the current session's time zone. SQL> SELECT SESSIONTIMEZONE FROM DUAL; SESSIONTIMEZONE --------------- +01:00 2. How to set the session time zone ? ===================================== Answer ------ The session time zone can be set to: - O/S local time zone - Database time zone - An absolute offset - A named region 1. The first meth
-
编辑 删除
RHEL5.3安装Oracle10.2.0笔记 完整普及版（二）
1. 创建 Oracle 组和用户帐户(root) [root@RHEL ~]# /usr/sbin/groupadd oinstall [root@RHEL ~]# /usr/sbin/groupadd dba [root@RHEL ~]# /usr/sbin/useradd -m -g oinstall -G dba oracle [root@RHEL ~]# id oracleuid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba) context=root:system_r:unconfined_t:SystemLow-SystemHigh [root@RHEL ~]# passwd oracle2. 创建安装目录(root)创建存储 Oracle 10g 软件和数据库文件的目录。在创建目录结构时所用的命名惯例符合最佳灵活结构 (OFA) 规范。 [root@RH
-
编辑 删除
RHEL5.3安装Oracle10.2.0笔记 完整普及版（一）
1. 1. RHEL5.2 内核版本(root) [root@RHEL ~]# uname -r2.6.18-92.el5xen2. 2.Oracle 10g 所需程序包(root)[root@RHEL ~]# rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-develpackage gcc is not installedmake-3.81-3.el5binutils-2.17.50.0.6-9.el5package openmotif is not installedsetarch-2.0-1.1package compat-db is not installedpackage compat-gcc is not installedpackage compat-gcc-c++ is not installedpackage compat-libstdc++ is not installed
