如何在oracle上连接新创建的数据库？(How to connect to newly created database on oracle ?)

 我在我的本地机器上使用oracle。 我正在使用预定义的数据库和模式，如scott of sysdba。 昨天我已经通过数据库配置助手创建了一个数据库，现在我试图通过sysdba输入用户名和密码来连接到那个新数据库; 
 
SQL> connect username/password
 
 但它给了 
 
 
 
 错误：ORA-01017：用户名/密码无效; 登录被拒绝; 
 
 
 警告：您不再与ORACLE连接。 
 
 
 我试过在谷歌搜索，有很多答案但没有任何相关性，并没有解决我的问题。 
 
 
 
 我如何连接到我创建的数据库？ 
 
 
 我是否必须通过sysdba为该数据库创建用户？ 
 
 
 我是否必须授予访问该数据库的任何权限？ 
 
 
 请告诉我，如果我错过了什么，因为我是oracle上的菜鸟。 我需要连接到该数据库，因为我必须在该数据库中创建表空间和用户。 
 
 
 
 PS：我已经调查过了，新创建的数据库存在于sysdba数据库中。 
 

I am using oracle on my local machine. i was using predefined databases and schema like scott of sysdba. yesterday i have created a database through database configuration assistant, now i am trying to connect to that new database by putting username and password through sysdba like;
 
SQL> connect username/password
 
but it gives
 
 
 
ERROR: ORA-01017: invalid username/password; logon denied;
 
 
WARNING: you are no longer connected to ORACLE.
 
 
i have tried searching on google and there are many answers but nothing is relevant and didn't solve my problem. 
 
 
 
how can i connect to that database which i have created ?
 
 
do i have to make a user for that database through sysdba ?
 
 
do i have to grant any privileges to access that database ?
 
 
please do tell me if i'm missing something as i am a noob on oracle. i need to connect to that database because i have to make tablespaces and users in that database.
 
 
 
PS: I have investigated, and the newly created database exist in sysdba databases.
 

原文：https://stackoverflow.com/questions/45219939