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

ora10.rar (2.3 KB)
下载次数: 10

分享到：

base html / div / css / HTML / DIV / CSS | UNIX + OS IBM AIX 5L HACMP

2008-09-12 00:43
浏览 2843
评论(0)
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

db oracle config

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

db oracle config

评论

发表评论

相关推荐

db RethinkDB

db H2 / h2 / h2 cluster / cubrid

db nosql redis / Redis Sentinel

db Oracle OLTP OLAP / apache kylin / druid

db vfp / Visual FoxPro

db base database

db db2_monitorTool IBM Rational Performace Tester

db dba experience

db db2 v8.2

db db2 v9.7 / 9.8

db db2 base / instance database tablespace container

db oracle books

db SQL Server error_list

db db2 soft

db db2 books

db sql montior

db oracle error_list

db oracle

db db2 dba

db db2 tools

最近访客更多访客>>