1 person found this helpful
When you created your database, you should have been prompted for passwords on SYS and SYSTEM. Did you forget them already?
If you're connecting as SYS, you have to set the connection type from 'NORMAL' to 'AS SYSDBA' in the drop-down.
I have made up an ID and Password.
I don't like to share it here b/c they are same as most of my personal accounts but the Database Name is 'home' and SID is 'home'
The installation process should have given me the passwords?
I am confused. I am soorry
and Connection Type is 'Basic' There is no 'Normal'
I changed the role as 'SYSDBA' but same error msg.
1 person found this helpful
um, yeah - don't share your passwords
But if you're getting an invalid username/pwd, it's because you aren't using the right combo there.
You said you installed 12c and you created a database. When you create a database you get a 'god' account, SYS. What password did you define for SYS?
Try to go in with that.
This isn't a SQL Developer question, it's an Oracle connectivity one, but I'll try to help you if I can.
I guess I don't remember the 'god' account 'SYS' but whatever/whenever I had spots to put password and confirm password, I made them all the same as other ones.
The first time when I did them, they were different, so I them all the same this time.
Thank you for all your help.
But is there way for me to reset this or something?
We make a free virtual machine appliance for you to learn on. It's already setup and ready to go. All of the passwords are even 'oracle' so you can't forget them
I am a personal user for oracle SQL developer who wants to learn SQL from oracle.
I spent all day just trying to install SQL developer and database 12c to create a database connection in SQL developer
Until now, I have uninstalled all java programs in my computer and deleted everything that is related to java, including temp files and reinstalled java SDK 7 and SQL developer and database 12c.
I have the Database name that I have recreated and SID to connect but still getting 1017 error message.
No other way to say it but directly: you are trying to do too much at much and getting overwhelmed. That may be because there are too many components you are not up to speed with yet.
1. Oracle 12c uses a new multi-tenant architecture. You won't be much progress with it if you don't know what 'multitenant' means and how it is different from previous architectures. You can totally avoid dealing with that for now by using 11g instead - there is MUCH more information (tutorials, books, etc) available for beginners.
2. With 12c you don't use SID; you use service names.
3. With 12c there are ONLY common users in the CDB/root. Local users only exist in a PDB. The CDB and PDBs are DIFFERENT databases even though they are part of the SAME multitenant umbrella. User SCOTT is in a PDB not the CDB. To connect as SCOTT you have to connect to the PDB not the CDB. See chapters 17 and 18 in the 12c concepts doc
4. Oracle client software is installed by default when you do a basic DB install. That means you already have sql*plus.
5. You can connect as SYS just by using: '/ as sysdba' in sql*plus on the machine you installed the DB on. You don't need the password.
6. You need to know how to perform the basic DBA operations: startup, shutdown, listener control (start/stop/status), etc.
Progress is made one step at a time. Start with the DB. Set aside sql developer and focus on learning the DB part of things.
If you have DB installation questions or issues post them in the Database General forum
Once you can perform those basic DB admin operations and have confirmed that yoiur DB is installed and running properly then return to the task of working with sql developer. I suggest using Oracle 11g until you know the DB basics.
When asking questions (especially installation/configuration) in any forum provide FULL name/version info for all components: OS, DB, sql developer, java, etc.
Always SHOW us what you do; don't just tell us.