To: [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 6:53 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SYSDBA privilege with ORAPWD utility
Hello Chetan
I think that you need to have administrator permission on the NT domain
to
be able to logon as sysdba.
Yechiel
[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 6:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SYSDBA privilege with ORAPWD utility
Chetan,
The NAME of the password file should be:
PWD{sidname}.ORA
To: Multiple recipients of list ORACLE-L
Subject: Re: SYSDBA privilege with ORAPWD utility
Hello Chetan
I think that you need to have administrator permission on the NT domain to
be able to logon as sysdba.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients
To: Multiple recipients of list ORACLE-L
Subject: Re: SYSDBA privilege with ORAPWD utility
Hello Chetan
I think that you need to have administrator permission on the NT domain to
be able to logon as sysdba.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
Hei...
Is your sys password is correctly mentioned while logon?.
I tested your case, it's doing proper, while i misspelled sys pwd,
it thrown the error as u mentioned...
HTH,
Nirmal
-Original Message-
Sent: Wednesday, September 11, 2002 3:38 PM
To: Multiple recipients of list
not working.
What can be possible cause of this ?
Thx, Chetan
--
From: Yechiel Adar[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 6:53 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SYSDBA privilege with ORAPWD
Hello Chetan
I think that you need to have administrator permission on the NT domain to
be able to logon as sysdba.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 2:38 PM
Hi List ,
I have
Hi,
'TRUE' is not a valid value for REMOTE_LOGIN_PASSWORDFILE.
Try:
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
See:http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch1155.htm#6449
for more details.
-Mark
On Wed, 2002-09-11 at 08:38, Chindarkar,Chetan wrote:
Hi Chetan,
May be the SID is not set correctly.
SET ORACLE_SID = yoursid
-Message d'origine-
De : Chindarkar,Chetan [mailto:[EMAIL PROTECTED]]
Envoyé : mercredi 11 septembre 2002 12:38
À : Multiple recipients of list ORACLE-L
Objet : SYSDBA privilege with ORAPWD utility
Hi
Chetan,
The NAME of the password file should be:
PWD{sidname}.ORA.
For example, if your Oracle Sid name is SB815, your password file should be
named
PWDSB815.ORA
On NT boxes, upper/lower case of the file name does not matter.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
shouldn't it be exclusive i.s.o true for the remote_login_passwordfile?
Jack
Chindarkar,Chetan
i dont think the name shud be PWD(sid).ora.
AFAIK it can be any name. Am i wrong?
Naveen
-Original Message-
Sent: Wednesday, September 11, 2002 6:58 PM
To: Multiple recipients of list ORACLE-L
Chetan,
The NAME of the password file should be:
PWD{sidname}.ORA.
For example, if your
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE (not true)
naveen
-Original Message-
Sent: Wednesday, September 11, 2002 6:08 PM
To: Multiple recipients of list ORACLE-L
Hi List ,
I have Oracle 8.1.5 server on Win 2K machine.
When I try to connect as SYSDBA using SYS account from a remote
You might be right - why else would we have the option to name the file
anything we want.
I can't find NT docs at the moment, so I can't verify this.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, September 11, 2002 10:38 AM
To: Multiple recipients of
[EMAIL PROTECTED] wrote:
the acoount that i used was oracle account.
primary group is oinstall and secondary is dba.
try chenging it to the other way around. with DBA as the primary and
oinstall as the secondary. that's the way i always set the oracle
account up and i've had no problems
To: Multiple recipients of list ORACLE-L
Subject: Re: sysdba
the acoount that i used was oracle account.
primary group is oinstall and secondary is dba.
bill thater wrote:
[EMAIL PROTECTED] wrote:
i am using Solaris 8.
connect / as sysdba the result is i dont have
and i'm just curious what does paPIpapupapePO means ?
--
From: paPIpapupapePO[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, April 04, 2002 6:43 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: sysdba
the acoount
rious what does "" means ?
> --
> From: paPIpapupapePO[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, April
04, 2002 6:43 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: sysdba
>
>
> the acoount that i used
i got the cause of this problem
when i set the TWO_TASK env variable
to $ORACLE_SID, this error appears
but when I unset the said variable,
I can already login as sysdba of
simply starts my instance through
the dbstart script which uses the
current user. (connect / as sysdba)
bill thater
i am using Solaris 8.
connect / as sysdba the result is i dont have privileges.
thank you in advance.
[EMAIL PROTECTED] wrote:
What is your operating system, database level, and what command are you
issuing? Is this the first time this has occurred?
David A. Barbour
Oracle DBA, OCP
AISD
Well, with all this info I can't imagine that someone will
not be able to help you.
-Original Message-
paPIpapupapePO
Sent: Tuesday, April 02, 2002 9:18 PM
To: Multiple recipients of list ORACLE-L
i cant connect as sysdba.
ORA-01031 - insuffecient privileges.
can anybody help me?
--
Did you create an externally identified account? Did you
grant sysdba this priv? Only sys has it automagically.
Everyone else needs to have it granted.
-Original Message-
paPIpapupapePO
Sent: Wednesday, April 03, 2002 12:08 AM
To: Multiple recipients of list ORACLE-L
i am using
[EMAIL PROTECTED] wrote:
i am using Solaris 8.
connect / as sysdba the result is i dont have privileges.
thank you in advance.
are you starting sqlplus from an account in the DBA group?
is the DBA group the primary group?
--
--
Bill Shrek Thater ORACLE DBA
Message-
From: paPIpapupapePO [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: sysdba
i am using Solaris 8.
connect / as sysdba the result is i dont have privileges.
thank you in advance.
[EMAIL PROTECTED
Subject: Re: sysdba
i am using Solaris 8.
connect / as sysdba the result is i dont have privileges.
thank you in advance.
[EMAIL PROTECTED] wrote:
What is your operating system, database level, and what command are you
issuing? Is this the first time this has occurred
the acoount that i used was oracle account.
primary group is oinstall and secondary is dba.
bill thater wrote:
[EMAIL PROTECTED] wrote:
i am using Solaris 8.
connect / as sysdba the result is i dont have privileges.
thank you in advance.
are you starting sqlplus from an account in
210-581-6217
-Original Message-
From: paPIpapupapePO [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: sysdba
i am using Solaris 8.
connect / as sysdba the result is i dont have privileges.
thank you in advance
Hi,
You have password file, and you are not register in it.
either you register yourself in this password file (orapwd) or don't use that password
file RE..PAS.. = none.
Sinardy
-Original Message-
Sent: 03 April 2002 13:18
To: Multiple recipients of list ORACLE-L
i cant connect as
I had taken the same error sometime ago and droped and recreated password
file .that is a solution 1 . Try logging as internal and change the password
of sys . then try again .
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
What is your operating system, database level, and what command are you
issuing? Is this the first time this has occurred?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Title: RE: sysdba and sysoper
SYSDBA can do more than start/stop the database. It has a lot more functionality that sysoper (Operator mode) which is normally used for basic database functions such as start/stop.
SYSOPER privilege allows operations such as:
Instance startup, mount database
31 matches
Mail list logo