Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle 11g cannot login to SQL plus - setting up database for vcenter server.

Posted on 2011-02-15
3
Medium Priority
?
1,706 Views
Last Modified: 2012-05-11
Hey all,

  First off I am a Oracle noob.  So the answer to this question might be very simple.  I am setting up a test vmware environment; I installed Oracle 11g and went through all of the defaults.  After the installation vmware's instructions says to log into sql plus.  That is where I am stuck.  I am attempting to login to sql plus as SYS or administrator I get the following:


SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 15 15:57:15 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: administrator
Enter password:
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]


Any ideas?  Your help is appreciated!

Robert
0
Comment
Question by:wyrickits
3 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 34902868
Logged in as the software installer
At the username prompt: / as sysdba

0
 
LVL 124
ID: 34902877
SQL> connect / as sysdba
0
 

Author Comment

by:wyrickits
ID: 34902890
Logging in as: / as sysdba worked!

Thx!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question