db oracle config

C:\Program Files\Oracle\Inventory\logs\installActions2008-09-22_10-51-59AM.log
C:\Program Files\Oracle\Inventory\logs\installActions2008-09-22_08-11-39PM.log

Oracle 10g Client Net Config

文件：D:\oracle10client\product\10.2.0\client_1\network\ADMIN\\ tnsnames.ora

Oracle 11g Net Config

文件:D:\oracle\product\11.1.0\db_2\NETWORK\ADMIN\ tnsnames.ora

内容：

# tnsnames.ora Network Configuration File: d:\oracle10client\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

192.168.200.72_GOLD =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.72)(PORT = 2521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = gold)
    )
)

127.0.0.1_GOLD =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 2521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = gold)
    )
)

192.168.100.120_SNTEST =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.120)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sntest)
    )
)

192.168.100.40_SAPDB =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.40)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sapdb)
    )
)

#host=0901D2E7ACA449C id:sys,system,scott pwd:sys,li,li#

192.168.116.161_ORCL =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.116.161)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.lcs)
    )
)

Oracle 10g Create Users & Tablespace

oracle:192.168.116.161

id:sys pwd:li

id:system pwd:li

id:scott pwd:li

CREATE USER "SNWORKORDER" PROFILE "DEFAULT"
    IDENTIFIED BY "SNWORKORDER" DEFAULT TABLESPACE "SNWORKORDER"
    TEMPORARY TABLESPACE "TEMP"
    ACCOUNT UNLOCK;
GRANT ALTER ANY TABLE TO "SNWORKORDER" WITH ADMIN OPTION
GRANT CREATE ANY TABLE TO "SNWORKORDER" WITH ADMIN OPTION
GRANT CREATE TABLE TO "SNWORKORDER" WITH ADMIN OPTION
GRANT DROP ANY TABLE TO "SNWORKORDER" WITH ADMIN OPTION
GRANT INSERT ANY TABLE TO "SNWORKORDER" WITH ADMIN OPTION
GRANT SELECT ANY TABLE TO "SNWORKORDER" WITH ADMIN OPTION
GRANT SYSDBA TO "SNWORKORDER" WITH ADMIN OPTION
GRANT "CONNECT" TO "SNWORKORDER" WITH ADMIN OPTION;
GRANT "DBA" TO "SNWORKORDER" WITH ADMIN OPTION;
GRANT "OLAP_DBA" TO "SNWORKORDER" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "SNWORKORDER" WITH ADMIN OPTION;

oracle9.0.0.1 缺省安装字符集为zhs16gbk

全局数据库名称/系统标识符 sid:oracle9i

sys/change_on_install system/manager

INVENTORY CONTENTS OF (lindows-xp/192.168.116.159):

修改oracle最大连接数

http://weiruan85.iteye.com/blog/307221

修改Oracle最大连接数
1、修改Oracle最大连接数的方法
   a、以sysdba身份登陆PL/SQL 或者 Worksheet
   b、查询目前连接数
      show parameter processes;
   c、更改系统连接数
      alter system set processes=1000 scope=spfile;
   d、创建pfile
      create pfile from spfile;
   e、重启Oracle服务或重启Oracle服务器

2、查询Oracle游标使用情况的方法
   select * from v$open_cursor where user_name = 'TRAFFIC'；
3、查询Oracle会话的方法
   select * from v$session