急问,我用 SQL plus 登陆 Oracle 10g 时提示 ORA-12154:TNS:无法解析指定的连接标识符这该如何解决?用户名称:我填写 sys口令:我填写 sys 对应的密码主机字符串:demo as sysdba (demoOracle 10g 的 sid 名)(注:我现在只是会安装数据库,一时兴起安装好了后又卸载,再装上就这样了,重装系统又装还是不行)登陆 scott 和 system登陆 没有任何问题!我不知道哪里有问题,还请哪位熟悉的朋友告知,谢了!
解决方案 »
- 请教一个查询语句,上火啊 !感谢大家帮忙!
- 想问一下,怎样创建Oracle的数据库模式?谢谢!
- 兄弟们,看看这个存储过程都有些什么语法错误,谢谢.
- sql server 如何连接 Oralce 数据库
- 请教:Oracle10g/Pro*C 对c99规范中变参宏的支持
- 请问,oracle导出整个数据库应该怎么做
- Order by的怪问题
- 救救我如何使用UTL_FILE包
- 这个SQL简单吗?为什么我没有编译对呀!!!
- 关于给oracle用户授权的问题
- 求助存储过程
- Linux 32bit 11.2.0.1 ,所有参数都是默认的,在服务器上本身跑很快,但是别的机子连过去访问会很慢。CPU\内存占用率都不高
你可以在口令框中输入密码后,然后加上一个空格,接着输入as sysdba就可以登录
或者在口令框中输入as sydba,系统会提示你输入密码,然后再输入密码登录2、如果你要使用主机字符串,你需要:
1)配置一个连接串,在%ORACLE_HOME%\network\admin\tnsnames.ora文件中增加
你的连接串名称 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 你的机器名或者IP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 你的SID)
)
)2)需要启动监听服务,你可以在windows的服务中启动,或者手动启动
C:\>lsnrctl start3)在上面的“主机字符串”框中输入你的连接串名称,加空格再加上as sysdba就可以登录了
然后 disconnect
然后再 connect sys/密码 as sysdba
第一个方法有效监听程序
第二个方法,
1)配置一个连接串.......
demo =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MICROSOF-1136DD)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo)
)
)
2)手动启动监听C:\>lsnrctl start 最后显示监听程序不支持服务
输入连接串后还是进不了,显示ORA-12154:TNS:无法解析指定的连接标识符
我也不知道用主机字符串做什么,只是觉得原来能正常登陆,但现在不可以了
tangren前辈 我就是在你说的那个文件里 加了一段,也不知道是不是符合要求
现在该怎么弄?回复二楼 你的方法也可以 谢谢!
# The following is the general syntax for any entry in
# a tnsnames.ora file. There could be several such entries
# tailored to the user's needs.
DEMO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MICROSOF-1136DD)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DEMO)
)
)
<alias>= [ (DESCRIPTION_LIST = # Optional depending on whether u have
# one or more descriptions
# If there is just one description, unnecessary ]
(DESCRIPTION=
[ (SDU=2048) ] # Optional, defaults to 2048
# Can take values between 512 and 32K
[ (ADDRESS_LIST= # Optional depending on whether u have
# one or more addresses
# If there is just one address, unnecessary ]
(ADDRESS=
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=tcp)
(HOST=<hostname>)
(PORT=<portnumber (1521 is a standard port used)>)
)
[ (ADDRESS=
(PROTOCOL=ipc)
(KEY=<ipckey (PNPKEY is a standard key used)>)
)
]
[ (ADDRESS=
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=decnet)
(NODE=<nodename>)
(OBJECT=<objectname>)
)
]
... # More addresses
[ ) ] # Optional depending on whether ADDRESS_LIST is used or not
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
[ (SOURCE_ROUTE=yes) ]
)
(DESCRIPTION=
[ (SDU=2048) ] # Optional, defaults to 2048
# Can take values between 512 and 32K
[ (ADDRESS_LIST= ] # Optional depending on whether u have more
# than one address or not
# If there is just one address, unnecessary
(ADDRESS
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=tcp)
(HOST=<hostname>)
(PORT=<portnumber (1521 is a standard port used)>)
)
[ (ADDRESS=
(PROTOCOL=ipc)
(KEY=<ipckey (PNPKEY is a standard key used)>)
)
]
... # More addresses
[ ) ] # Optional depending on whether ADDRESS_LIST
# is being used
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
[ (SOURCE_ROUTE=yes) ]
)
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
... # More descriptions
[ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not
(注:我现在已经装了2个数据库了)