纯生手学生党提问啦,大牛们帮帮忙
纯新手学生党提问啦,大牛们帮帮忙
信管专业的大二学生一枚,想往数据库方面走走,但是学校还没开这门课,就自己鼓捣鼓捣。但是ORACLE这个配置太蛋疼了。。。。我都不知道到底安装好没有,好像OK,但是PLSQL怎么都连不上,请各位帮帮忙
listener的配置文件
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator
tnsnames的配置文件
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
TP1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tp1)
)
)
LISTENER_TP1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
ORCL1 =
(DESCRIPTION =
(ADDRESS =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
一头雾水,希望大伙看看指正,谢谢
------解决思路----------------------
安装完成后是不是没创建数据库实例呢?
cmd窗口中
1、tnsping ip地址:1521/服务名
tnsping 192.168.191.1:1521/orcl
能通的话服务应该就是好的
2、tnsping tns别名
tnsping ORCL
能通的话tns配置应该就是好的
------解决思路----------------------
有内容出来吗? 没有报错,就是安装成功了。
自己建一个表空间,建一个用户,然后先创建oracle的对象,然后查询
------解决思路----------------------
能查出来结果说明数据库安装成功了
本机访问数据库是不需要启动监听的
通过客户端访问就需要启动监听
信管专业的大二学生一枚,想往数据库方面走走,但是学校还没开这门课,就自己鼓捣鼓捣。但是ORACLE这个配置太蛋疼了。。。。我都不知道到底安装好没有,好像OK,但是PLSQL怎么都连不上,请各位帮帮忙
listener的配置文件
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator
tnsnames的配置文件
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
TP1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tp1)
)
)
LISTENER_TP1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
ORCL1 =
(DESCRIPTION =
(ADDRESS =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.191.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
一头雾水,希望大伙看看指正,谢谢
------解决思路----------------------
安装完成后是不是没创建数据库实例呢?
cmd窗口中
1、tnsping ip地址:1521/服务名
tnsping 192.168.191.1:1521/orcl
能通的话服务应该就是好的
2、tnsping tns别名
tnsping ORCL
能通的话tns配置应该就是好的
------解决思路----------------------
有内容出来吗? 没有报错,就是安装成功了。
自己建一个表空间,建一个用户,然后先创建oracle的对象,然后查询
------解决思路----------------------
能查出来结果说明数据库安装成功了
本机访问数据库是不需要启动监听的
通过客户端访问就需要启动监听