Set aside sql developer and focus on learning the DB part of things. You need to know how to perform the basic DBA operations: startup, shutdown, listener control (start/stop/status), etc. You can connect as SYS just by using: '/ as sysdba' in sql*plus on the machine you installed the DB on. Oracle client software is installed by default when you do a basic DB install. See chapters 17 and 18 in the 12c concepts docĤ. To connect as SCOTT you have to connect to the PDB not the CDB. The CDB and PDBs are DIFFERENT databases even though they are part of the SAME multitenant umbrella. With 12c there are ONLY common users in the CDB/root. With 12c you don't use SID you use service names.ģ.
You can totally avoid dealing with that for now by using 11g instead - there is MUCH more information (tutorials, books, etc) available for beginners.Ģ. You won't be much progress with it if you don't know what 'multitenant' means and how it is different from previous architectures. Oracle 12c uses a new multi-tenant architecture. That may be because there are too many components you are not up to speed with yet.ġ. No other way to say it but directly: you are trying to do too much at much and getting overwhelmed. I have the Database name that I have recreated and SID to connect but still getting 1017 error message. 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 spent all day just trying to install SQL developer and database 12c to create a database connection in SQL developer I am a personal user for oracle SQL developer who wants to learn SQL from oracle.
0 kommentar(er)
