Solved

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

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

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 120
ID: 34902877
SQL> connect / as sysdba
0
 

Author Comment

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

Thx!
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
UTL_FILE invalid file operation 5 45
VMware Fault Tolerance between remote sites 2 52
No IP Address Assigned to VM 10 83
Moving VMs from ESX 4.1 to ESXI 6 1 18
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.
When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

685 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