oracle 9i sql plus 无法登录

[xuan.ye]

sp2-0306:无效选项
用法：conn[ECT][Logon][AS{SYSDBA|SYSOPEN}]
其中<logon>::=<username>[/<password>][@<connect_string>]/

其中F:\oracle\ora92\network\admin的ora配置如下

# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

STEVEN_STEVEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yexuan)(PORT = 1521))
)
(CONNECT_DATA =
(SID = steven)
(SERVER = DEDICATED)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yexuan)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yexuan)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DB)
)
)

[flg_inwind]

使用NETMGR测试本地服务名配置无误
sqlplus username/password@本地服务名

[lixuewen518]

建议查看数据库服务是不是启动了,是不是加载了实例.

[xuan.ye]

[Quote=引用 1 楼 flg_inwind 的回复:]
使用NETMGR测试本地服务名配置无误
sqlplus username/password@本地服务名
[/Quote]
不知道怎么用，我是新手

[xuan.ye]

[Quote=引用 2 楼 lixuewen518 的回复:]
建议查看数据库服务是不是启动了,是不是加载了实例.
[/Quote]
oracleorahome92TNlistener 已启动
OracleServiceDB 已启动

[hongqi162]

你登陆不了的错误信息呢

[hongqi162]

用户名:sys
口令:password
主机字符串:db as sysdba

[lixuewen518]

贴出错误信息.

[xuan.ye]

[Quote=引用 6 楼 hongqi162 的回复:]
用户名:sys
口令:password
主机字符串:db as sysdba
[/Quote]
我用plsql工具建立了一个 用户： yx 密码：123 建了一个表 q
然后用你的方法连接成功，thanks