Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Oracle 11g new install - unable to login
Answers
-
Thanks for posting this!
I had exactly the same problem (and was able to log in with SYS and my default install password). -
Having same problem, still can't log in. Why doesn't the install give you an ID to log in with? All it does is ask you for a password, not associated w/ any login ID. Very confusing. And people wonder why everyone's going SQL Server!
-
hi,
how can i get the installation executable for enterprise edition 11g. can i find just the compressed setup.exe and when that is executed ,it extract itself and create a database? can this be done?. -
Hi,
I am very new to Oracle.
I read this thread but getting more confused.
I completed installation of "Oracle 11g R2" on windows vista platform successfully.
During install, installer asked for default password to use, which I entered.
Then it asked if I wish for it to create a default database and I choose yes to that option so it created a sample database for me (its name = edm).
Now my question is how do I login to this database using SQLPLUS?
1) What will be my user name to login?? Admin, or admin, or root or sysadmin?
This is so confusing - other database installer "clearly" specifies the username for the database !
Can anyone tell what should be my next step?
My requirement is very simple - I just need to create a database, then a database-user so that I can connect to it using JDBC.
Can anyone suggest the simplest steps to achieve this in "Oracle 11g r2" ?
Thanks in advance.
=======================
DON'T WORRY FOUND THE SOLUTION.
I have to first create/allocate a tablespace (as sysdba)
Then create an user and GRANT all necessary permissions to that tabe space (as sysdba)
Then create few tables in that table space
Then login that user and access tables.
Oracle has so million no. of tutorials but none of those are really useful for the beginners.
Edited by: user8828023 on Jan 29, 2011 4:08 PM
Edited by: user8828023 on Jan 29, 2011 4:10 PM
Edited by: user8828023 on Jan 29, 2011 6:10 PM -
Hi,
Oracle Database is a good product even if the first approach can seem a bit frustrating. In this case I think you just miss the information though : the default users are specified in some screen at install time.
I suggest you try :sqlplus system/password_you_chose
orsqlplus "/ as sysdba"
Best regards
Phil -
I have a similar problem. I just installed 11gr2.02. I am able to log in to sys through sqlplus with the password I created during install, but when I try to log in to Enterprise Manager with the same user password it gives me an authentication error. I specified "as sysdba" in both cases.
-
Hi,
same problem,
no answer?
Georg -
I had the same problem; the installer prompts you for a password but gives no indication as to what username to use when logging into Enterprise Manager for the first time. Seems like a major oversight, doesn't it? Anyway, I stumbled upon the answer just a few minutes ago. Not sure why this has proved so difficult to succinctly answer in this thread until now, but here is what worked for me:
User Name: SYS
Password: <the password you entered during the installation process>
Connect As: SYSDBA
Hope this helps. This is one of many items I've come across lately (as I try to learn Oracle 11g and OBIEE) that, IMO, is much more difficult than it needs to be.
Chris -
Thank you so much Chris, I found this information very helpful and was able to access Enterprise Manager for Oracle 11g, however I am still unable to access SQL Plus, I have tried all the suggestions in the thread and no luck so far. I am prompted to enter a username and password and the password I entered during setup has not work however it did work to access Enterprise Manager.
Thanks for your help.
TechyM -
853497 wrote:It is surprisingly difficult to debug that which cannot be seen. Please open a command prompt and attempt to connect with sqlplus. Then use the handy "copy" capability to copy the entire session and paste that into your next post here.
Thank you so much Chris, I found this information very helpful and was able to access Enterprise Manager for Oracle 11g, however I am still unable to access SQL Plus, I have tried all the suggestions in the thread and no luck so far. I am prompted to enter a username and password and the password I entered during setup has not work however it did work to access Enterprise Manager.
Thanks for your help.
TechyM
This discussion has been closed.