Solved

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

Posted on 2011-02-15
3
1,684 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 76

Accepted Solution

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

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

Author Comment

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

Thx!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

856 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