下载安装 oracle 11g

安装路径： c:\app\Administrator\product\11.2.0\dbhome_1
安装时要设置的密码需要记住。

安装plsql 免安装版到 c:\plsql

修改dbhome_1\NETWORK\ADMIN下面listener.ora

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = ORCL)
    )
  )
ADR_BASE_LISTENER = C:\app\Administrator

修改dbhome_1\NETWORK\ADMIN下面tnsnames.ora

tns = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) )

设置环境变量

NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK

TNS_ADMIN = C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN

重启OracleOraDb11g_home1TNSListener和OracleServiceORCL服务

使用plsql连接，输入用户名、密码，选择tns选项，选择normal,连接。

• 用户名：SYS
• 密码：安装时设置的密码
• 数据：tns
• 连接：SYSDBA

新建数据库

使用Database Configuration Assistant