RE: sys as sysdba with password through ODBC
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 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, 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 _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). _ Tired of 56k? Get a FREE BT Broadband connection http://www.msn.co.uk/specials/btbroadband -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: sys as sysdba with password through ODBC
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 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] I have done that it works through SQLPLUS but through my page i can connect to the dsn but now i get Warning: odbc_exec(): SQL error: [Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE , SQL state S1000 in SQLExecDirect >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >To: "'[EMAIL PROTECTED]'" <[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- >From: Craig Richards [mailto:[EMAIL PROTECTED] >Sent: Friday, December 19, 2003 10:29 AM >To: Multiple recipients of list ORACLE-L >Subject: sys as sysdba with password through ODBC > > >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 > >_ >Express yourself with cool emoticons - download MSN Messenger today! >http://www.msn.co.uk/messenger > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Craig Richards > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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). _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: sys as sysdba with password through ODBC
I have done that it works through SQLPLUS but through my page i can connect to the dsn but now i get Warning: odbc_exec(): SQL error: [Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE , SQL state S1000 in SQLExecDirect From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[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- From: Craig Richards [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: sys as sysdba with password through ODBC 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 _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: sys as sysdba with password through ODBC
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, 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 _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
sys as sysdba with password through ODBC
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 _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Connect sys/password@database as sysdba & E-Business suite
You're right. I made a mess of this. I'm busy, and I'll stay away from the list today. -- Mladen Gogala Oracle DBA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Tanel Poder > Sent: Friday, September 12, 2003 1:05 PM > To: Multiple recipients 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 "SYSDBA privilege to be a SYSDBA"? DBA > role is irrelevant here. > > > Tanel. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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). > Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Connect sys/password@database 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 "SYSDBA privilege to be a SYSDBA"? DBA role is irrelevant here. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Connect sys/password@database as sysdba & E-Business suite
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 remote_password_file accordingly, then RMAN can connect to remote instances as sysdba? I'm asking this, haven't had a chance to test. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 12, 2003 6:44 PM > > This is not true. If O7_DICTIONARY_ACCESSIBILITY is set true, the instance > can be connect as sysdba from remote if user has granted role sysdba. Am I > right?. If this value is true. even then sys can be connected as normal > user. > > With Regards, > Manoj Kumar Jha > C-56 , Phase-2 > NOIDA -201305, UP(INDIA) > Tata Consultancy Services > Ph No: (+91-120) 4461001 ext : 1037 (Off.) > Mobile No : 9810090974 > > -- -- > > > A transcendentalist engaged in auspicious activities does not meet with > destruction either in this world or in the spiritual world; one who does > good, > is never overcome by evil. > -- -- > > > > > > "Mladen > Gogala" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]cc: > ading.com>Subject: RE: Connect sys/[EMAIL PROTECTED] as sysdba & E-Business > Sent by: suite > [EMAIL PROTECTED] > ity.com > > > 09/12/03 07:44 > PM > Please respond > to ORACLE-L > > > > > > > You should set remote_os_authent and remote_os_roles to 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. > > > -- > Mladen Gogala > Oracle DBA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Jack van Zanen > Sent: Friday, September 12, 2003 4:29 AM > To: Multiple recipients of list ORACLE-L > Subject: 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 but > reports invalid username/password at the secondary instance. > > > Is this "normal" behaviour? > > > > > > When connecting to an e-business suite(11.5.9?) database I noticed that my > sessions (ODBC & SQL*Plus) were executing the suites portal login > procedure.In fact all connections did this. > > > Also my ODBC connection timed out on tables owned by a none suite schema. > > > Is there a database logon trigger on e-business suite that forces every > connection through the suites security mechanism or something? > > > (I have never worked with e-business so I know nothing about it, I just > installed some monitor tools repository in this database and could not get > to the data) > > > > > > TIA > > > > > > > Jack > > > > > Note: > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mistransmission. If > you receive this message in error, please immediately delete it and all > copies of it from your system, destroy any hard copies of it and notify the > sender. You must not, directly or indirectly, use, disclose, distribute, > print, or copy any part of this message if you are not the intended > recipient. Wang Trading LLC and any of its subsidiaries each reserve the > right to monitor all e-mail communications through its networks. Any views > expressed in this message are those of the individual sender, except where > the message states otherwise and the sender is authorized to state them to > be the views of any such entity. > > > > > > DISCLAIMER: The information contained in this message is intended
RE: Connect sys/password@database 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 user as a sysdba, you must explicitely tell oracle to do so. Dictionary accessibility has nothing to do with that. -- Mladen Gogala Oracle DBA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of ManojKr Jha > Sent: Friday, September 12, 2003 11:44 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Connect sys/[EMAIL PROTECTED] as sysdba & > E-Business suite > > > > This is not true. If O7_DICTIONARY_ACCESSIBILITY is set true, > the instance can be connect as sysdba from remote if user has > granted role sysdba. Am I right?. If this value is true. even > then sys can be connected as normal user. > > With Regards, > Manoj Kumar Jha > C-56 , Phase-2 > NOIDA -201305, UP(INDIA) > Tata Consultancy Services > Ph No: (+91-120) 4461001 ext : 1037 (Off.) > Mobile No : 9810090974 > > -- > -- > > > A transcendentalist engaged in auspicious activities does not > meet with destruction either in this world or in the > spiritual world; one who does good, is never overcome by evil. > -- > -- > > > > > > > "Mladen > > Gogala" To: Multiple > recipients of list ORACLE-L <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]cc: > > ading.com>Subject: RE: > Connect sys/[EMAIL PROTECTED] as sysdba & E-Business > Sent by: suite > > [EMAIL PROTECTED] > > ity.com > > > > > > 09/12/03 07:44 > > PM > > Please respond > > to ORACLE-L > > > > > > > > > > You should set remote_os_authent and remote_os_roles to > 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. > > > -- > Mladen Gogala > Oracle DBA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Jack van Zanen > Sent: Friday, September 12, 2003 4:29 AM > To: Multiple recipients of list ORACLE-L > Subject: 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 but reports invalid username/password at the > secondary instance. > > > Is this "normal" behaviour? > > > > > > When connecting to an e-business suite(11.5.9?) database I > noticed that my sessions (ODBC & SQL*Plus) were executing > the suites portal login procedure.In fact all connections did this. >
RE: Connect sys/password@database as sysdba & E-Business suite
This is not true. If O7_DICTIONARY_ACCESSIBILITY is set true, the instance can be connect as sysdba from remote if user has granted role sysdba. Am I right?. If this value is true. even then sys can be connected as normal user. With Regards, Manoj Kumar Jha C-56 , Phase-2 NOIDA -201305, UP(INDIA) Tata Consultancy Services Ph No: (+91-120) 4461001 ext : 1037 (Off.) Mobile No : 9810090974 A transcendentalist engaged in auspicious activities does not meet with destruction either in this world or in the spiritual world; one who does good, is never overcome by evil. "Mladen Gogala" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED]cc: ading.com>Subject: RE: Connect sys/[EMAIL PROTECTED] as sysdba & E-Business Sent by: suite [EMAIL PROTECTED] ity.com 09/12/03 07:44 PM Please respond to ORACLE-L You should set remote_os_authent and remote_os_roles to 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. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jack van Zanen Sent: Friday, September 12, 2003 4:29 AM To: Multiple recipients of list ORACLE-L Subject: 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 but reports invalid username/password at the secondary instance. Is this "normal" behaviour? When connecting to an e-business suite(11.5.9?) database I noticed that my sessions (ODBC & SQL*Plus) were executing the suites portal login procedure.In fact all connections did this. Also my ODBC connection timed out on tables owned by a none suite schema. Is there a database logon trigger on e-business suite that forces every connection through the suites security mechanism or something? (I have never worked with e-business so I know nothing about it, I just installed some monitor tools repository in this database and could not get to the data) TIA Jack Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is aut
RE: Connect sys/password@database as sysdba & E-Business suite
Title: Message You should set remote_os_authent and remote_os_roles to 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. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jack van ZanenSent: Friday, September 12, 2003 4:29 AMTo: Multiple recipients of list ORACLE-LSubject: 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 but reports invalid username/password at the secondary instance. Is this "normal" behaviour? When connecting to an e-business suite(11.5.9?) database I noticed that my sessions (ODBC & SQL*Plus) were executing the suites portal login procedure.In fact all connections did this. Also my ODBC connection timed out on tables owned by a none suite schema. Is there a database logon trigger on e-business suite that forces every connection through the suites security mechanism or something? (I have never worked with e-business so I know nothing about it, I just installed some monitor tools repository in this database and could not get to the data) TIA Jack Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re: Connect sys/password@database as sysdba & E-Business suite
> 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 Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Connect sys/password@database as sysdba & E-Business suite
Hi Tanel I did not mention that w/o the connect string it works Will look at the password file. I have not tried to run a query in SQL*Plus, will ask the cst to do so. I use a new user for the repository (not apps) Jack -Original Message- Sent: Friday, September 12, 2003 1:49 PM To: Multiple recipients of list ORACLE-L 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 whatever password you provide. If you access your data using ODBC, which username do you use? Is it APPS? Afaik there is no restricting logon trigger in apps, at least up to 11.5.7 there isn't. Try to execute the exact query manually under same user first, to see whether the timeout problem comes from database or ODBC driver. Tanel. - 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 it works fine at the primary instance but reports invalid username/password at the secondary instance. Is this "normal" behaviour? When connecting to an e-business suite(11.5.9?) database I noticed that my sessions (ODBC & SQL*Plus) were executing the suites portal login procedure.In fact all connections did this. Also my ODBC connection timed out on tables owned by a none suite schema. Is there a database logon trigger on e-business suite that forces every connection through the suites security mechanism or something? (I have never worked with e-business so I know nothing about it, I just installed some monitor tools repository in this database and could not get to the data) TIA Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Connect sys/password@database as sysdba & E-Business suite
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 whatever password you provide. If you access your data using ODBC, which username do you use? Is it APPS? Afaik there is no restricting logon trigger in apps, at least up to 11.5.7 there isn't. Try to execute the exact query manually under same user first, to see whether the timeout problem comes from database or ODBC driver. Tanel. - Original Message - From: Jack van Zanen To: Multiple recipients of list ORACLE-L Sent: Friday, September 12, 2003 11:29 AM Subject: 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 but reports invalid username/password at the secondary instance. Is this "normal" behaviour? When connecting to an e-business suite(11.5.9?) database I noticed that my sessions (ODBC & SQL*Plus) were executing the suites portal login procedure.In fact all connections did this. Also my ODBC connection timed out on tables owned by a none suite schema. Is there a database logon trigger on e-business suite that forces every connection through the suites security mechanism or something? (I have never worked with e-business so I know nothing about it, I just installed some monitor tools repository in this database and could not get to the data) TIA Jack
Connect sys/password@database as sysdba & E-Business suite
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 but reports invalid username/password at the secondary instance. Is this "normal" behaviour? When connecting to an e-business suite(11.5.9?) database I noticed that my sessions (ODBC & SQL*Plus) were executing the suites portal login procedure.In fact all connections did this. Also my ODBC connection timed out on tables owned by a none suite schema. Is there a database logon trigger on e-business suite that forces every connection through the suites security mechanism or something? (I have never worked with e-business so I know nothing about it, I just installed some monitor tools repository in this database and could not get to the data) TIA Jack
RE: Forms - as sysdba
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 for the upgrade - certainly test it > out on a test system first. > > Regarding the upgrade - why exactly does it need to be > connected as sys - eg what doesn't work if you connect as system. > > HTH, > Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Forms - as sysdba
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 ORACLE-LSubject: 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 Subject: Re: Forms - as sysdba 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. 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 PROTECTED] /as sysdba > sys/[EMAIL PROTECTED] 'as sysdba' > sys/[EMAIL PROTECTED] '/as sysdba' > But I always get an error message - either invalid username/password or > TNS error (can't recognize the connect string). > I have also tried it from command line but didn't succeed. > > Does anyone know if/how is it possible? > > Thanks a lot > Robert Pipich > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Forms - as sysdba
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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Forms - as sysdba
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 the upgrade - why exactly does it need to be connected as sys - eg what doesn't work if you connect as system. HTH, Bruce Reardon -Original Message- Sent: Friday, 22 August 2003 4:49 PM Robo You can connect as ifrun60.EXE "C:\...\..\logon2.fmx" Regards Suhen -Original Message- Sent: Friday, 22 August 2003 4:39 PM I MUST connect as sys, because it's a part of an upgrade of our system. I will try to find some kind of patch for this situation as Jared suggested. Anyway, it should be possible to connect from command line, shouldn't it? Something like: c:\orant\bin\ifrun60.exe C:\dev\form.fmx "sys/[EMAIL PROTECTED] "\/'as sysdba'" =RP= -Original Message- Sent: Thursday, August 21, 2003 5:54 PM Rather, why do you want to connect as SYS ? If you've created some custom tables in the SYS schema in an earlier version, create another user, connect as SYS in sqlplus, GRANT privileges to that user and connect as that new user in Forms. -- and think about migrating the tables out of the SYS 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 want to connect as sysdba anyway? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM 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 PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Forms - as sysdba
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 MUST connect as sys,
because it's a part of an upgrade of our system.
I will try to find some
kind of patch for this situation as Jared suggested.
Anyway, it should be
possible to connect from command line, shouldn't it? Something
like:
c:\orant\bin\ifrun60.exe
C:\dev\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 sysdbaRather, why do you want to
connect as SYS ?If you've created some custom tables in the SYS schema
in an earlier version, create another user, connect as SYS in sqlplus,
GRANT privileges to that userand connect as that new user in Forms. --
and think about migrating the tablesout of the SYS schema.If you
are querying standard tables, OEM provides good views for most of
whatyou need and the group here can provide better SQL scripts
anyway.HemantAt 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 want to connect
as sysdba anyway? Tanel.
- Original Message -
From: Robo
To: Multiple recipients of
list ORACLE-L
Sent: Thursday, August 21, 2003 11:54 AM
Subject: 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 PROTECTED] /as sysdba
sys/[EMAIL PROTECTED] 'as sysdba'
sys/[EMAIL PROTECTED] '/as sysdba'
But I always get an error message -
either invalid username/password or
TNS error (can't recognize the connect string).
I have also tried it from command line but didn't succeed.
Does anyone know if/how is it possible?
Thanks a lot
Robert Pipich
Hemant K ChitaleOracle 9i Database Administrator Certified
ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the
official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale
INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego, California -- Mailing list and web hosting
services
- 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). --* www.inMail.sk - Vasa emailova adresa na cely
zivot ZDARMA* Mail neobsahuje virusy. Zkontrolovane antivirusom NOD32
(www.eset.sk)* www.SlovakNET.sk - profesionalny
webhosting, domena .SK ZADARMO* Zoner Media Explorer 5 - stiahnite si
pomocnika pre digitalnu fotografiu
(zme.zoner.sk)
RE: Forms - as sysdba
Title: Message I MUST connect as sys, because it's a part of an upgrade of our system. I will try to find some kind of patch for this situation as Jared suggested. Anyway, it should be possible to connect from command line, shouldn't it? Something like: c:\orant\bin\ifrun60.exe C:\dev\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 sysdbaRather, why do you want to connect as SYS ?If you've created some custom tables in the SYS schema in an earlier version, create another user, connect as SYS in sqlplus, GRANT privileges to that userand connect as that new user in Forms. -- and think about migrating the tablesout of the SYS schema.If you are querying standard tables, OEM provides good views for most of whatyou need and the group here can provide better SQL scripts anyway.HemantAt 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 want to connect as sysdba anyway? Tanel. - Original Message - From: Robo To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM Subject: 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 PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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). --* www.inMail.sk - Vasa emailova adresa na cely zivot ZDARMA* Mail neobsahuje virusy. Zkontrolovane antivirusom NOD32 (www.eset.sk)* www.SlovakNET.sk - profesionalny webhosting, domena .SK ZADARMO* Zoner Media Explorer 5 - stiahnite si pomocnika pre digitalnu fotografiu (zme.zoner.sk)
RE: Forms - as sysdba
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 Subject: Re: Forms - as sysdba 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. 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 PROTECTED] /as sysdba > sys/[EMAIL PROTECTED] 'as sysdba' > sys/[EMAIL PROTECTED] '/as sysdba' > But I always get an error message - either invalid username/password or > TNS error (can't recognize the connect string). > I have also tried it from command line but didn't succeed. > > Does anyone know if/how is it possible? > > Thanks a lot > Robert Pipich > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Forms - as sysdba
Rather, why do you want to connect as SYS ? If you've created some custom tables in the SYS schema in an earlier version, create another user, connect as SYS in sqlplus, GRANT privileges to that user and connect as that new user in Forms. -- and think about migrating the tables out of the SYS 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 want to connect as sysdba anyway? Tanel. - Original Message - From: Robo To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM Subject: 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 PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Forms - as sysdba
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 21, 2003 11:54 AM Subject: 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 PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible?Thanks a lot Robert Pipich
Re: Forms - as sysdba
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. 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 PROTECTED] /as sysdba > sys/[EMAIL PROTECTED] 'as sysdba' > sys/[EMAIL PROTECTED] '/as sysdba' > But I always get an error message - either invalid username/password or > TNS error (can't recognize the connect string). > I have also tried it from command line but didn't succeed. > > Does anyone know if/how is it possible? > > Thanks a lot > Robert Pipich > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Forms - as sysdba
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 PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich
RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
Title: RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
it
works. thanks.
-Original Message-From: Stefick Ronald S Civ
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Friday, June
27, 2003 11:05 AMTo: Multiple recipients of list
ORACLE-LSubject: 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 ==> rman target "/ as sysdba"
THANKS
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
none if specified,
then no recovery catalog cmdfile quoted-string name of input
command file log
quoted-string name of output message log file trace quoted-string
name of output debugging message log file append
none if specified,
log is opened in append mode debug optional-args
activate debugging msgno
none show
RMAN- prefix for all messages send
quoted-string send a command to the media manager pipe
string building block for pipe
names timeout
integer number of seconds to wait
for pipe input -
Both single and double quotes (' or ") are accepted for a
quoted-string. Quotes are not required unless the string contains embedded
white-space.
RMAN-00571:
=== RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
=== RMAN-00571:
=== RMAN-00552: syntax error in command line arguments RMAN-01005: syntax error: found "identifier": expecting one of:
"append, at, auxiliary, catalog, cmd file, clone, debug, log, msglog, mask,
msgno, nocatalog, pipe, rcvcat, slaxdebug, send, target, time out,
trace"
RMAN-01008: the bad identifier was: as RMAN-01007: at line 0 column 4 file: command line arguments
bigtex:oraadm 8% rman target "system/manager"
Recovery Manager: Release 9.2.0.3.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights
reserved.
connected to target database: DV2 (DBID=3650624848)
RMAN> exit
Recovery Manager complete. bigtex:oraadm 9% sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26
16:20:02 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
Connected to: Oracle9i Enterprise
Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and
Oracle Data Mining options JServer Release 9.2.0.3.0 - Production
SQL> show user USER is "SYS"
SQL> exit Disconnected from
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the
Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 -
Production bigtex:oraadm 10%
Roger Xu Database Administrator
Dr Pepper Bottling Company of Texas (972)721-8337
This email has been scanned for all viruses by the
MessageLabs Email Security System. For more information on a proactive email
security service working around the clock, around the globe, visit http://www.messagelabs.com
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net --
Author: Roger Xu INET:
[EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
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
email has been scanned for all viruses by the MessageLabs EmailSecurity
System. For more information on a proactive email securityservice working
around the clock, around the globe, visithttp://www.messagelabs.com___
RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
>> (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 - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
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 ==> rman target "/ as sysdba" THANKS
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 none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN- prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
-
Both single and double quotes (' or ") are accepted for a quoted-string. Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-00552: syntax error in command line arguments
RMAN-01005: syntax error: found "identifier": expecting one of: "append, at, auxiliary, catalog, cmd file, clone, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, slaxdebug, send, target, time out, trace"
RMAN-01008: the bad identifier was: as
RMAN-01007: at line 0 column 4 file: command line arguments bigtex:oraadm 8% rman target "system/manager"
Recovery Manager: Release 9.2.0.3.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DV2 (DBID=3650624848)
RMAN> exit
Recovery Manager complete.
bigtex:oraadm 9% sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26 16:20:02 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production
SQL> show user
USER is "SYS"
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production bigtex:oraadm 10%
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
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: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Roger Xu
> Sent: Friday, June 27, 2003 16:25
> To: Multiple recipients of list ORACLE-L
> Subject: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
>
>
> 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
> nocatalognone if specified, then no recovery catalog
> cmdfile quoted-string name of input command file
> log quoted-string name of output message log file
> tracequoted-string name of output debugging message log file
> append none if specified, log is opened in append mode
> debugoptional-args activate debugging
> msgnonone show RMAN- prefix for all messages
> send quoted-string send a command to the media manager
> pipe string building block for pipe names
> timeout integernumber of seconds to wait for pipe input
> --
> ---
> Both single and double quotes (' or ") are accepted for a
> quoted-string.
> Quotes are not required unless the string contains embedded
> white-space.
>
> RMAN-00571:
> ===
> RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
> ===
> RMAN-00571:
> ===
> RMAN-00552: syntax error in command line arguments
> RMAN-01005: syntax error: found "identifier": expecting one
> of: "append, at, auxiliary, catalog, cmd
> file, clone, debug, log, msglog, mask, msgno, nocatalog,
> pipe, rcvcat, slaxdebug, send, target, time
> out, trace"
> RMAN-01008: the bad identifier was: as
> RMAN-01007: at line 0 column 4 file: command line arguments
> bigtex:oraadm 8% rman target "system/manager"
>
> Recovery Manager: Release 9.2.0.3.0 - 64bit Production
>
> Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
>
> connected to target database: DV2 (DBID=3650624848)
>
> RMAN> exit
>
>
> Recovery Manager complete.
> bigtex:oraadm 9% sqlplus "/ as sysdba"
>
> SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26 16:20:02 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
>
> SQL> show user
> USER is "SYS"
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release
> 9.2.0.3.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
> bigtex:oraadm 10%
>
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
>
> __
> __
> This email has been scanned for all viruses by the MessageLabs Email
> Security System. For more information on a proactive email security
> service working around the clock, around the globe, visit
> http://www.messagelabs.com
> __
> __
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Roger Xu
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
--
Author: Grant Allen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http:/
Re: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
You do not need "as sysdba" when connecting in RMAN:
d:\oracle>rman 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 instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN>
--- Roger Xu <[EMAIL PROTECTED]> wrote:
> 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
> nocatalognone if specified, then no recovery catalog
> cmdfile quoted-string name of input command file
> log quoted-string name of output message log file
> tracequoted-string name of output debugging message log file
> append none if specified, log is opened in append
> mode
> debugoptional-args activate debugging
> msgnonone show RMAN- prefix for all messages
> send quoted-string send a command to the media manager
> pipe string building block for pipe names
> timeout integernumber of seconds to wait for pipe input
>
-
> Both single and double quotes (' or ") are accepted for a
> quoted-string.
> Quotes are not required unless the string contains embedded
> white-space.
>
> RMAN-00571:
> ===
> RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
> ===
> RMAN-00571:
> ===
> RMAN-00552: syntax error in command line arguments
> RMAN-01005: syntax error: found "identifier": expecting one of:
> "append, at, auxiliary, catalog, cmd
> file, clone, debug, log, msglog, mask, msgno, nocatalog, pipe,
> rcvcat, slaxdebug, send, target, time
> out, trace"
> RMAN-01008: the bad identifier was: as
> RMAN-01007: at line 0 column 4 file: command line arguments
> bigtex:oraadm 8% rman target "system/manager"
>
> Recovery Manager: Release 9.2.0.3.0 - 64bit Production
>
> Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
>
> connected to target database: DV2 (DBID=3650624848)
>
> RMAN> exit
>
>
> Recovery Manager complete.
> bigtex:oraadm 9% sqlplus "/ as sysdba"
>
> SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26 16:20:02 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
>
> SQL> show user
> USER is "SYS"
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 -
> 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
> bigtex:oraadm 10%
>
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
>
>
> This email has been scanned for all viruses by the MessageLabs Email
> Security System. For more information on a proactive email security
> service working around the clock, around the globe, visit
> http://www.messagelabs.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Roger Xu
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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).
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-5
WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
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
nocatalognone if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
tracequoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debugoptional-args activate debugging
msgnonone show RMAN- prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integernumber of seconds to wait for pipe input
-
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-00552: syntax error in command line arguments
RMAN-01005: syntax error: found "identifier": expecting one of: "append, at,
auxiliary, catalog, cmd
file, clone, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, slaxdebug,
send, target, time
out, trace"
RMAN-01008: the bad identifier was: as
RMAN-01007: at line 0 column 4 file: command line arguments
bigtex:oraadm 8% rman target "system/manager"
Recovery Manager: Release 9.2.0.3.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DV2 (DBID=3650624848)
RMAN> exit
Recovery Manager complete.
bigtex:oraadm 9% sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26 16:20:02 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
SQL> show user
USER is "SYS"
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
bigtex:oraadm 10%
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: remote / as sysdba
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 PROTECTED]> > Sent: Sunday, March 09, 2003 10:08 PM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: remote / as sysdba
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 -- Author: Alex Feinstein INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: remote / as sysdba
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 has the same name. We have to name it properly from the beginning, no switching the name to make it live.) SAP uses three types of servers in General: PRD, QAS and DEV. This one happens to be the QAS server. In this case, there are two OS accounts on the server, qasadm and sapserviceqas, that will be created with oracle accounts identified externally. Normally these appear as OPS$QASADM and OPS$SAPSERVICEQAS in the Oracle database. The name of the server is SAPQAS. After installing SAP, we hid the starter db that is installed by renaming directories, etc. We then switched in the real database that is a clone of the current QAS system. SAP wouldn't start, and wouldn't give any indication of the problem. Turning auditing on for sessions showed that the SAP services were not logging into the database. Hmmm Switched the starter database back in, and took a look at the accounts. They were somewhat different than expected: OPS$SAPQAS\QASADM and OPS$SAPQAS\SAPSERVICEQAS. The machine name had been included in the accounts names of the SAP starter database. Hadn't seen this before. Switched the cloned database backin, created accounts with machine name included ( which requires caps and double quotes due to the backslash in the account name ), assigned all privs, copied some objects and started SAP again. All worked fine after that. Is this to be expected? I still don't know nearly as much about Windoze as Unix, so maybe I need to bone up on the Windoze security. ( Don't laugh please, I have to live with it ) Jared On Thursday 06 March 2003 16:38, Jacques Kilchoer wrote: > 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 to enable me to logon to the > database as OPS$JSTILL. > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > > At one time you could set the 'ORACLE_USERNAME=SYSTEM' > > variable in your > > oracle.ini > > file, and log into any database as SYSTEM ( without a > > password ) as long > > as REMOTE_OS_AUTHEN=true. > > > > That was obviously some years ago, and I don't know if that is still > > possible. > > > > I would have hoped that such an obvious hole was plugged > > years ago. It > > seems to > > me that it was, but I don't recall details. Content-Type: text/html; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: remota / as sysdba
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). > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > > The solution seems to be dropping and re-creating the orapwd file. > I had changed the sys password after I had created the password file; > the docs say the file should pick up this password change without > having to re-create it, but re-creating it fixed the problem.
Re: remota / as sysdba
*** Comments by BECKER, BILL Fri Mar 07, 2003 -- 10:56:38 AM No Windows. Env is Oracle Enterprise 9.2.0.2 on Solaris 5.9 (or 2.9 or 9, whatever version number happens to be the version-du-jour) *** Original message by Jared Still <[EMAIL PROTECTED]> Interesting. Was this on some flavor of windows? I've found it necessary to create a new password file when cloning a database, though according to the docs, that shouldn't be necessary. Jared On Friday 07 March 2003 06:44, [EMAIL PROTECTED] wrote: > 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 the orapwd file. > I had changed the sys password after I had created the password file; > the docs say the file should pick up this password change without > having to re-create it, but re-creating it fixed the problem. > > Thanks again. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: remota / as sysdba
Interesting. Was this on some flavor of windows? I've found it necessary to create a new password file when cloning a database, though according to the docs, that shouldn't be necessary. Jared On Friday 07 March 2003 06:44, [EMAIL PROTECTED] wrote: > 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 the orapwd file. > I had changed the sys password after I had created the password file; > the docs say the file should pick up this password change without > having to re-create it, but re-creating it fixed the problem. > > Thanks again. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
remota / as sysdba
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 the orapwd file. I had changed the sys password after I had created the password file; the docs say the file should pick up this password change without having to re-create it, but re-creating it fixed the problem. Thanks again. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: remote / as sysdba
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 to enable me to logon to the database as OPS$JSTILL. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > At one time you could set the 'ORACLE_USERNAME=SYSTEM' > variable in your > oracle.ini > file, and log into any database as SYSTEM ( without a > password ) as long > as REMOTE_OS_AUTHEN=true. > > That was obviously some years ago, and I don't know if that is still > possible. > > I would have hoped that such an obvious hole was plugged > years ago. It > seems to > me that it was, but I don't recall details.
RE: remote / as sysdba
At one time you could set the 'ORACLE_USERNAME=SYSTEM' variable in your oracle.ini file, and log into any database as SYSTEM ( without a password ) as long as REMOTE_OS_AUTHEN=true. That was obviously some years ago, and I don't know if that is still possible. I would have hoped that such an obvious hole was plugged years ago. It seems to me that it was, but I don't recall details. Jared Jacques Kilchoer <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/06/2003 03:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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. The best security is still having different passwords for everything, and if there are too many passwords to remember, just write them down on a post-it note stuck to your monitor. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: remote / as sysdba
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 is still having different passwords for everything, and if there are too many passwords to remember, just write them down on a post-it note stuck to your monitor. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > 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
RE: remote / as sysdba
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 to think that you're either not connecting to the database
you intend,
or you've mistyped the password.
Does connect sys/[EMAIL PROTECTED] as sysdba work?
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/06/2003 01:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: remote / as sysdba
*** Comments by BECKER, BILL Thu Mar 06, 2003 -- 03:30:49 PM
I have tried this, but it still does not work.
[EMAIL PROTECTED]>select value from v$parameter
2 where name = 'remote_login_passwordfile';
VALUE
---
EXCLUSIVE
(This instance was bounced; not yet using spfiles.)
[EMAIL PROTECTED]>select * from v$pwfile_users;
USERNAME SYSDB SYSOP
-- - -
SYSTRUE TRUE
I have verified that the orapwDWQ file exists 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:
ORA-01017: invalid username/password; logon denied
Do both instances need to have remote_login_passwordfile=EXCLUSIVE,
or just the remote instance? Am I missing something else?
*** Original message by Jacques Kilchoer <[EMAIL PROTECTED]>
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$pwfile_users.
As the view name suggests, you will also need a password file for the
database, which should be created with the orapwd utility.
$ orapwd
Usage: orapwd file= password= entries=
where
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
Once you've done all that, you can connect remotely by saying the
following
in SQL*Plus:
connect sys/[EMAIL PROTECTED] as sysdba
But I don't think you will ever be able to do
connect / as sysdba remotely. For one thing, the syntax in SQL*Plus is:
Syntaxe : CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
ou ::= [/][@] | /
So the logon is either username/[EMAIL PROTECTED] or else "/" all by
itself. How would you tell SQL*Plus which remote database you want to
connect to? I tried setting TWO_TASK to the tns_alias for the database,
but
that didn't help. It seems to me that when you enable remote SYSDBA logins
Oracle will insist on verifying a password for the SYSDBA user in the
password file.
Or is there some clever trick I don't know about?
> -Original Message-
> From: [EMAIL PROTECTED]
>
> 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
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> [EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> where ::= [/][@] | /
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> I also find I cannot even "connect sys/syspassword" locally:
>
> [EMAIL PROTECTED]>connect sys/sys_password
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> This does work locally, but not remotely:
>
> [EMAIL PROTECTED]>connect sys/sys_password as sysdba
> Connected.
>
> I am a member of the dba group on both platforms.
>
> I have verified that I am using the correct sys_password for sys
> on the remote instance.
>
> Eventually, I want to do a
RE: remote / as sysdba
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 Kilchoer <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/06/2003 12:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: 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$pwfile_users.
As the view name suggests, you will also need a password file for the
database, which should be created with the orapwd utility.
$ orapwd
Usage: orapwd file= password= entries=
where
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
Once you've done all that, you can connect remotely by saying the
following in SQL*Plus:
connect sys/[EMAIL PROTECTED] as sysdba
But I don't think you will ever be able to do
connect / as sysdba remotely. For one thing, the syntax in SQL*Plus is:
Syntaxe : CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
ou ::= [/][@] | /
So the logon is either username/[EMAIL PROTECTED] or else "/" all by
itself. How would you tell SQL*Plus which remote database you want to
connect to? I tried setting TWO_TASK to the tns_alias for the database,
but that didn't help. It seems to me that when you enable remote SYSDBA
logins Oracle will insist on verifying a password for the SYSDBA user in
the password file.
Or is there some clever trick I don't know about?
> -Original Message-
> From: [EMAIL PROTECTED]
>
> 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
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> [EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> where ::= [/][@] | /
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> I also find I cannot even "connect sys/syspassword" locally:
>
> [EMAIL PROTECTED]>connect sys/sys_password
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> This does work locally, but not remotely:
>
> [EMAIL PROTECTED]>connect sys/sys_password as sysdba
> Connected.
>
> I am a member of the dba group on both platforms.
>
> I have verified that I am using the correct sys_password for sys
> on the remote instance.
>
> Eventually, I want to do a remote transportable tablespace
> import, where
> the userid would be listed in a parfile; I have tried the
> same logons in
> a parfile, and that also fails.
>
> I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
> must be true to do this, but the same doc strongly advises
> against setting
> this to true.
>
> So, has anyone found a way to use the "/ as sysdba" logon remotely?
> (without setting the O7 parameter to true)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: remote / as sysdba
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 remote_login_passwordfile EXCLUSIVE.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
>
> *** Comments by BECKER, BILL Thu Mar 06, 2003 -- 03:30:49 PM
> I have tried this, but it still does not work.
>
> [EMAIL PROTECTED]>select value from v$parameter
> 2 where name = 'remote_login_passwordfile';
>
> VALUE
> --
> -
> EXCLUSIVE
>
> (This instance was bounced; not yet using spfiles.)
>
> [EMAIL PROTECTED]>select * from v$pwfile_users;
>
> USERNAME SYSDB SYSOP
> -- - -
> SYS TRUE TRUE
>
> I have verified that the orapwDWQ file exists 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:
> ORA-01017: invalid username/password; logon denied
>
> Do both instances need to have remote_login_passwordfile=EXCLUSIVE,
> or just the remote instance? Am I missing something else?
>
> __
> __
> *** Original message by Jacques Kilchoer <[EMAIL PROTECTED]>
> 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$pwfile_users.
> As the view name suggests, you will also need a password file for the
> database, which should be created with the orapwd utility.
> $ orapwd
> Usage: orapwd file= password= entries=
>
> where
> file - name of password file (mand),
> password - password for SYS and INTERNAL (mand),
> entries - maximum number of distinct DBA and OPERs (opt),
> There are no spaces around the equal-to (=) character.
>
> Once you've done all that, you can connect remotely by saying
> the following
> in SQL*Plus:
> connect sys/[EMAIL PROTECTED] as sysdba
>
> But I don't think you will ever be able to do
> connect / as sysdba remotely. For one thing, the syntax in
> SQL*Plus is:
> Syntaxe : CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> ou ::= [/][@] | /
>
> So the logon is either username/[EMAIL PROTECTED] or else "/" all by
> itself. How would you tell SQL*Plus which remote database you want to
> connect to? I tried setting TWO_TASK to the tns_alias for the
> database, but
> that didn't help. It seems to me that when you enable remote
> SYSDBA logins
> Oracle will insist on verifying a password for the SYSDBA user in the
> password file.
> Or is there some clever trick I don't know about?
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> >
> > 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
> > ERROR:
> > ORA-01031: insufficient privileges
> >
> > Warning: You are no longer connected to ORACLE.
> >
> > [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
> > ERROR:
> > ORA-01017: invalid username/password; logon denied
> >
> > [EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
> > SP2-0306: Invalid option.
> > Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> > where ::= [/][@] | /
> >
> > [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
> > ERROR:
> > ORA-28009: connection to sys should be as sysdba or sysoper
> >
> > I also find I cannot even "connect sys/syspassword" locally:
> >
> > [EMAIL PROTECTED]>connect sys/sys_password
> > ERROR:
> > ORA-28009: connection to sys should be as sysdba or sysoper
> >
> > This does work locally, but no
Re: remote / as sysdba
Hi Bill,
My wife is from Marshfield, so I'll help you!
The documentation you want to look at starts at:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1167
Basically I think you need to create a paswordfile using orapwd and
set the REMOTE_LOGIN_PASSWORDFILE parameter.
HTH,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 6 Mar 2003, [EMAIL PROTECTED] wrote:
> 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
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> [EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> where ::= [/][@] | /
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> I also find I cannot even "connect sys/syspassword" locally:
>
> [EMAIL PROTECTED]>connect sys/sys_password
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> This does work locally, but not remotely:
>
> [EMAIL PROTECTED]>connect sys/sys_password as sysdba
> Connected.
>
> I am a member of the dba group on both platforms.
>
> I have verified that I am using the correct sys_password for sys
> on the remote instance.
>
> Eventually, I want to do a remote transportable tablespace import, where
> the userid would be listed in a parfile; I have tried the same logons in
> a parfile, and that also fails.
>
> I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
> must be true to do this, but the same doc strongly advises against setting
> this to true.
>
> So, has anyone found a way to use the "/ as sysdba" logon remotely?
> (without setting the O7 parameter to true)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: remote / as sysdba
*** Comments by BECKER, BILL Thu Mar 06, 2003 -- 03:30:49 PM
I have tried this, but it still does not work.
[EMAIL PROTECTED]>select value from v$parameter
2 where name = 'remote_login_passwordfile';
VALUE
---
EXCLUSIVE
(This instance was bounced; not yet using spfiles.)
[EMAIL PROTECTED]>select * from v$pwfile_users;
USERNAME SYSDB SYSOP
-- - -
SYSTRUE TRUE
I have verified that the orapwDWQ file exists 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:
ORA-01017: invalid username/password; logon denied
Do both instances need to have remote_login_passwordfile=EXCLUSIVE,
or just the remote instance? Am I missing something else?
*** Original message by Jacques Kilchoer <[EMAIL PROTECTED]>
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$pwfile_users.
As the view name suggests, you will also need a password file for the
database, which should be created with the orapwd utility.
$ orapwd
Usage: orapwd file= password= entries=
where
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
Once you've done all that, you can connect remotely by saying the following
in SQL*Plus:
connect sys/[EMAIL PROTECTED] as sysdba
But I don't think you will ever be able to do
connect / as sysdba remotely. For one thing, the syntax in SQL*Plus is:
Syntaxe : CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
ou ::= [/][@] | /
So the logon is either username/[EMAIL PROTECTED] or else "/" all by
itself. How would you tell SQL*Plus which remote database you want to
connect to? I tried setting TWO_TASK to the tns_alias for the database, but
that didn't help. It seems to me that when you enable remote SYSDBA logins
Oracle will insist on verifying a password for the SYSDBA user in the
password file.
Or is there some clever trick I don't know about?
> -Original Message-
> From: [EMAIL PROTECTED]
>
> 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
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> [EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> where ::= [/][@] | /
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> I also find I cannot even "connect sys/syspassword" locally:
>
> [EMAIL PROTECTED]>connect sys/sys_password
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> This does work locally, but not remotely:
>
> [EMAIL PROTECTED]>connect sys/sys_password as sysdba
> Connected.
>
> I am a member of the dba group on both platforms.
>
> I have verified that I am using the correct sys_password for sys
> on the remote instance.
>
> Eventually, I want to do a remote transportable tablespace
> import, where
> the userid would be listed in a parfile; I have tried the
> same logons in
> a parfile, and that also fails.
>
> I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
> must be true to do this, but the same doc strongly advises
> against setting
> this to true.
>
> So, has anyone found a way to use the "/ as sysdba" logon remotely?
> (without setting the O7 parameter to true)
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
Re: remote / as sysdba
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 rsysdevdb.radisys.com - [EMAIL PROTECTED] SQL>
You can create a remote user that can logon as sysdba remotely, but
that user must have a password.
See MetaLink Doc # 185703.1
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/06/2003 11:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:remote / as sysdba
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
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
[EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
[EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where ::= [/][@] | /
[EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
I also find I cannot even "connect sys/syspassword" locally:
[EMAIL PROTECTED]>connect sys/sys_password
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
This does work locally, but not remotely:
[EMAIL PROTECTED]>connect sys/sys_password as sysdba
Connected.
I am a member of the dba group on both platforms.
I have verified that I am using the correct sys_password for sys
on the remote instance.
Eventually, I want to do a remote transportable tablespace import, where
the userid would be listed in a parfile; I have tried the same logons in
a parfile, and that also fails.
I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
must be true to do this, but the same doc strongly advises against setting
this to true.
So, has anyone found a way to use the "/ as sysdba" logon remotely?
(without setting the O7 parameter to true)
Thanks to any responders.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: remote / as sysdba
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$pwfile_users.
As the view name suggests, you will also need a password file for the database, which should be created with the orapwd utility.
$ orapwd
Usage: orapwd file= password= entries=
where
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
Once you've done all that, you can connect remotely by saying the following in SQL*Plus:
connect sys/[EMAIL PROTECTED] as sysdba
But I don't think you will ever be able to do
connect / as sysdba remotely. For one thing, the syntax in SQL*Plus is:
Syntaxe : CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
ou ::= [/][@] | /
So the logon is either username/[EMAIL PROTECTED] or else "/" all by itself. How would you tell SQL*Plus which remote database you want to connect to? I tried setting TWO_TASK to the tns_alias for the database, but that didn't help. It seems to me that when you enable remote SYSDBA logins Oracle will insist on verifying a password for the SYSDBA user in the password file.
Or is there some clever trick I don't know about?
> -Original Message-
> From: [EMAIL PROTECTED]
>
> 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
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> [EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> where ::= [/][@] | /
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> I also find I cannot even "connect sys/syspassword" locally:
>
> [EMAIL PROTECTED]>connect sys/sys_password
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> This does work locally, but not remotely:
>
> [EMAIL PROTECTED]>connect sys/sys_password as sysdba
> Connected.
>
> I am a member of the dba group on both platforms.
>
> I have verified that I am using the correct sys_password for sys
> on the remote instance.
>
> Eventually, I want to do a remote transportable tablespace
> import, where
> the userid would be listed in a parfile; I have tried the
> same logons in
> a parfile, and that also fails.
>
> I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
> must be true to do this, but the same doc strongly advises
> against setting
> this to true.
>
> So, has anyone found a way to use the "/ as sysdba" logon remotely?
> (without setting the O7 parameter to true)
RE: remote / as sysdba
have you got the remote login password file ?
if you set it I think it should work .
take a look at Note:1016540.6
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:09 PM
To: Multiple recipients of list ORACLE-L
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
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
[EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
[EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where ::= [/][@] | /
[EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
I also find I cannot even "connect sys/syspassword" locally:
[EMAIL PROTECTED]>connect sys/sys_password
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
This does work locally, but not remotely:
[EMAIL PROTECTED]>connect sys/sys_password as sysdba
Connected.
I am a member of the dba group on both platforms.
I have verified that I am using the correct sys_password for sys
on the remote instance.
Eventually, I want to do a remote transportable tablespace import, where
the userid would be listed in a parfile; I have tried the same logons in
a parfile, and that also fails.
I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
must be true to do this, but the same doc strongly advises against setting
this to true.
So, has anyone found a way to use the "/ as sysdba" logon remotely?
(without setting the O7 parameter to true)
Thanks to any responders.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: MARREIROS,RUI (HP-Portugal,ex1)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
remote / as sysdba
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
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
[EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
[EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where ::= [/][@] | /
[EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
I also find I cannot even "connect sys/syspassword" locally:
[EMAIL PROTECTED]>connect sys/sys_password
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
This does work locally, but not remotely:
[EMAIL PROTECTED]>connect sys/sys_password as sysdba
Connected.
I am a member of the dba group on both platforms.
I have verified that I am using the correct sys_password for sys
on the remote instance.
Eventually, I want to do a remote transportable tablespace import, where
the userid would be listed in a parfile; I have tried the same logons in
a parfile, and that also fails.
I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
must be true to do this, but the same doc strongly advises against setting
this to true.
So, has anyone found a way to use the "/ as sysdba" logon remotely?
(without setting the O7 parameter to true)
Thanks to any responders.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: [Q] insufficient privilege while "connect / as sysdba" on NT?
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 PROTECTED]> Sent: Friday, February 14, 2003 2:31 PM > > 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 file on oracle > ($ORACLE_HOME/databae/pwXXX.ora). Still make no difference. > If I use "svrmgrl" ==> "connect internal", it work fine. > > > Does anyone know why? > > Thanks. > > > > > > _ > Add photos to your e-mail with MSN 8. Get 2 months FREE*. > http://join.msn.com/?page=features/featuredemail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [Q] insufficient privilege while "connect / as sysdba" on NT?
hi. after re-creating the password file, you have to cycle the instance for it to take effect. stop and restart the oracle service. (this will kill any connections) You are better off to login to the instance and perform the shutdown manually as opposed to just killing the service. Have you set the timeout parameter for the service? you can manually adjust this via the oradim.exe utility D:\Oracle\Ora81\Bin\> oradim -edit -sid ORCL -timeout 300 this can also be set in the registry: HKLM\SOFTWARE\ORACLE\HOMEn\ORACLE_%ORACLE_SID%_SHUTDOWN_TIMEOUT I like a value of 300 seconds for a smaller sga, larger if you have a large SGA. You will also have to set the following parameter: HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout 30 this one is in milliseconds. As usual, you may want to backup the registry with regedit.exe prior to making changes. hth, Paul -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 /nolog 3. connect / as sysdba ORA-001031 insufficient privileges I have been recreate the password file on oracle ($ORACLE_HOME/databae/pwXXX.ora). Still make no difference. If I use "svrmgrl" ==> "connect internal", it work fine. Does anyone know why? Thanks. _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 information in this e-mail is intended solely for the addressee and may contain information which is confidential or privileged. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy, retransmit, disseminate, or otherwise use the information. Also, please notify the sender that you have received this e-mail in error, and delete the copy you received." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Drake, Paul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[Q] insufficient privilege while "connect / as sysdba" on NT?
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 file on oracle ($ORACLE_HOME/databae/pwXXX.ora). Still make no difference. If I use "svrmgrl" ==> "connect internal", it work fine. Does anyone know why? Thanks. _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Difference between connect internal and connect / as sysdba in sqlplus
I use Oracle 8.1.7. I tried install patchset 8.1.7.3 and there is written: " ... Invoke SQL*Plus (sqlplus), connect as internal and run the following SQL scripts with event 10520 set. NOTE: This event is not intended for regular database operation and MUST be turned off as indicated below: ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10'; ?/rdbms/admin/catalog.sql ?/rdbms/admin/catproc.sql ?/rdbms/admin/catrep.sql (This only needs to be run if you are using symmetric/advanced replication. This is not necessary for sites using dblinks and read-only 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 difference between thease? > '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 Internet Access from SBC & Yahoo! > http://sbc.yahoo.com -- Best regards Mikhail Ivanov >W±ë zØ^¡÷âr&¥9,BÅm¶ÿà (§Ú©Ê&ëa¢³"¢ÚÈ4Dæö§¢û]z¶«¸V +r5ëp¢¹z»âqë<çÎwó9Öm§ÿðÃÚµÈÉÊ&I©Ãè( +©b~ç£X§X¬µ©ÝÁæá¢Ëb ®øzÄèDCTL¨º» ÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k«¹ör+rr§¢×\ ²¥)à¡òâ²Ñ®®æ§v)í é²Æ xb)Üç^jX§yÊ'µ¨§x5%9,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þ騽ç_®¢éÉ©l¢Ç§vØ^ BÏr¦jw_¢º- êâú+«b¢ybë.nÇ+¸§
Re: Difference between connect internal and connect / as sysdba in sqlplus
'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 Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Difference between connect internal and connect / as sysdba in sqlplus
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-xEÀ
+ ;)zYb
.+-êîjwbØ^ë,j86"Énuæ¥w¢{Zx§CRP "Ä.í
éÚê ¨¥x%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm
áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*') ²æìr¸x
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
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 kopi
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).
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).
RE: Connecting as sysdba via ODBC / VB
Alex, Got it from Technet under downloads. Bruce Reardon -Original Message- Sent: Thursday, 13 June 2002 5:53 >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 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 "/ as sysdba" and "/ as sysoper". The "as sysdba" and "as sysoper" string can also be contained in the password field. (Bug 2114033) Added support for the statement attribute SQL_ATTR_RETRIEVE_DATA. (Bug 2165706) ODBC 8.1.7.5.0 Added support for / syntax to be used as username to log on. (as requested by Bug 1094170) " I hope this might be of use and perhaps will work via OCI etc from VB. HTH, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Connecting as sysdba via ODBC / VB
>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 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 "/ as sysdba" and "/ as sysoper". The "as sysdba" and "as sysoper" string can also be contained in the password field. (Bug 2114033) Added support for the statement attribute SQL_ATTR_RETRIEVE_DATA. (Bug 2165706) ODBC 8.1.7.5.0 Added support for / syntax to be used as username to log on. (as requested by Bug 1094170) " I hope this might be of use and perhaps will work via OCI etc from VB. HTH, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Alex Hillman 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).
Connecting as sysdba via ODBC / VB
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 "/ as sysdba" and "/ as sysoper". The "as sysdba" and "as sysoper" string can also be contained in the password field. (Bug 2114033) Added support for the statement attribute SQL_ATTR_RETRIEVE_DATA. (Bug 2165706) ODBC 8.1.7.5.0 Added support for / syntax to be used as username to log on. (as requested by Bug 1094170) " I hope this might be of use and perhaps will work via OCI etc from VB. HTH, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: connect as SYSDBA using ADO
>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 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 07, 2002 3:47 PM > 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-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: Jay 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).
connect as SYSDBA using ADO
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-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: grant sysdba rights
Yes I'm assuming that you have not changed anything in the sqlnet.ora file ;-) that is the parameter sqlnet.authentication_service = (NTS) "use Windows NT native authentication" [EMAIL PROTECTED] wrote: we have W2K platformso if i understand correctly i put my 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 are on.Unix :When the oracle software was installed you where asked about a Unix group (normally called dba) that has privilegesthis group is then compiled and linked into the Oracle executable.When member of this group you can connect with "/ as sysdba" and from there grant sysdba to the userNT :Since it is not possible to relink the code on NT the group is hard coded to "ORA_DBA" on NT/W2KWhen member of this group you can connect with "/ as sysdba" and from there grant sysdba to the userVMS :Here it is a system logical that i don't remember the name off ( Michael / Mogens pleas help )When having this logical set you can connect with "/ as sysdba" and from there grant sysdba to the userMVS :Help ???[EMAIL PROTECTED] wrote: Hi listWhen 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 thesysdba role to other accounts ??thanksvr. gr.g.g. korrdw ict groningen -- /regardsPeter GramMobil : +45 2527 7107Fax : +45 4466 8856Miracle A/SKratvej 22760 Måløvhttp://miracleas.dk-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Peter Gram INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram 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: grant sysdba rights
That's right! Though some people have still had problems when the ORA_DBA group is not listed *first* when looking at their user account under the Users & Passwords dialogue. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -Original Message- Sent: 15 May 2002 12:10 To: Multiple recipients 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 of list ORACLE-L > Onderwerp:Re: grant sysdba rights > > > The answer depends on what O/S you are on. > > Unix : > When the oracle software was installed you where asked about a Unix > group (normally called dba) that has privileges > this group is then compiled and linked into the Oracle executable. > When member of this group you can connect 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 that i don't remember the name off ( > Michael / Mogens pleas help ) > When having this logical set you can connect with "/ as sysdba" and > from there grant sysdba to the user > > MVS : > Help ??? > > [EMAIL PROTECTED] wrote: > > >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 > > > > > > -- > > /regards > > Peter Gram > > Mobil : +45 2527 7107 > Fax : +45 4466 8856 > > Miracle A/S > Kratvej 2 > 2760 Måløv > http://miracleas.dk > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Gram > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: grant sysdba rights
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 ORACLE-L > Onderwerp:Re: grant sysdba rights > > > The answer depends on what O/S you are on. > > Unix : > When the oracle software was installed you where asked about a Unix > group (normally called dba) that has privileges > this group is then compiled and linked into the Oracle executable. > When member of this group you can connect 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 that i don't remember the name off ( > Michael / Mogens pleas help ) > When having this logical set you can connect with "/ as sysdba" and > from there grant sysdba to the user > > MVS : > Help ??? > > [EMAIL PROTECTED] wrote: > > >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 > > > > > > -- > > /regards > > Peter Gram > > Mobil : +45 2527 7107 > Fax : +45 4466 8856 > > Miracle A/S > Kratvej 2 > 2760 Måløv > http://miracleas.dk > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Gram > 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: grant sysdba rights
The answer depends on what O/S you are on. Unix : When the oracle software was installed you where asked about a Unix group (normally called dba) that has privileges this group is then compiled and linked into the Oracle executable. When member of this group you can connect 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 that i don't remember the name off ( Michael / Mogens pleas help ) When having this logical set you can connect with "/ as sysdba" and from there grant sysdba to the user MVS : Help ??? [EMAIL PROTECTED] wrote: >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 > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram 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).
grant sysdba rights
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 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 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).
sysdba
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).
sysdba and sysoper roles
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
