windows安装OracleXE112 64与PL/SQL连接详解

来源：互联网发布：视频教学软件编辑：程序博客网时间：2024/06/05 09:02

Windows安装64位的OracleXE112G过程，并设置PL/SQL配置连接XE成功。

###################################################################################################

###### 系统平台： windows10

###### 准备：<1>OracleXE112G 安装包可以在百度云盘下载: http://pan.baidu.com/s/1dEIXh7N

###### <2>oracle客户端安装与PL/SQL （也可以选择不安装oracle连接PL/SQL,一种更绿色的方法）

####### 客户端安装可以参考: http://chinaxxren.iteye.com/blog/964851/

####### 本人oracle安装路径 [F:\oracle11G\app\oracle\product\11.2.0]

####### oracle客户端[F:\orcle11\product\11.2.0\client_1]

###################################################################################################

1.0 安装好oracle服务器与客户端。【略】

安装完成之后，打开cmd，输入services.msc查看window服务。看oracle相关服务是否成功安装与启动：

2.0 打开oracle中sql窗口，进行连接测试:

（1）连接数据库测试：[安装完成之后，XE实例会开启]  SQL> connect as sysdba  Enter user-name: sys  Enter password:  Connected.   (2)使用ip地址来测试连接数据库.[/后为安装时输入的密码]  SQL>connect sys/oracle @localhost:1521 as sysdba  Connected.    (3)使用tns连接数据库.  SQL>connect sys /oracle @XE as sysdba  Connected.

3.0 oracle xe数据库实例的开启与关闭:

都是在进入“SQL>”环境下执行：连接进入oracle实例：C:\Users\li>sqlplusSQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 8 23:20:06 2016Copyright (c) 1982, 2014, Oracle.  All rights reserved.Enter user-name: systemEnter password:Connected to:Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit ProductionSQL>--------当有特殊情况时候，是可以是用sqlplus /nolog 进行登录C:\Users\li>sqlplus /nologSQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 8 23:22:00 2016Copyright (c) 1982, 2014, Oracle.  All rights reserved.SQL>oracle 实例的关闭(两种方式)： <1>shutdown immediate                    <2>shutdown normaloracle 实例的开启：startup mount.

当使用sqlplus输入用户名与密码进行连接时候出现如下错误:

C:\Users\li>sqlplusSQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 8 22:15:17 2016Copyright (c) 1982, 2014, Oracle.  All rights reserved.Enter user-name: systemEnter password:ERROR:ORA-01033: ORACLE initialization or shutdown in progressProcess ID: 0Session ID: 0 Serial number: 0

可以按照如下命令进行操作：【oracle为我的oracle登录密码】

SQL> connect sys/oracle as sysdbaConnected.SQL> startup mountORA-01081: cannot start already-running ORACLE - shut it down firstSQL> shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> alter database open  2  ;alter database open*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 505112Session ID: 91 Serial number: 11SQL> shutdown normalORA-01012: not logged onSQL> connect sys/oracle as sysdbaConnected to an idle instance.SQL> shutdown normalORA-01034: ORACLE not availableORA-27101: shared memory realm does not existSQL> startup mountORACLE instance started.Total System Global Area 1068937216 bytesFixed Size                  2260048 bytesVariable Size             616563632 bytesDatabase Buffers          444596224 bytesRedo Buffers                5517312 bytesDatabase mounted.SQL> alter database open;Database altered.

若是出现错误：ora-01033:initalization or shutdown in porgress .可以参考：http://www.cnblogs.com/wangsaiming/p/3688141.html

4.0 配置PL/SQL的tnsnames.ora文件：配置新安装的oracle xe。

本机是在oracle客户端路径为：[F:\orcle11\product\11.2.0\client_1\Network\Admin\tnsnames.ora]

XE =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = XE)    )  )

5.0 登录PL/SQL

用户名: hr口令:oracle数据库:XE连接为:Normal

5.1 若是出现如下错误："ora-28000 - the account is locked." 可参考:http://jingyan.baidu.com/article/48b37f8d1ec3fd1a6464883a.html

执行如下命令：

SQL> conn /as sysdbaConnected.SQL> desc dba_profiles; Name                                      Null?    Type ----------------------------------------- -------- ---------------------------- PROFILE                                   NOT NULL VARCHAR2(30) RESOURCE_NAME                             NOT NULL VARCHAR2(32) RESOURCE_TYPE                                      VARCHAR2(8) LIMIT                                              VARCHAR2(40)SQL> select resource_name,limit from dba_profiles where resource_name='FAILED_LOGIN_ATTEMPTS';RESOURCE_NAME                    LIMIT-------------------------------- ----------------------------------------FAILED_LOGIN_ATTEMPTS            10SQL> alter profile default limit failed_login_attempts unlimited;Profile altered.SQL>  select resource_name,limit from dba_profiles where resource_name='FAILED_LOGIN_ATTEMPTS';RESOURCE_NAME                    LIMIT-------------------------------- ----------------------------------------FAILED_LOGIN_ATTEMPTS            UNLIMITEDSQL> alter user hr account unlock;User altered.

5.2若是解除锁定后登录，出现“用户名密码错误**”等信息，可以在命令行sql中登录sysdba进行username查看:

若是没有hr用户，则可以创建hr和密码。

SQL> connect /as sysdbaConnected.SQL> select username from dba_users where username='hr';no rows selectedSQL> alter user hr identified by oracle;User altered.

至此，大致弄完啦..............话说小伙伴们对oracle家的东西要多留意啊，要有耐心去倒腾........>_<

0 0