LSNRCTL> stat
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 22-10月-2008 23:51:29
Uptime 0 days 0 hr. 1 min. 43 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /opt/oracle/product/9.2.0.4/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SYBASE)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SYBASE)(PORT=8080))(Presentation=HTT
P)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SYBASE)(PORT=2100))(Presentation=FTP
)(Session=RAW))
Services Summary...
Service "ora9idb" has 1 instance(s).
Instance "ora9idb", status READY, has 1 handler(s) for this service...
Service "ora9idbXDB" has 1 instance(s).
Instance "ora9idb", status READY, has 1 handler(s) for this service...
The command completed successfully
数据库是安装在as4上的,数据库可以正常启动
监听启动感觉正常,监听信息如上,在客户端用net manger 创建服务名连接测试失,第一次发帖,请各位大侠帮忙,先谢谢了
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 22-10月-2008 23:51:29
Uptime 0 days 0 hr. 1 min. 43 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /opt/oracle/product/9.2.0.4/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SYBASE)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SYBASE)(PORT=8080))(Presentation=HTT
P)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SYBASE)(PORT=2100))(Presentation=FTP
)(Session=RAW))
Services Summary...
Service "ora9idb" has 1 instance(s).
Instance "ora9idb", status READY, has 1 handler(s) for this service...
Service "ora9idbXDB" has 1 instance(s).
Instance "ora9idb", status READY, has 1 handler(s) for this service...
The command completed successfully
数据库是安装在as4上的,数据库可以正常启动
监听启动感觉正常,监听信息如上,在客户端用net manger 创建服务名连接测试失,第一次发帖,请各位大侠帮忙,先谢谢了
export ORACLE_SID=ora9idb
sqlplus /nolog
conn / as sysdba试试.
反之,检查监听服务。
==========================================
用户名和密码正确吗?提示的错误信息是什么?
C:\Documents and Settings\Administrator>tnsping 192.168.1.77TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 24-10月-2
008 15:19:11Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
D:\oracle\ora92\network\admin\sqlnet.ora已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=192.168.1.
77))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.77)(PORT=1521)))
OK(10毫秒)按照1151仁兄的说法,应该是客户端的问题客户端的配置信息如下:
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.IDC114 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.77)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9idb)
)
)
客户端连接别的数据库是正常的,连接ora9idb数据库的信息错误信息是:
初始化首次测试请使用用户名: scott, 口令: tiger
正在尝试使用以下用户 ID 连接:scott
测试没有成功。
ORA-01017: invalid username/password; logon denied在输入的字段中可能有错误,
或者服务器连接未就绪。
export ORACLE_SID=ora9idb已经加在.bash_profile中。linux下执行:
export ORACLE_SID=ora9idb
sqlplus /nolog
conn / as sysdba
测试是连接的
2\如果可以请使用tnsping数据库地址或服务名;如果不可以请检查是不是配置问题,
也就是tnsnames.ora文件里的配置是否正确.
1\检查从客户端使用ping命令是否有异常. 从客户端ping服务器是正常的,linux是用VMware装的,所以客户端和服务器是在一台机器上,网络上没有问题
2\如果可以请使用tnsping数据库地址或服务名;如果不可以请检查是不是配置问题, 从可苦短tnsping数据库和服务名都是正常的就是在测试服务的时候显示:
初始化首次测试请使用用户名: scott, 口令: tiger
正在尝试使用以下用户 ID 连接:scott
测试没有成功。
ORA-01017: invalid username/password; logon denied
谢谢,请大家帮忙