创建local Oracle Server

1.下载安装

\下载OracleXE并安装，建议安装在D盘。

安装过程中会询问sys，sysdba的密码，请输入并记住。

2.配置

2.1 编辑...oracle\product\11.2.0\server\network\ADMIN目录下的2个文件

1）listener.ora

 1 SID_LIST_LISTENER =
 2   (SID_LIST =
 3     (SID_DESC =
 4       (SID_NAME = PLSExtProc)
 5       (ORACLE_HOME = D:\programfiles\OracleXE\app\oracle\product\11.2.0\server)
 6       (PROGRAM = extproc)
 7     )
 8     (SID_DESC =
 9       (SID_NAME = CLRExtProc)
10       (ORACLE_HOME = D:\programfiles\OracleXE\app\oracle\product\11.2.0\server)
11       (PROGRAM = extproc)
12     )
13     (SID_DESC =
14       (GLOBAL_DBNAME = XE)
15       (ORACLE_HOME = D:\programfiles\OracleXE\app\oracle\product\11.2.0\server)
16       (SID_NAME = XE)
17     )
18   )
19 LISTENER =
20   (DESCRIPTION_LIST =
21     (DESCRIPTION =
22       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
23       (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.17.91)(PORT = 1521))
24     )
25   )
26 DEFAULT_SERVICE_LISTENER = (XE)

2）tnsnames.ora

 1 XE =
 2   (DESCRIPTION =
 3     (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.17.91)(PORT = 1521))
 4     (CONNECT_DATA =
 5       (SERVER = DEDICATED)
 6       (SID = XE)
 7     )
 8   )
 9 EXTPROC_CONNECTION_DATA =
10   (DESCRIPTION =
11     (ADDRESS_LIST =
12       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
13     )
14     (CONNECT_DATA =
15       (SID = PLSExtProc)
16       (PRESENTATION = RO)
17     )
18   )
19 ORACLR_CONNECTION_DATA = 
20   (DESCRIPTION = 
21     (ADDRESS_LIST = 
22       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
23     ) 
24     (CONNECT_DATA = 
25       (SID = CLRExtProc) 
26       (PRESENTATION = RO) 
27     ) 
28   )

2.2 测试连接

在SQL命令行中输入：connect as sysdba

用户名：sys

口令：安装oracle时输入的口令

3.创建Schema

1）在SQL命令行中输入：connect sys/【口令】:【配置的本地IP】:1521 as sysdba

2）创建一个my用户，密码也是my：create user my identified by my;

3）授权：grant connect,resource,dba to my;

4）测试：Connect my/my@172.19.17.91:1521;

 

posted on 2016-04-21 10:48  没事瞎折腾  阅读(201)  评论(0)    收藏  举报

导航