oracle 安装Oracle 11g后如何登录scot账号
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9862364/
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
How to login to the scot account after installing Oracle 11g
提问by Shashika
I have successfully installed Oracle 11g R2 version. I don't have good knowledge about Oracle database. SQL developer needs a Database Connection.
我已经成功安装了 Oracle 11g R2 版本。我对 Oracle 数据库不太了解。SQL 开发人员需要一个数据库连接。
I don't know how to create this. Searching through the Internet, I found this page
我不知道如何创建这个。通过互联网搜索，我找到了这个页面
According to this site, there is HR user and HR database. Also there is some predefined tables. What are these tables and other things. Does Oracle comes with this default database? Can't I create database with different name? And how to create this database connection in right way?
根据这个网站，有人力资源用户和人力资源数据库。还有一些预定义的表。这些表和其他东西是什么。Oracle 是否带有此默认数据库？我不能创建不同名称的数据库吗？以及如何以正确的方式创建此数据库连接？
Hope you guys can help me to overcome this problem. These tables are not my creations
希望你们能帮我解决这个问题。这些桌子不是我的作品
回答by Gaurav Soni
I think you have not unlocked your scott user accountwhile installation,please follow the steps below to unlock you scott account .
我认为您scott user account在安装时尚未解锁，请按照以下步骤解锁您的 scott 帐户。
When you started installing oracle ,it asked for global database nameand database passwordthat password is used for the sys system sysman dbsnmp account.
当您开始安装 oracle 时，它会要求您输入密码，global database name并且database password该密码用于sys system sysman dbsnmp account.
SQL> conn user/password;
SQL> conn scott/tiger;
SQL> conn 用户/密码；
SQL> conn 斯科特/老虎；
Error message is displayed: the account is locked.
显示错误信息：帐户被锁定。
Try to login as
"system"- passSQL> conn system/password;Unlock "scott"
SQL> alter user scott account unlock;Can change
"tiger":SQL> alter user scott identified by tiger;- SQL> conn scott/tiger; -Success
尝试以
"system"- pass登录SQL> conn system/password;解锁“斯科特”
SQL> alter user scott account unlock;可以改变
"tiger"：SQL> alter user scott identified by tiger;- SQL> conn 斯科特/老虎；-成功
scott accountis locked in 11g due to security thinking,
scott account出于安全考虑被锁定在11g，
Now you can type Connection Name :ORCL,username:Scott,password:tigerto login
现在您可以输入Connection Name :ORCL, username:Scott,password:tiger登录
