View Single Post

   
  #8 (permalink)  
Old 04-08-2008, 10:26 AM
joel-garry@home.com
 
Posts: n/a
Default Re: connect / as sysdba


Raj wrote:
> Yes, the DB runs on my laptop and i am trying to connect from the same
> machine. I installed it as myself and i can logon as
> connect sys/sys as sysdba
> but connect / as sysdba does not work.
>


Seeing as how the "as sysdba" syntax ignores the username and password,
I'm sort of wondering what you are really doing:

C:\Documents and Settings\joelg>sqlplus "sdflj/boobobo as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Beta on Tue May 9 14:08:34 2006

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


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL>

First of all, what version are you on?
How did you create the password file? Are you absolutely sure you
spelled the filename correctly? *pwd* instead of *pw* will blow you
off.
Have you tried remote_login_passwordfile=none? The parameters changed
from 9i to 10g. Are you conversant with the differences between pfile
and spfile?
What are the _exact_ commands you are entering?
What happens when you try it in quotes from the shell, like
sqlplus "/ as sysdba"
How are you setting up your environment? Do you have an environment
chooser?

Please remember to briefly quote what you are replying to, as in a
newsgroup your replies won't necessarily follow the posts.

jg
--
@home.com is bogus.
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 1
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 1
You might need to remove punctuation or the keywords AND, OR, NOT.

Reply With Quote