oracle 11g ORA-12514问题
用sqlplus登陆数据库时,会出现12514的问题。
sqlplus sys@test as sysdba输入密码后出现ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor,上网查询许多未果。包括官网,希望有经验的朋友指教
当启动lisener后再创建新的数据库时,可正常登录。重启后,正常开启lisener,就会出现如上问题。
查看listener.ora内容为:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HUAANserv)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /opt/oracle
查看status信息为:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HUAANserv)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 31-MAR-2010 10:58:28
Uptime 0 days 0 hr. 8 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/11.2/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/HUAANserv/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HUAANserv)(PORT=1521)))
(D
相关问答:
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
查了一天的blob,还是没理解到,我想在VC下存取二进制的文件,使用的是oo4o,照着帮助文档上面的写了写入数据库的代码,还是没写对,错误提示是this operation is not permitted on a empty LOB,这是什么意思啊?照 ......
假设table01 中有 以下资料
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
常用电话
而我们要得到以下的OUTPUT (或是各种其他的output)
0001,TOM
0002,JOHN
......
oracle 11g 安装 01092 错误,
日志信息:
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
本人现在学oracle 算是刚刚入一半门 以后还要学java 各位大侠oracle好入手还是java好入手啊 以后那个方面发展会好些
,我暂时有个想法想好好学习一下数据库以后往这方便发展,毕竟数据库跟新换代没有java那么快,不 ......