Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within Oracle/OAS Search Coderanch
Advance search Google search
Register / Login
thread boost book review grid granny polymorphism advertise on coderanch
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
thread boost advertise on coderanch meaningless drivel building better world book book review grid
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

SQL Plus

 
Anand Ko
Ranch Hand
Posts: 79
posted 20 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Installed Oracle10g.
I could login to OEM with SYS as SYSDBA.
Default orcl DB is also installed.
When i open SQLPLUS, it prompts for user/pass and connection string.
I have provided sys/<pass> - orcl. I get the following error

ORA:0107: login as SYSDBA

But when i connect using cmd prompt, it gets connected.
i.e connect sys/<pass> as SYSDBA on the cmd line.

Can any one help me -

Anand<br />SCJP 1.4, SCWCD 1.4, SCEA 5.0(1/3)

 
Jeanne Boyarsky
author & internet detective
Posts: 42160
937
I like...
Eclipse IDE VI Editor Java
posted 20 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Anand,
When you type in the connect string by hand are you including the "as SYSDBA" part? The system user needs to connect as the dba role.

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...