oracle登录遇到的问题 我安装oracle时自带一个orcl数据库,我又创建了一个test数据库,我在登录时总是登录默认的orcl数据库,怎么才能登录test数据库呢?? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 环境变量设一下。把ORACLE_SID设成你想要登录的数据库名 设置oracle_sid为test 或者把orcl 数据库用dbca删除吧。 不是啊,我是想在网页上登录的时候选择数据库 http://localhost:5500/em 默认登录orcl有人说把5500改为5501就行了..... 郁闷了,连是连到第二个数据库了,可是让我输入身份证明,我用我设置的账户sys 密码system登录怎么不成功呢,总是说错误 1.方法1: oracle_sid = test2>.tnsnames.org中配置一个test的tns 登录时 conn 用户名/密码@TEST 你的test数据库的sid是什么 登录时host String 就写那个sid oracle 10g 有两个数据库orcl和test,我登陆orcl没有问题,怎么登陆test时说让我启动数据库或还原,启动时出错,数据库错误 Io 异常: The Network Adapter could not establish the connection tnsnames.org中有TEST1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 389)) (ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test1) ) )LISTENER_TEST1 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 389)) (ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 1521)) )ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 把ORACLE_SID改为你的test库的sid 把ORACLE_SID改为你的test库的sid oracle存储过程和函数示例 创建物化视图日志 oracle 9i 10g 11g 双机热备份 為什麼別名不能用在where 中??????? exists和执行计划问题,高手请进 关于回滚段的参数修改问题,请进帮忙 有peoplesoft编程资料的提供一下,多谢 commint和rollback的问题? oracle怎样建库?不用助手,手工建库,求建库脚本 oracle远程数据连接问题 sql语句文本时间之间的转换 alter tablespace test01.dbf begin backup;
把ORACLE_SID设成你想要登录的数据库名
把orcl 数据库用dbca删除吧。
有人说把5500改为5501就行了.....
登录怎么不成功呢,总是说错误
Io 异常: The Network Adapter could not establish the connection
tnsnames.org中有
TEST1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 389))
(ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test1)
)
)
LISTENER_TEST1 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 389))
(ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 1521))
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = liupeng)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)