Connect to Oracle 11g using PL-SQL developer and SQL PLus
Date: Mon, 14 Oct 2013 06:47:20 -0700 (PDT)
Message-ID: <39485f3f-5f68-4f79-b4ee-770e6b6cbcab_at_googlegroups.com>
I have just installed Oracle 11g Personal Edition on my PC today. When I open PL-SqL developer, it asks me for four things:-
- Username (oracle never asked for this in the installation)
- Password (xyz, that I myself set)
- Database ( Oracle created a starter database with the name of db_2 and global db with the name "orcl")
- Connect as: Normal
What do I enter in the 4 required fields. The password field is obvious and I would probably enter db_2 in the database name. But what should i enter in the username? Oracle 11g never asked for the username during the installation.
The same issue persist with SQL PLus. When I open it, a command line window opens and it asks a username and password. I tried a lot of combinations but none of them worked.
Is there a default combination of username and password for SQL plus?
Please, help me since I am installing Oracle for the the first time. Also, tell me any good tutorial on how to create/set the tnsnames.ora file that I have heard about and setting the environment variables.
Which has to be done first? The tnsnames.ora file setting and env variable setting or do I connect first?
Regards, Received on Mon Oct 14 2013 - 15:47:20 CEST