Try "sqlplus / as sysdba" in command line.
David Xiang
Canadian Depository For Securities Ltd.
85 Richmond St. West.
Toronto, Ontario
M5H 2C9
|---------+-------------------------------------------------------->
| | "Shergill Gurmohan " |
| | <oracledba-ezmlmshield-x9213523.[Email Address Removed] | azyDBA.com> |
| | |
| | 07/05/2005 02:12 PM |
| | |
|---------+-------------------------------------------------------->
>----------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: RE: Conn / as sysdba |
>----------------------------------------------------------------------------------------------|
I can agree with Daniel. Your operating system user has got to be in dba
group. Check that out.
Gurmohan
www.freemath.info
-----Original Message-----
From: Daniel Woodruff/EmCare
[mailto:oracledba-ezmlmshield-x78115785.[Email address protected]
Sent: Tuesday, July 05, 2005 12:28 PM
To: LazyDBA Discussion
Subject: Re: Conn / as sysdba
Make sure you are in the user group "dba" on the linux box. If you are not
you cannot use / as sysdba;
"jsf"
<oracledba-ezmlms
hield-x66898237.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
07/05/2005 01:43
PM Subject
Conn / as sysdba
Hi there,
2 questions:
1) I'm logging in linux as the 'oracle' user but when trying to 'connect /
as sysdba' it gives me 'insufficient privileges' error...
All environment variables (ORACLE_SID, ORACLE_HOME, etc) are set, and the
param REMOTE_LOGIN_PASSWORDFILE = exclusive.
Shouldn't I be able to login using '/ as sysdba' wher logged in OS with
the 'oracle' user? The manager said 'conn / as sysdba' used to work, but
another DBA did something wrong and it doesn't work anymore... Any ideas
about what to check and how could I fix it?
2) This should be easy but I don't know how to connect as sysdba without
issuing 'sqlplus /nolog' -> 'conn / as sysdba'
Ex:
c:\> sqlplus
LOGIN: <what do I put here to login as sysdba?>
PASSWORD: <what do I put here to login as sysdba?>
I hope you can help me. Thanks so much!
Juliano Freitas
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
Oracle LazyDBA home page