服务器上有多个数据库.
我已经启动了一个数据库test,使用sqlplus system/manger@test也是可以登录上去,但是,使用show parameters db_name时,显示却是
NAME
TYPE
------------------------------------ --------------
VALUE
------------------------------
db_name
string
ssmdb
不知道那位大侠可以解决这个问题,不胜感激.
what's the value of the db_name in ur parameter file.
and do u sure which db u are connected to by service string 'test'.
run
>select * from v$database;
to confirm the database
$ sqlplus system/manager@test
SQL*Plus: Release 8.1.6.0.0 - Production on 星期一 7月 8 13:55:59 2002
(c) Copyright 1999 Oracle Corporation.All rights reserved.
连接到:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> select name from v$database
2;
NAME
------------------
SSMDB
很奇怪!