Re: SYSDBA privilege with ORAPWD utility
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 recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, September 13, 2002 10:28 AM > 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 <[EMAIL PROTECTED]> > > Sent: Wednesday, September 11, 2002 2:38 PM > > > > > > > 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) the SYSDBA privilege. I also ensured that > > REMOTE_LOGIN_PASSWORDFILE > > > is set to TRUE, but still I can not connect as SYSDBA. > > > > > > Following are the steps which I took. > > > > > > Step 1. Created a password file as followed : > > > > > > D:\Oracle\Ora815\BIN>cd ..\dbs > > > D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i > > > entries=30 > > > > > > Step 2. Grant SYS user the SYSDBA privilege by the following method > > > > > > D:\Oracle\Ora815\DBS>svrmgrl > > > > > > Oracle Server Manager Release 3.1.5.0.0 - Production > > > > > > (c) Copyright 1997, Oracle Corporation. All Rights Reserved. > > > > > > Oracle8i Release 8.1.5.0.0 - Production > > > With the Java option > > > PL/SQL Release 8.1.5.0.0 - Production > > > > > > SVRMGR> connect internal > > > Password: > > > Connected. > > > SVRMGR> grant SYSDBA to SYS; > > > Statement processed. > > > > > > SVRMGR> select * from v$pwfile_users ; > > > USERNAME SYSDB SYSOP > > > -- - - > > > INTERNAL TRUE TRUE > > > SYSTRUE TRUE > > > 2 rows selected. > > > > > > Pls help me if possible. > > > > > > Thanks in advance. > > > > > > Chetan > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Chindarkar,Chetan > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yechiel Adar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information
RE: SYSDBA privilege with ORAPWD utility
Check for these things... 1. REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE in initSID.ora 2. ORA_SID_PWFILE = location_of_ur_passwordfile in the WINDOWS REGISTRY of the server. 3. Check the SYS password, or from some other USER do a 'ALTER USER sys IDENTIFIED BY ...' and then try connecting I hope this works out. Most of the times we miss a very small and obvious thing. Go systematically. Regards Naveen -Original Message- Sent: Friday, September 13, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Yechiel , I have administrator permission on the NT domain; but its still 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 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 <[EMAIL PROTECTED]> > Sent: Wednesday, September 11, 2002 2:38 PM > > > > 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) the SYSDBA privilege. I also ensured that > REMOTE_LOGIN_PASSWORDFILE > > is set to TRUE, but still I can not connect as SYSDBA. > > > > Following are the steps which I took. > > > > Step 1. Created a password file as followed : > > > > D:\Oracle\Ora815\BIN>cd ..\dbs > > D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i > > entries=30 > > > > Step 2. Grant SYS user the SYSDBA privilege by the following method > > > > D:\Oracle\Ora815\DBS>svrmgrl > > > > Oracle Server Manager Release 3.1.5.0.0 - Production > > > > (c) Copyright 1997, Oracle Corporation. All Rights Reserved. > > > > Oracle8i Release 8.1.5.0.0 - Production > > With the Java option > > PL/SQL Release 8.1.5.0.0 - Production > > > > SVRMGR> connect internal > > Password: > > Connected. > > SVRMGR> grant SYSDBA to SYS; > > Statement processed. > > > > SVRMGR> select * from v$pwfile_users ; > > USERNAME SYSDB SYSOP > > -- - - > > INTERNAL TRUE TRUE > > SYSTRUE TRUE > > 2 rows selected. > > > > Pls help me if possible. > > > > Thanks in advance. > > > > Chetan > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Chindarkar,Chetan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
RE: SYSDBA privilege with ORAPWD utility
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 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) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BIN>cd ..\dbs D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBS>svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect internal Password: Connected. SVRMGR> grant SYSDBA to SYS; Statement processed. SVRMGR> select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SYSDBA privilege with ORAPWD utility
Yechiel , I have administrator permission on the NT domain; but its still 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 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 <[EMAIL PROTECTED]> > Sent: Wednesday, September 11, 2002 2:38 PM > > > > 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) the SYSDBA privilege. I also ensured that > REMOTE_LOGIN_PASSWORDFILE > > is set to TRUE, but still I can not connect as SYSDBA. > > > > Following are the steps which I took. > > > > Step 1. Created a password file as followed : > > > > D:\Oracle\Ora815\BIN>cd ..\dbs > > D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i > > entries=30 > > > > Step 2. Grant SYS user the SYSDBA privilege by the following method > > > > D:\Oracle\Ora815\DBS>svrmgrl > > > > Oracle Server Manager Release 3.1.5.0.0 - Production > > > > (c) Copyright 1997, Oracle Corporation. All Rights Reserved. > > > > Oracle8i Release 8.1.5.0.0 - Production > > With the Java option > > PL/SQL Release 8.1.5.0.0 - Production > > > > SVRMGR> connect internal > > Password: > > Connected. > > SVRMGR> grant SYSDBA to SYS; > > Statement processed. > > > > SVRMGR> select * from v$pwfile_users ; > > USERNAME SYSDB SYSOP > > -- - - > > INTERNAL TRUE TRUE > > SYSTRUE TRUE > > 2 rows selected. > > > > Pls help me if possible. > > > > Thanks in advance. > > > > Chetan > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Chindarkar,Chetan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SYSDBA privilege with ORAPWD utility
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 <[EMAIL PROTECTED]> > Sent: Wednesday, September 11, 2002 2:38 PM > > > > 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) the SYSDBA privilege. I also ensured that > REMOTE_LOGIN_PASSWORDFILE > > is set to TRUE, but still I can not connect as SYSDBA. > > > > Following are the steps which I took. > > > > Step 1. Created a password file as followed : > > > > D:\Oracle\Ora815\BIN>cd ..\dbs > > D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i > > entries=30 > > > > Step 2. Grant SYS user the SYSDBA privilege by the following method > > > > D:\Oracle\Ora815\DBS>svrmgrl > > > > Oracle Server Manager Release 3.1.5.0.0 - Production > > > > (c) Copyright 1997, Oracle Corporation. All Rights Reserved. > > > > Oracle8i Release 8.1.5.0.0 - Production > > With the Java option > > PL/SQL Release 8.1.5.0.0 - Production > > > > SVRMGR> connect internal > > Password: > > Connected. > > SVRMGR> grant SYSDBA to SYS; > > Statement processed. > > > > SVRMGR> select * from v$pwfile_users ; > > USERNAME SYSDB SYSOP > > -- - - > > INTERNAL TRUE TRUE > > SYSTRUE TRUE > > 2 rows selected. > > > > Pls help me if possible. > > > > Thanks in advance. > > > > Chetan > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Chindarkar,Chetan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SYSDBA privilege with ORAPWD utility
Tom , I set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE, gave the same name to the pw file as suggested by you (though it was not mentioned anyewhere) and tried; but still it's not working. I can't figure out what can be the problem. Pls help. Chetan > -- > From: Mercadante, Thomas F[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. > > 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 > > > -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 denied". Then I created > a > password file using ORAPWD utility and granted SYS and WIP (a newly > created > schema) the SYSDBA privilege. I also ensured that > REMOTE_LOGIN_PASSWORDFILE > is set to TRUE, but still I can not connect as SYSDBA. > > Following are the steps which I took. > > Step 1. Created a password file as followed : > > D:\Oracle\Ora815\BIN>cd ..\dbs > D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i > entries=30 > > Step 2. Grant SYS user the SYSDBA privilege by the following method > > D:\Oracle\Ora815\DBS>svrmgrl > > Oracle Server Manager Release 3.1.5.0.0 - Production > > (c) Copyright 1997, Oracle Corporation. All Rights Reserved. > > Oracle8i Release 8.1.5.0.0 - Production > With the Java option > PL/SQL Release 8.1.5.0.0 - Production > > SVRMGR> connect internal > Password: > Connected. > SVRMGR> grant SYSDBA to SYS; > Statement processed. > > SVRMGR> select * from v$pwfile_users ; > USERNAME SYSDB SYSOP > -- - - > INTERNAL TRUE TRUE > SYSTRUE TRUE > 2 rows selected. > > Pls help me if possible. > > Thanks in advance. > > Chetan > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Chindarkar,Chetan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 2:38 PM > 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) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE > is set to TRUE, but still I can not connect as SYSDBA. > > Following are the steps which I took. > > Step 1. Created a password file as followed : > > D:\Oracle\Ora815\BIN>cd ..\dbs > D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i > entries=30 > > Step 2. Grant SYS user the SYSDBA privilege by the following method > > D:\Oracle\Ora815\DBS>svrmgrl > > Oracle Server Manager Release 3.1.5.0.0 - Production > > (c) Copyright 1997, Oracle Corporation. All Rights Reserved. > > Oracle8i Release 8.1.5.0.0 - Production > With the Java option > PL/SQL Release 8.1.5.0.0 - Production > > SVRMGR> connect internal > Password: > Connected. > SVRMGR> grant SYSDBA to SYS; > Statement processed. > > SVRMGR> select * from v$pwfile_users ; > USERNAME SYSDB SYSOP > -- - - > INTERNAL TRUE TRUE > SYSTRUE TRUE > 2 rows selected. > > Pls help me if possible. > > Thanks in advance. > > Chetan > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Chindarkar,Chetan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SYSDBA privilege with ORAPWD utility
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 list ORACLE-L 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 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 -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 denied". Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BIN>cd ..\dbs D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBS>svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect internal Password: Connected. SVRMGR> grant SYSDBA to SYS; Statement processed. SVRMGR> select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (l
RE: SYSDBA privilege with ORAPWD utility
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 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) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BIN>cd ..\dbs D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBS>svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect internal Password: Connected. SVRMGR> grant SYSDBA to SYS; Statement processed. SVRMGR> select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SYSDBA privilege with ORAPWD utility
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 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 -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 denied". Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BIN>cd ..\dbs D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBS>svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect internal Password: Connected. SVRMGR> grant SYSDBA to SYS; Statement processed. SVRMGR> select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SYSDBA privilege with ORAPWD utility
shouldn't it be exclusive i.s.o true for the remote_login_passwordfile? Jack "Chindarkar,Chetan" telinc.com> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: SYSDBA privilege with ORAPWD utility [EMAIL PROTECTED] 11-09-2002 14:38 Please respond to 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) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BIN>cd ..\dbs D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBS>svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect internal Password: Connected. SVRMGR> grant SYSDBA to SYS; Statement processed. SVRMGR> select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uit
RE: SYSDBA privilege with ORAPWD utility
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 -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 denied". Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BIN>cd ..\dbs D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBS>svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect internal Password: Connected. SVRMGR> grant SYSDBA to SYS; Statement processed. SVRMGR> select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SYSDBA privilege with ORAPWD utility
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 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) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BIN>cd ..\dbs D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBS>svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect internal Password: Connected. SVRMGR> grant SYSDBA to SYS; Statement processed. SVRMGR> select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SYSDBA privilege with ORAPWD utility
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 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) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE > is set to TRUE, but still I can not connect as SYSDBA. > > Following are the steps which I took. > > Step 1. Created a password file as followed : > > D:\Oracle\Ora815\BIN>cd ..\dbs > D:\Oracle\Ora815\DBS>orapwd file=orapwsb815 password=oracle8i > entries=30 > > Step 2. Grant SYS user the SYSDBA privilege by the following method > > D:\Oracle\Ora815\DBS>svrmgrl > > Oracle Server Manager Release 3.1.5.0.0 - Production > > (c) Copyright 1997, Oracle Corporation. All Rights Reserved. > > Oracle8i Release 8.1.5.0.0 - Production > With the Java option > PL/SQL Release 8.1.5.0.0 - Production > > SVRMGR> connect internal > Password: > Connected. > SVRMGR> grant SYSDBA to SYS; > Statement processed. > > SVRMGR> select * from v$pwfile_users ; > USERNAME SYSDB SYSOP > -- - - > INTERNAL TRUE TRUE > SYSTRUE TRUE > 2 rows selected. > > Pls help me if possible. > > Thanks in advance. > > Chetan -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] "It is not enough to have a good mind. The main thing is to use it well." -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sysdba
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 wrote: [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 under sloaris through version 8.1.7. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. "My goal is simple. It is complete understanding of the universe, why it is as it is and why it exists at all." - Stephen Hawking -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Wilfredo Sellado, AbtikBoys Software Design Engineer NEC Telecom Software Phils., Inc. Asiatown I.T. Park Apas, Cebu City 6000, Philippines Office : +63(32)233-9142 [local 311] Residence: +63(32)412-8350 Mobile : +63(917)546-5867 Email : <[EMAIL PROTECTED]> I love you without knowing how, or when, or from where I love you simply without problems or pride I love you in this way because I don't know any other way of loving
Re: sysdba
actaually paPIpapupapePO is a one of the sets to practice proper Japanase pronunciation. and it so happen that i found the syllables of my nick in it "PIPO" so i like using it as my tag-name. =) but i am a filipino having a technical training here in Japan. Rahul wrote: and i'm just curious 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 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 the DBA group? > > > > is the DBA group the primary group? > > -- > > -- > > Bill "Shrek" Thater ORACLE DBA > > [EMAIL PROTECTED] > > > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > > > Youth and skill are no match for experience and treachery. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: bill thater > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > 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 Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Wilfredo Sellado, AbtikBoys Software Design Engineer NEC Telecom Software Phils., Inc. Asiatown I.T. Park Apas, Cebu City 6000, Philippines Office : +63(32)233-9142 Residence: +63(32)412-8350 Mobile : +63(917)546-5867 Email : <[EMAIL PROTECTED]> I love you without knowing how, or when, or from where I love you simply without problems or pride I love you in this way because I don't know any other way of loving
RE: sysdba
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 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 the DBA group? > > > > is the DBA group the primary group? > > -- > > -- > > Bill "Shrek" Thater ORACLE DBA > > [EMAIL PROTECTED] > > > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > > > Youth and skill are no match for experience and treachery. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: bill thater > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > 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 Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sysdba
OK, any other details missing frorm your post? Like Oracle version, whether or not you use a password file, OS type/version, etc.? Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: paPIpapupapePO [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 03, 2002 5:43 PM > 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 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 > > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sysdba
[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 under sloaris through version 8.1.7. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. "My goal is simple. It is complete understanding of the universe, why it is as it is and why it exists at all."- Stephen Hawking -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sysdba
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 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sysdba
guess i missed that somewhere, i've always done dba for both groups , never a problem but that could be since i've been doing oracle since version 5 on msdos. joe paPIpapupapePO wrote: >i did use the oracle account with primary group as oinstall and secondary as >dba. >this what the manual tells. > >[EMAIL PROTECTED] wrote: > >>That's because you didn't read the documentation for Oracle. If you do not >>have the cd, you can find the sqlplus guide online at >>http://technet.oracle.com which details all variations, restrictions, and >>abilities of the "connect" command. >> >>Scott Shafer >>San Antonio, TX >>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. >>> >>>[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 >>>>512-414-1002 >>>> >>>-- >>>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 Internet access / Mailing Lists >>> >>>To REMOVE yourself from this mailing list, send an E-Mail message >>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>>the message BODY, include a line containing: UNSUB ORACLE-L >>>(or the name of mailing list you want to be removed from). You may >>>also send the HELP command for other information (like subscribing). >>> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or the name of mailing list you want to be removed from). You may >>also send the HELP command for other information (like subscribing). >> > >-- > > Wilfredo Sellado, AbtikBoys > Software Design Engineer > NEC Telecom Software Phils., Inc. > Asia Town I.T. Park > Lahug, Cebu City 6000, Philippines > Office : +63(32)233-9142 > Residence: +63(32)412-8350 > Mobile : +63(917)546-5867 > Email: <[EMAIL PROTECTED]> > > I love you without knowing how, or when, or from where > I love you simply without problems or pride > I love you in this way because I don't know any other way of loving > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Youth and skill are no match for experience and treachery. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sysdba
i did use the oracle account with primary group as oinstall and secondary as dba. this what the manual tells. [EMAIL PROTECTED] wrote: > That's because you didn't read the documentation for Oracle. If you do not > have the cd, you can find the sqlplus guide online at > http://technet.oracle.com which details all variations, restrictions, and > abilities of the "connect" command. > > Scott Shafer > San Antonio, TX > 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. > > > > [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 > > > 512-414-1002 > > > > > > > -- > > 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 Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Wilfredo Sellado, AbtikBoys Software Design Engineer NEC Telecom Software Phils., Inc. Asia Town I.T. Park Lahug, Cebu City 6000, Philippines Office : +63(32)233-9142 Residence: +63(32)412-8350 Mobile : +63(917)546-5867 Email: <[EMAIL PROTECTED]> I love you without knowing how, or when, or from where I love you simply without problems or pride I love you in this way because I don't know any other way of loving -- 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sysdba
That's because you didn't read the documentation for Oracle. If you do not have the cd, you can find the sqlplus guide online at http://technet.oracle.com which details all variations, restrictions, and abilities of the "connect" command. Scott Shafer San Antonio, TX 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. > > [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 > > 512-414-1002 > > > > -- > 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 Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sysdba
[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 [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Youth and skill are no match for experience and treachery. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sysdba
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 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 > 512-414-1002 > -- 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sysdba
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? -- 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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? > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > -- 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sysdba
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 paPIpapupapePO nec.co.jp>cc: Sent by: Subject: sysdba [EMAIL PROTECTED] m 04/02/2002 11:18 PM Please respond to ORACLE-L 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-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sysdba
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 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. > 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 Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sysdba and sysoper
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 open ; Instance shutdown, dismount & database close ; Alter database BACKUP, ARCHIVE LOG, and RECOVER. This privilege allows the user to perform basic operational tasks without the ability to look at user data. SYSDBA privilege includes all SYSOPER privileges plus full system privileges (with the ADMIN option), plus 'CREATE DATABASE' etc.. This is effectively the same set of privileges available when previously connected INTERNAL. -Original Message- From: Sajid Iqbal [mailto:[EMAIL PROTECTED]] Sent: 07 December 2001 10:10 To: Multiple recipients of list ORACLE-L Subject: sysdba and sysoper Hi Can anyone tell me the difference between sysdba and sysoper.. in the book it says :- sysdba - A priviliged role granted to database users allowed to start and stop the Oracle Database sysoper - A priviliged role granted to database users allowed to start and stop the Oracle Database The same explanation ? Also whats a tempfile in oracle ? Regards -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =