I am brand new to Oracle (well, I learned SQL in college on an oracle system but that was just for learning SQL).
I've downloaded and installed from the following: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index-092322.html
I then downloaded and installed Oracle's "SQL Developer"
The installation settings were setup to use my Window's authentication (no username and password), I set the database name to "oracledb" and give it a password. I was able to login just fine on https://localhost:5501/em with the username "sys" and the password previously mentioned.
When I try to connect through SQL Developer I get the ORA-12505 error message: TNS:listener does not currently know of SID given in connect descriptor. The SID I gave it was "oracledb"
I went into windows services and made sure that the listener service with the SID I provided was started/running.
I went to youtube for help and ended up changing my Connection Type within SQL Developer's new connection screen, changing the role to SYSDBA and used SID "orcl"
For some reason, I was able to connect that way. Why the different SID than what I wanted it called??????
Lastly, when I actually connect to the database, it has hundreds of tables I never asked to be created, thousands of triggers and stored procedures, etc. etc. I wanted a nice clean BLANK database to start developing in. How do I achieve this?
Is there a good video tutorial perhaps? Or a beginners step-by-step guide for installing Oracle "the correct way" on your machine and connecting to it?
Thanks in advance for your help!