Can this be done a want to connect through ODBC, for a php web page
Can this be done if so how do I declare the username, password and db string
Currently i do
$username = name
$password = password
$dsn=dsn
Any help appreciated
Cheers
Craig,
did you try:
$username = SYS
$password = syspassword AS SYSDBA
$dsn=dsn
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 19, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Can this be done a want to connect through ODBC
]' [EMAIL PROTECTED]
CC: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: sys as sysdba with password through ODBC
Date: Fri, 19 Dec 2003 10:36:39 -0500
Craig,
did you try:
$username = SYS
$password = syspassword AS SYSDBA
$dsn=dsn
Tom Mercadante
Oracle Certified Professional
-Original Message
Craig,
the correct syntax is
sys/[EMAIL PROTECTED] as sysdba. So you might try:
$username = SYS
$password = syspassword
$dsn=dsn AS SYSDBA
PS - can you tell I'm guessing? :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 19, 2003 10:50 AM
Oh yes
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: sys as sysdba with password through ODBC
Date: Fri, 19 Dec 2003 07:39:26 -0800
Craig,
did you try:
$username = SYS
$password = syspassword
Title: Connect sys/[EMAIL PROTECTED] as sysdba E-Business suite
Hi All,
I have seen some weird behaviour and must have been searching in the wrong places.
When logging in to a 9i RAC environment using the syntax sys/[EMAIL PROTECTED] as sysdba it works fine at the primary instance
Title: Connect sys/[EMAIL PROTECTED] as sysdba & E-Business suite
Hi!
Are you sure that you have correct password file in
second instance?
Maybe you're using wrong password (or do not have
pwdfile) buf on first instance you just belong to os DBA group, thus you can log
on using what
.
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, September 12, 2003 11:29 AM
Hi All,
I have seen some weird behaviour and must have been searching in the wrong
places.
When logging in to a 9i RAC environment using the syntax
sys/[EMAIL PROTECTED] as sysdba
Hi Tanel
I did not mention that w/o the connect string it works
Try to log on as sysdba with bogus password (without connect string), you
should be able to log on anyway, because you're in os dba group.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel
Title: Message
You
should set remote_os_authent and remote_os_rolesto true, otherwise
RMAN will not be able to connect to the remote isntance as
sysdba. On the other hand, you might want to reconsider it, because that
would open your instance wide to the various forms of
network
attacks
You are not right. SYSDBA is authenticated through the operating system. You
must have a DBA role
to be a SYSDBA, be it local or remote. To allow authentication of a remote
user as a sysdba, you
must explicitely tell oracle to do so. Dictionary accessibility has nothing
to do
Hi!
No, o7_dictionary_accessibility controls whether SYS user can log on to
database without SYSDBA privilege (starting from 9.2). If it's false, sys
always has to connect as sysdba.
Mladen, don't you think that if you have created passwordfiles for each
instance in RAC and set
You are not right. SYSDBA is authenticated through the operating system.
You
must have a DBA role
to be a SYSDBA, be it local or remote. To allow authentication of a remote
You probably meant SYSDBA privilege to be a SYSDBA? DBA role is irrelevant
here.
Tanel.
--
Please see the official
of list ORACLE-L
Subject: Re: Connect sys/[EMAIL PROTECTED] as sysdba
E-Business suite
You are not right. SYSDBA is authenticated through the operating
system.
You
must have a DBA role
to be a SYSDBA, be it local or remote. To allow authentication of a
remote
You probably meant
Hi
I don't have 9i to test, but I believe you might be able to set
O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then you should be able to connect
as sys without specifying sysdba.
This might be suitable for the upgrade - certainly test it out on a test system first.
Regarding
Robo wrote:
Hi all,
I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There
are 3 boxes for username, password and database.
Does anyone know if/how is it possible?
Yes, you could do this by creating an ON-LOGON trigger. But this is a
really, really bad idea.
Scott Lamb
--
Title: RE: Forms - as sysdba
What
about granting sysdba priviledge to yourself? then you could do everything sys
could do!
my
0.02
Luis
-Original Message-From: Suhen Pather
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21,
2003 6:19 PMTo: Multiple recipients of list
Hi Bruce,
this is EXACTLY what I needed, great!
Many thanks
=RP=
Hi
I don't have 9i to test, but I believe you might be able to
set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then
you should be able to connect as sys without specifying sysdba.
This might be suitable
Title: Forms - as sysdba
Hi all,
I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database.
I tried a lot of combinations, eg:
Username: sys as sysdba
Password: sys
Database: db
sys/[EMAIL PROTECTED] as sysdba
sys/[EMAIL
As this is Forms 6i, which was around long before
connect '/ as sysdba' was required, Forms does
not know about the new syntax.
Try checking on MetaLink for a patch.
Jared
On Thu, 2003-08-21 at 01:54, Robo wrote:
Hi all,
I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys
Title: Forms - as sysdba
Try if it works if you put sys/sys as sysdba to
forms username prompt? (without quotes)
But why do you want to connect as sysdba
anyway?
Tanel.
- Original Message -
From:
Robo
To: Multiple recipients of list ORACLE-L
Sent: Thursday, August
schema.
If you are querying standard tables, OEM provides good views for most of
what
you need and the group here can provide better SQL scripts
anyway.
Hemant
At 07:29 AM 21-08-03 -0800, you wrote:
Try if it
works if you put sys/sys as sysdba to forms username prompt? (without
quotes)
But why do you
Title: RE: Forms - as sysdba
One thing to bear in mind for forms development
is Oracle does not support connecting as / (OPS$).
Suhen
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Friday, 22 August 2003 1:02 AM
To: Multiple recipients of list ORACLE-L
\form.fmx "sys/[EMAIL PROTECTED] "\/'as
sysdba'"
=RP=
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Hemant K ChitaleSent: Thursday, August 21, 2003 5:54
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Forms - as sysdb
Title: Message
Robo
You
can connect as
ifrun60.EXE "C:\...\..\logon2.fmx"
Regards
Suhen
-Original Message-From: Robo
[mailto:[EMAIL PROTECTED]Sent: Friday, 22 August 2003 4:39
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Forms - as sysdba
I MU
bigtex:oraadm 7% rman target / as sysdba
Argument Value Description
-
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog
You do not need as sysdba when connecting in RMAN:
d:\oraclerman target /
Recovery Manager: Release 9.2.0.3.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: T03B (DBID=2558667088)
RMAN shutdown
using target database controlfile
You always connect as a sysdba privileged user when using RMAN ... so just
issue
rman target /
(or rman target / nocatalog if you're not using a catalog)
(Wow! I answered an RMAN question ... and I knew nothing about it 12 months
ago)
Ciao
Fuzzy
:-)
-Original Message-
From
Title: RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS
Try rman target / (No quotes and no as sysdba)
-Original Message-
From: Roger Xu [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 27, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L
Subject: WHY IT DOES NOT WORK
(Wow! I answered an RMAN question ... and I knew nothing about it 12
months ago)
That is awsome, isn't it!! Congrats!
BTW, if you are using 9i and RMAN there is no need for the nocatalog
command.
RF
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert -
Ah, thanks. Didn't try anything with that Friday.
Jared
On Sunday 09 March 2003 22:58, Alex Feinstein wrote:
Jared,
Look at Note 60634.1 on MetaLink.
OSAUTH_PREFIX_DOMAIN = TRUE is default for 8.1 and 9.
Alex.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Ran into an interesting problem with this on Friday.
We've put together a new SAP server that is not yet attached
to a network, and so are using local account names rather than
the normal domain accounts until we're ready to put it on the
network. ( We're replacing another server, and this one
Jared,
Look at Note 60634.1 on MetaLink.
OSAUTH_PREFIX_DOMAIN = TRUE is default for 8.1 and 9.
Alex.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, March 09, 2003 10:08 PM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
I have got this working now; I am able to connect remotely
using connect sys/[EMAIL PROTECTED] as sysdba and able to
do remote imports with sys as the userid.
Thanks to the four J's (Jacques,Jared,Julie,Jeremiah) for their
suggestions.
The solution seems to be dropping and re-creating
to connect remotely
using connect sys/[EMAIL PROTECTED] as sysdba and able to
do remote imports with sys as the userid.
Thanks to the four J's (Jacques,Jared,Julie,Jeremiah) for their
suggestions.
The solution seems to be dropping and re-creating the orapwd file.
I had changed the sys password
got this working now; I am able to connect remotely
using connect sys/[EMAIL PROTECTED] as sysdba and able to
do remote imports with sys as the userid.
Thanks to the four J's (Jacques,Jared,Julie,Jeremiah) for their
suggestions.
The solution seems to be dropping and re-creating the orapwd file
Title: RE: remota / as sysdba
I'm glad that worked for you, but I've never had to recreate the password file after a password change. (In my little part of the world we have password files on databases ranging from Oracle versions 8.0 to 9.2 on both Windows NT/2000 and Solaris
Hello,
env: Oracle 9.2.0.2 on Solaris 9.
Does anyone know of a way to use the / as sysdba logon remotely?
(to a separate Oracle instance on a separate machine)
Other remote user logons work OK.
I have tried several variations from sqlplus, such as
[EMAIL PROTECTED]connect /@DWQ as sysdba
.
Does anyone know of a way to use the / as sysdba logon remotely?
(to a separate Oracle instance on a separate machine)
Other remote user logons work OK.
I have tried several variations from sqlplus, such as
[EMAIL PROTECTED]connect /@DWQ as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning
Title: RE: remote / as sysdba
As far as I know, it works like this:
You will need to set init parameter REMOTE_LOGIN_PASSWORD_FILE to EXCLUSIVE.
You then can sign on as SYS remotely, or as another user remotely if the other user has SYSDBA. See the users that have SYSDBA or SYSOPER in v
Bill,
You can't do that. If you try to, you will eventually see ORA-1997
12:18:58 rsysdevdb.radisys.com - [EMAIL PROTECTED] SQL grant sysdba to
ops$jkstill;
grant sysdba to ops$jkstill
*
ERROR at line 1:
ORA-01997: GRANT failed: user 'OPS$JKSTILL' is identified externally
12:19:07
in $ORACLE_HOME/dbs
with the correct unix perms.
So I connect as sys to the local instance:
[EMAIL PROTECTED]connect sys/syspassword as sysdba
Connected.
[EMAIL PROTECTED]sho user
USER is SYS
But when trying to connect to the remote instance:
[EMAIL PROTECTED]connect sys/[EMAIL PROTECTED] as sysdba
ERROR
Title: RE: remote / as sysdba
If you want to do
connect sys/[EMAIL PROTECTED] as sysdba
then the database corresponding to TNS alias DWQ has to have remote_login_passwordfile EXCLUSIVE, and it needs to have a password file.
It is not clear to me from your e-mail if remote database DWQ has
You could logon that way if Oracle allowed it.
sqlplus /@dv03 as sysdba
two different linux boxes, same OS account name on both boxes.
While the previous will result in an ORA-1997 ( sorry, you can't remotely
logon as SYSDBA ), the following works just fine:
sqlplus /@dv03
Jared
Jacques
The remote instance must have remote_login_passwordfile=EXCLUSIVE
Any local instances, whether or not you are logged into them, are
unimportant.
In this case:
[EMAIL PROTECTED]connect sys/[EMAIL PROTECTED] as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
I would tend
Title: RE: remote / as sysdba
I forgot that you could do that. I never liked remote os authentication (is it still possible to easily fool a client into thinking you're someone else?), and I would like it even less if it allowed you to sign on as SYSDBA without a password. The best security
]
cc:
Subject:RE: remote / as sysdba
I forgot that you could do that. I never liked remote os authentication
(is it still possible to easily fool a client into thinking you're someone
else?), and I would like it even less if it allowed you to sign on as
SYSDBA without a password
Title: RE: remote / as sysdba
Thank you for the information. I thought the security issues were more fundamental. For example if my database has remote os authentication (with prefix OPS$), and I know that there is a user called OPS$JSTILL, then I can change the Windows Registry on my client
e have ORACLE 8.1.7 on NT server and I login as user wirh
administrator privilege. I tried to connect / as sysdba and got
insufficient prvilege. The procedure are:
1. on DOS window
2. sqlplus /nolog
3. connect / as sysdba
ORA-001031 insufficient privileges
I have been recreate the password
-Original Message-
Sent: Friday, February 14, 2003 2:31 PM
To: Multiple recipients of list ORACLE-L
e have ORACLE 8.1.7 on NT server and I login as user wirh
administrator privilege. I tried to connect / as sysdba and got
insufficient prvilege. The procedure are:
1. on DOS window
2. sqlplus
Having administrator privileges (actually being a member of
Administrators group) is not enough.
If you want to connect / as sysdba, you should be a member of ORA_DBA
group.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
snapshots if symmetric/advanced replication is not installed)
CONNECT / AS SYSDBA;
update obj$ set status=5 where type#=29 and owner#!=0;
commit;
...
Excuse me for long quotation.
Why first connect internal and second connect / as sysdba? For a
multiplicity only ?
If it's not, what's
What is difference between connect internal and connect / as sysdba in
sqlplus ?
Michael Ivanov
åy«±ç
ê~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+2)!j)H½©è¼DNh¯jz/µ×«j»
jТ·#^·
+'«¾'³Î|ç9Óa¶Úÿ
+0}«\Ü¢d8'è®x1¨¥x%ËZÜn,¶)à±êïǬND0åDÊ«±é_~º¶¬¨¥x%ËlzwZCY²Æ zÚËFº»j×·'(z
'connect internal' is no longer supported in 9i+
'connect / as sysdba' is the replacement.
--- Mikhail Ivanov [EMAIL PROTECTED] wrote:
What is difference between connect internal and connect / as
sysdba in
sqlplus ?
__
Do you Yahoo!?
New DSL
Sorry for the late post.
I did some research some time ago and found that when connecting as sysdba
you are working under user SYS no matter what user you used to logon.
So, connect system as sysdba and you are sys. problem solved.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
[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
Hey ,
Im able to connect as SYSDBA from all other users (for e.g. WIP, SYSTEM)
except SYS. Can anyone pls advise on this.
Thanks, 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 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
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 machine it
says ORA-01017: invalid username/password; logon denied. Then I created a
password file using ORAPWD utility and granted SYS and WIP (a newly created
schema
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 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 machine it
says ORA-01017: invalid username/password; logon denied. Then I created a
password file using ORAPWD utility and granted SYS and WIP (a newly created
schema
:
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 machine it
says ORA-01017: invalid username/password; logon denied. Then I created a
password file using ORAPWD utility and granted SYS and WIP (a newly created
schema
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
-Original Message-
Sent: Wednesday, September 11, 2002 8:38 AM
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 machine it
says ORA-01017: invalid username/password; logon
/External/MEY/NL)
Sent by: Subject: SYSDBA privilege with
ORAPWD utility
[EMAIL PROTECTED
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 machine it
says ORA-01017: invalid username/password; logon denied. Then I created a
password file using ORAPWD utility and granted SYS and WIP (a newly
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
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 machine it
says ORA-01017: invalid username/password; logon denied. Then I created a
password file using ORAPWD utility and granted SYS and WIP
From where did you download it? Maybe there exist new version of OLEDB
provider for ADO?
Alex Hillman
-Original Message-
Bruce (CALBBAY)
Sent: Monday, June 10, 2002 11:08 PM
To: Multiple recipients of list ORACLE-L
Someone in the last few days requested info on connecting as sysdba
:08 PM
Someone in the last few days requested info on connecting as sysdba from VB.
I deleted the email at the time but I just downloaded the ODBC driver
version 8.1.7.6.0 and found the following:
NEW FEATURES
ODBC 8.1.7.6.0
Added support for connection syntax username/password as sysdba
Someone in the last few days requested info on connecting as sysdba from VB.
I deleted the email at the time but I just downloaded the ODBC driver version
8.1.7.6.0 and found the following:
NEW FEATURES
ODBC 8.1.7.6.0
Added support for connection syntax username/password as sysdba and
username
From my experience there is no way that you can use a parameter to connect
as SYSDBA. I was reading that you are to connect as INTERNAL if you want to
connect as SYSDBA. But we all know that is a bad idea and impossible in 9i
anyway.
If you find away could you let me know.
Thanks
Jay
I am trying to find out how to connect as SYSDBA using ADO in Visual Basic.
Did not see any mention of sysdba in the doc.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex Hillman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
Hi list
When the system account needs the SYSDBA role granted , i simply connect as
internal and grant that role to system.
But the connect internal is obsolete in oracle 9i, so how do i grant the
sysdba role to other accounts ??
thanks
vr. gr.
g.g. kor
rdw ict groningen
--
Please see
with / as sysdba and
from there grant sysdba to the user
NT :
Since it is not possible to relink the code on NT the group is hard
coded to ORA_DBA on NT/W2K
When member of this group you can connect with / as sysdba and
from there grant sysdba to the user
VMS :
Here it is a system logical
we have W2K platform
so if i understand correctly i put my NT account in the ORA_DBA group, then
connect / as sysdba and grant the rights.
-Oorspronkelijk bericht-
Van: Peter Gram [SMTP:[EMAIL PROTECTED]]
Verzonden:woensdag 15 mei 2002 12:49
Aan: Multiple recipients of list
of list ORACLE-L
we have W2K platform
so if i understand correctly i put my NT account in the ORA_DBA group, then
connect / as sysdba and grant the rights.
-Oorspronkelijk bericht-
Van: Peter Gram [SMTP:[EMAIL PROTECTED]]
Verzonden:woensdag 15 mei 2002 12:49
Aan: Multiple recipients
NT account in the ORA_DBA group, thenconnect / as sysdba and grant the rights.
-Oorspronkelijk bericht-Van: Peter Gram [SMTP:[EMAIL PROTECTED]]Verzonden: woensdag 15 mei 2002 12:49Aan: Multiple recipients of list ORACLE-LOnderwerp: Re: grant sysdba rightsThe answer depends on what O/S you a
[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
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
as sysdba.
ORA-01031 - insuffecient privileges.
can anybody help me?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: paPIpapupapePO
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
i cant connect as sysdba.
ORA-01031 - insuffecient privileges.
can anybody help me?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: paPIpapupapePO
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its DBA.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 8:18 AM
i cant connect as sysdba
:
Sent by: Subject: sysdba
[EMAIL PROTECTED
Hi Guys ,
I need some info here ,
What exactly is difference between sysdba and
sysoper roles and how can I set up osdba osoper roles on unix ( i mean what os
permissions does it need ).
-ak
Title: Connect as sysdba on 9i
Hi!
I have a question concerning connect sys as sydba on 9i.
When I open sqlplus and connect as sysdba (I'm logged in as the Unix oracle user):
sqlplus sys as sysdba
Oracle asks for a password. Even if I type in the wrong password, I am
Title: Connect as sysdba on 9i
Try:
sqlplus "/ as sysdba"
I suspect the /
indicates current OS user and if you belong to the SYSDBA or SYSOPER groups then
you will be connected. SYS is probably not a member of these
groups.
I haven't tested
this.
-Original Message-Fr
Hi
Do'it the follow steps :
sqlplus /nolog
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jan 22 15:23:12 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL connect sys as sysdba
Enter password:
Connected to an idle instance.
Regards
Rudi
Original Message
Von
1 - 100 of 105 matches
Mail list logo