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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 01:17:54  来源:igfitidea点击:

Oracle 10g SQL plus username, password + Host string unkown

sqloracleoracle10g

提问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. enter image description here

我刚刚安装了 Oracle 10g 数据库和 oracle 开发人员套件,它在我的计算机中安装为 DevSuiteHome1。我无法使用 SQL plus,因为我不知道要连接的确切用户名、密码和主机字符串。在安装过程中,我没有要求输入任何用户名和密码。那么用户名,密码+主机字符串是什么?帮我解决这个问题。 在此处输入图片说明

采纳答案by wish can help

Retrieve detail of database service name/host string:

检索数据库服务名称/主机字符串的详细信息:

  1. Open cmd.
  2. Issue command lsnrctl status.
  3. Usually, only one database service name will be listed. good Luck!
  1. 打开cmd。
  2. 发出命令lsnrctl status
  3. 通常,只会列出一个数据库服务名称。祝你好运!

回答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