Oracle 10g SQL 加用户名密码+主机字符串未知
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/22270373/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle 10g SQL plus username, password + Host string unkown
提问by user2590541
I have just installed Oracle 10g database and also oracle developer suit, which is installed as DevSuiteHome1 in my computer. I could not use SQL plus because I dont know the exact username, password and host string to connect. During installation I did not ask to enter any username & password. Then what would be the username,password + host string? Help me out of this.
我刚刚安装了 Oracle 10g 数据库和 oracle 开发人员套件,它在我的计算机中安装为 DevSuiteHome1。我无法使用 SQL plus,因为我不知道要连接的确切用户名、密码和主机字符串。在安装过程中,我没有要求输入任何用户名和密码。那么用户名,密码+主机字符串是什么?帮我解决这个问题。
采纳答案by wish can help
Retrieve detail of database service name/host string:
检索数据库服务名称/主机字符串的详细信息:
- Open cmd.
- Issue command
lsnrctl status
. - Usually, only one database service name will be listed. good Luck!
- 打开cmd。
- 发出命令
lsnrctl status
。 - 通常,只会列出一个数据库服务名称。祝你好运!
回答by Vimal
you can connect many user:- scott which password is tiger hr which password is hr
您可以连接多个用户:- scott 哪个密码是tiger hr 哪个密码是hr
you can connect also sys user. For connect sys user, only write in user name:- / as sysdba
您也可以连接 sys 用户。对于connect sys用户,只写用户名:- / as sysdba