Re: Binary Search in Oracle
the syntax is something like SELECT id,parentid from taxonomy START WITH parentid='x003' CONNECT BY PRIOR id = parentid which returns all related rows under a particular row does anyone know how to get all related rows above a particular row Thank You, Gavin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 12:03 PM > Does any one remember the syntax for a binary search say you have an id > column and a parentid column Oracle can fetch all the ids either > ascending or descending given a particular id. This is performed a s a > binary tree search > > anyone remembers the syntax ? > > Thank you > > Gavin > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gavin D'mello > 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: Gavin D'mello 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).
Binary Search in Oracle
Does any one remember the syntax for a binary search say you have an id column and a parentid column Oracle can fetch all the ids either ascending or descending given a particular id. This is performed a s a binary tree search anyone remembers the syntax ? Thank you Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'mello 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: Web DB 2.5 listener always hung for Oracle HRMS applications
Hi Hemant, Thanks for supplying the correct article number. I'll look into it. Even if my web 2.5 listener is up and running (see below), my users still cannot logon to the Oracle Applications. The listener just hung. # ps -ef | grep 8000 orahrms 4406 4404 0 07:25:03 ?0:03 wdblsnr orion 8000 orahrms 4404 1 0 07:25:03 ?0:00 /bin/csh -f /dg2/oracle/nieora/8.0.6/bin/wdbstart orion 8000 orahrms 7279 7271 0 13:53:45 pts/10:00 grep 8000 The problem can be solved by bouncing the listener. Qn : Has anyone using "Oracle HRMS V11.5.1" migrated from WebDB to Apache listener before ? How's the performance ? Does the apache listener "hung" ? Please advise. Thank you. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 12:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: Web DB 2.5 listener always hung for Oracle HRMS applicationsV11. Catherine, You have the wrong note. Look up Note 119873.1 titled "Apache Single Listener Configuration for Applications 11.5.1" I don't know how you are using the "at" command to startup the servers. I didn't suggest that the forms server and reports server die. I was talking of the WebDB listener specifically ! WebDB2.2 handles forms sign-ons while 2.5 handles online help and personal home page and self-service modules. Note 113254.1 refers to the Forms Server/Reports Server/ WebDB 2.2 dying because of the wrong shell. You need to check the shell your WebDB 2.5 runs from. Note 144400.1 covers WebDB 2.5 as well. Do a "ps -ef" to see if the process is running. Remember that WebDB 2.2 and 2.5 have different startup scripts and process names. I do remember seeing WebDB 2.5 "die by itself" occassionally. We had a cron job running the webdb startup script periodically. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> 21/02/2002 12:14 PM To: CHITALE Hemant Krishnarao/IT/CHRT/ST Group@ST Domain, "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: Subject: RE: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Hemant, Please ignore my earlier email. We use the at command to startup all our form server/report server/webdb listener etc so that even if we were to logout of the telnet session where the WebDB listener is started. The form server/report server/listener will not "hung"/"died" because the parent shell has died. Why don't you migrate from WebDB to Apache ? I've found the document in metalink "Note:154666.1 => Moving virtual directory mappings from WebDB to iAS". Thanks. Qn : Has anyone using "Oracle HRMS V11.5.1" migrated from WebDB to Apache before ? How's the performance ? Does the apache listener "hung" ? Please advise. Thank you. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Catherine, Why don't you migrate from WebDB to Apache ?. There is excellent documentation on migrating from WebDB to Apache for 11i. Your WebDB listener could be "hung" if it is running in the wrong shell -- eg if you logout of the telnet session where the WebDB listener was started, you will
RE: Web DB 2.5 listener always hung for Oracle HRMS applications V11.
Catherine, You have the wrong note. Look up Note 119873.1 titled "Apache Single Listener Configuration for Applications 11.5.1" I don't know how you are using the "at" command to startup the servers. I didn't suggest that the forms server and reports server die. I was talking of the WebDB listener specifically ! WebDB2.2 handles forms sign-ons while 2.5 handles online help and personal home page and self-service modules. Note 113254.1 refers to the Forms Server/Reports Server/ WebDB 2.2 dying because of the wrong shell. You need to check the shell your WebDB 2.5 runs from. Note 144400.1 covers WebDB 2.5 as well. Do a "ps -ef" to see if the process is running. Remember that WebDB 2.2 and 2.5 have different startup scripts and process names. I do remember seeing WebDB 2.5 "die by itself" occassionally. We had a cron job running the webdb startup script periodically. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>21/02/2002 12:14 PM To: CHITALE Hemant Krishnarao/IT/CHRT/ST Group@ST Domain, "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: Subject: RE: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Hemant, Please ignore my earlier email. We use the at command to startup all our form server/report server/webdb listener etc so that even if we were to logout of the telnet session where the WebDB listener is started. The form server/report server/listener will not "hung"/"died" because the parent shell has died. Why don't you migrate from WebDB to Apache ? I've found the document in metalink "Note:154666.1 => Moving virtual directory mappings from WebDB to iAS". Thanks. Qn : Has anyone using "Oracle HRMS V11.5.1" migrated from WebDB to Apache before ? How's the performance ? Does the apache listener "hung" ? Please advise. Thank you. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Catherine, Why don't you migrate from WebDB to Apache ?. There is excellent documentation on migrating from WebDB to Apache for 11i. Your WebDB listener could be "hung" if it is running in the wrong shell -- eg if you logout of the telnet session where the WebDB listener was started, you will see subsequents requests to the listener failing. This is because the parent shell has died. If you are starting it from the Bourne shell, try switching to Korn shell before starting it (or vice versa). Check whether the startup script calls "nohup wdblsnr &". Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> 21/02/2002 10:13 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Gurus, We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun servers. OS is Solaris 2.6 1st server contains the database, concurrent manager and report server. 2nd server contains the apache l
Re[2]: Oracle Licensing - Concurrent users
Wednesday, February 20, 2002, 5:58:19 PM, you wrote: KL> For example, we support a 911 center. An Oracle-based application KL> displays the caller's information on a screen to the call taker. If you KL> look in our database, you will see one user - it is the connection made by KL> the software that displays the caller's info. The app maintains one KL> connection and displays the data on the appropriate screen. Oracle is KL> trying to tell us the the 911 callers are the "users". Give me a break! At KL> best, the call takers might be the users. Oracle once tried to sell me a license for every resident in the City of Columbus too, and for much the same reason. This was for a dial-up interactive voice-response system. It took me awhile, but I eventually got hold of a sales person with a CLUE, and we ended counting each incomming phone line as a user. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: Web DB 2.5 listener always hung for Oracle HRMS applications
Hi Hemant, Please ignore my earlier email. We use the at command to startup all our form server/report server/webdb listener etc so that even if we were to logout of the telnet session where the WebDB listener is started. The form server/report server/listener will not "hung"/"died" because the parent shell has died. Why don't you migrate from WebDB to Apache ? I've found the document in metalink "Note:154666.1 => Moving virtual directory mappings from WebDB to iAS". Thanks. Qn : Has anyone using "Oracle HRMS V11.5.1" migrated from WebDB to Apache before ? How's the performance ? Does the apache listener "hung" ? Please advise. Thank you. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Subject:Re: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Catherine, Why don't you migrate from WebDB to Apache ?. There is excellent documentation on migrating from WebDB to Apache for 11i. Your WebDB listener could be "hung" if it is running in the wrong shell -- eg if you logout of the telnet session where the WebDB listener was started, you will see subsequents requests to the listener failing. This is because the parent shell has died. If you are starting it from the Bourne shell, try switching to Korn shell before starting it (or vice versa). Check whether the startup script calls "nohup wdblsnr &". Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> 21/02/2002 10:13 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Gurus, We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun servers. OS is Solaris 2.6 1st server contains the database, concurrent manager and report server. 2nd server contains the apache listener, TCF SERVER, Web DB 2.5 listener, Web DB 2.2 Listener and Form server listener. Qn : The Web DB 2.5 listener always hung. Is there a way to solve the problem ? Is anyone having the same configurations as me with no problem ? Please help. Thanks I've checked the network roundtrip between the 2 servers using tnsping=>fast, no bottlenecks I've checked the number of processes in the database : it's only 26 concurrent users (26ok I've checked the 1st and 2nd server resources using vmstat and iostat : There are enough memory => no bottlenecks Oracle consultants claim that there is bug in the Web DB 2.5 listener (Version is "adwdbctl.sh.UNIX 115.1 2000/05/01 17:35:52"). The only solution is to bounce the web listener when the problem arises. We even schedule a job to bounce the listener at 7am and 1pm but that does not solve the problem. Sometimes, I still have to bounce the web listener manually when user reports the problem. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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 inform
RE: Web DB 2.5 listener always hung for Oracle HRMS applications
Hi Hemant, We use the at command to startup all our form server/report server/webdb listener etc so that even if we were to logout of the telnet session where the WebDB listener is started. The form server/report server/listener will not "hung"/"died" because the parent shell has died. Why don't you migrate from WebDB to Apache ? I've found the document in metalink "Note:154666.1 => Moving virtual directory mappings from WebDB to iAS". Thanks. Qn : Has anyone using "Oracle HRMS V11.5.1" migrated from WebDB to Apache before ? How's the performance ? Does the apache listener "hung" ? Please advise. Thank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 11:10 AM To: CHAN Chor Ling Catherine (CSC) Cc: [EMAIL PROTECTED] Subject:Re: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Catherine, Why don't you migrate from WebDB to Apache ?. There is excellent documentation on migrating from WebDB to Apache for 11i. Your WebDB listener could be "hung" if it is running in the wrong shell -- eg if you logout of the telnet session where the WebDB listener was started, you will see subsequents requests to the listener failing. This is because the parent shell has died. If you are starting it from the Bourne shell, try switching to Korn shell before starting it (or vice versa). Check whether the startup script calls "nohup wdblsnr &". Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> 21/02/2002 10:13 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Gurus, We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun servers. OS is Solaris 2.6 1st server contains the database, concurrent manager and report server. 2nd server contains the apache listener, TCF SERVER, Web DB 2.5 listener, Web DB 2.2 Listener and Form server listener. Qn : The Web DB 2.5 listener always hung. Is there a way to solve the problem ? Is anyone having the same configurations as me with no problem ? Please help. Thanks I've checked the network roundtrip between the 2 servers using tnsping=>fast, no bottlenecks I've checked the number of processes in the database : it's only 26 concurrent users (26ok I've checked the 1st and 2nd server resources using vmstat and iostat : There are enough memory => no bottlenecks Oracle consultants claim that there is bug in the Web DB 2.5 listener (Version is "adwdbctl.sh.UNIX 115.1 2000/05/01 17:35:52"). The only solution is to bounce the web listener when the problem arises. We even schedule a job to bounce the listener at 7am and 1pm but that does not solve the problem. Sometimes, I still have to bounce the web listener manually when user reports the problem. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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 subscr
Re: Web DB 2.5 listener always hung for Oracle HRMS applications V11.
Catherine, Why don't you migrate from WebDB to Apache ?. There is excellent documentation on migrating from WebDB to Apache for 11i. Your WebDB listener could be "hung" if it is running in the wrong shell -- eg if you logout of the telnet session where the WebDB listener was started, you will see subsequents requests to the listener failing. This is because the parent shell has died. If you are starting it from the Bourne shell, try switching to Korn shell before starting it (or vice versa). Check whether the startup script calls "nohup wdblsnr &". Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>21/02/2002 10:13 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Gurus, We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun servers. OS is Solaris 2.6 1st server contains the database, concurrent manager and report server. 2nd server contains the apache listener, TCF SERVER, Web DB 2.5 listener, Web DB 2.2 Listener and Form server listener. Qn : The Web DB 2.5 listener always hung. Is there a way to solve the problem ? Is anyone having the same configurations as me with no problem ? Please help. Thanks I've checked the network roundtrip between the 2 servers using tnsping=>fast, no bottlenecks I've checked the number of processes in the database : it's only 26 concurrent users (26ok I've checked the 1st and 2nd server resources using vmstat and iostat : There are enough memory => no bottlenecks Oracle consultants claim that there is bug in the Web DB 2.5 listener (Version is "adwdbctl.sh.UNIX 115.1 2000/05/01 17:35:52"). The only solution is to bounce the web listener when the problem arises. We even schedule a job to bounce the listener at 7am and 1pm but that does not solve the problem. Sometimes, I still have to bounce the web listener manually when user reports the problem. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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).
11i ???
Hi, Many thanks to those who answered my Oracle financial question. Also, is Oracle 11i downloadable somewhere? Any documentations available? Thank you! Janet __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
Web DB 2.5 listener always hung for Oracle HRMS applications V11.
Hi Gurus, We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun servers. OS is Solaris 2.6 1st server contains the database, concurrent manager and report server. 2nd server contains the apache listener, TCF SERVER, Web DB 2.5 listener, Web DB 2.2 Listener and Form server listener. Qn : The Web DB 2.5 listener always hung. Is there a way to solve the problem ? Is anyone having the same configurations as me with no problem ? Please help. Thanks I've checked the network roundtrip between the 2 servers using tnsping=>fast, no bottlenecks I've checked the number of processes in the database : it's only 26 concurrent users (26ok I've checked the 1st and 2nd server resources using vmstat and iostat : There are enough memory => no bottlenecks Oracle consultants claim that there is bug in the Web DB 2.5 listener (Version is "adwdbctl.sh.UNIX 115.1 2000/05/01 17:35:52"). The only solution is to bounce the web listener when the problem arises. We even schedule a job to bounce the listener at 7am and 1pm but that does not solve the problem. Sometimes, I still have to bounce the web listener manually when user reports the problem. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Oracle Licensing - Concurrent users
Nuclear Plant? Don't say Larry didn't warn you: "The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the Programs." >From "Title and Copyright Information" for "Getting to Know 8i (8.1.6)" S- On Wed, 20 Feb 2002, Kevin Lange wrote: > For one last 2 cents worth . same for my last employer. Even though > there were only 4 entry stations into the Radiation Protected Area of the > Nuclear Plant, all employees who were eligible to enter that area was > considered a user. Instead of 4, we had to have 1000 licenses. At least > Oracle is consistent in their greed... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo 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: Oracle Licensing - Concurrent users
For one last 2 cents worth . same for my last employer. Even though there were only 4 entry stations into the Radiation Protected Area of the Nuclear Plant, all employees who were eligible to enter that area was considered a user. Instead of 4, we had to have 1000 licenses. At least Oracle is consistent in their greed... -Original Message- Sent: Wednesday, February 20, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Actually this came up during our license evaluation as well. We tried to go with named users, but there was a catch. We process transactions from a sort of clearinghouse. That clearinghouse is a single network connection, and we process transactions with a small number of Oracle sessions. From my perspective, we had 5 sessions performing OLTP from a single source. From Oracle's perspective a user has to be determined in the "broadest scope possible" (That is straight from the license agreement). The result was that since our clearinghouse was intermittently connected to 50,000 pharmacies, we would require over 50,000 named users. Steve McClure -Original Message- Chris Sent: Wednesday, February 20, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I don't think it was Oracle telling you that, it was the sales guy trying to get his vacation paid for -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To R
RE: Dropping table space where name is lower case
Thanks to everyone for their quick responses, putting spatial in double quotes does the job. -Original Message- Sent: February 20, 2002 12:19 PM To: Multiple recipients of list ORACLE-L I am unable to drop a tablespace that I created. I created the tablespace with a lower case name, when I do a select * from dba_tablespaces the name is lowercase as opposed to uppercase. When I "drop tablespace spatial" oracle gives the following error message : ORA-00959: tablespace 'SPATIAL' does not exist This is oracle 8.1.7.2.? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: Browett, Darren 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: how to kill Distributed transaction
I dont remember it correctly, but you have to look at some id in the dba_2pc_pending table, and then do a commit or a rollback with the force option and pass that id number as a parameter. This did not work for me sometimes in the past, and then I had to do a use a .purge_lost_dbentry(id) or something. I dont remember the package name or the exact procedure name. Search on Metalink for purging distributed transactions. Raj [EMAIL PROTECTED] .tenet.edu To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: how to kill Distributed transaction February 20, 2002 03:38 PM Please respond to ORACLE-L Do you have a transaction hanging on another database? Any entries in any of the alert logs for the participants? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Harvinder Singh aTech.com> cc: Sent by:Subject: how to kill Distributed transaction [EMAIL PROTECTED] 02/20/2002 12:53 PM Please respond to ORACLE-L Hi, We have 1 transaction hanging even if we restart the database. there is 1 entry in table dba_2pc_pending and 2 entries in dba_2pc_neighbours... How to release this transaction Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: 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: Oracle Licensing - Concurrent users
OH YEAH? Wait til Unca Lar is in charge of all biometric data for every human on earth. 6.2 Billion users. He's gonna catch up to Bill Gates if he has to destroy civil liberties world wide to do it. Wallet envy. Bambi. -Original Message- Sent: Wednesday, February 20, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Can you immagine living in a city of 1.6 million . you would have to have 1.6 million licenses because each one of you is a potential caller of 911 Not even Oracle is THAT greedy. Think, user = software user. i.e. the call takers, not the call makers. -Original Message- Sent: Wednesday, February 20, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I don't think it was Oracle telling you that, it was the sales guy trying to get his vacation paid for -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Grabowy, Chris 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
RE: Dropping table space where name is lower case
Title: RE: Dropping table space where name is lower case What are the ...'s for? -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: Dropping table space where name is lower case Darren, Have you tried this *exact* syntax: drop tablespace "spatial" 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- Darren Sent: 20 February 2002 20:19 To: Multiple recipients of list ORACLE-L I am unable to drop a tablespace that I created. I created the tablespace with a lower case name, when I do a select * from dba_tablespaces the name is lowercase as opposed to uppercase. When I "drop tablespace spatial" oracle gives the following error message : ORA-00959: tablespace 'SPATIAL' does not exist This is oracle 8.1.7.2.? Thanks Darren -- Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: Dropping table space where name is lower case
Try putting the word spatial in double quotes. -- 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:RE: Oracle Licensing - Concurrent users
Dave, I think that's the number of days since X-mas of the sales droid's birth year. Otherwise how do you explain the variability of their quotes? :-) Dick Goulet Reply Separator Author: "Farnsworth; Dave" <[EMAIL PROTECTED]> Date: 2/20/2002 12:19 PM >From following this thread on Oracles pricing scheme I think it is dependent on the day of the week, the phase of the moon, the number of salmon spawning in Alaska and how many days till X-mas. Dave -Original Message- Sent: Wednesday, February 20, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Jay: From past experience, "Named Users" refers to the users of the application, meaning for you the 911 operators. In the past, "users" referred to connections to the database. Thus an application may only have one user but several thousand connections. We had this problem when implementing CICS for Oracle on the mainframe. Even Tuxedo on client/server has this issue. These transaction monitors act as gates to the Oracle world. We had to price average usage amount to accommodate our Oracle licensing. Hope this helps. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
RE: Dropping table space where name is lower case
Darren, did you try drop tablespace "spatial";<=== including the double quotes at least this works when tables are created with lower case letters. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 20, 2002 3:19 PM To: Multiple recipients of list ORACLE-L I am unable to drop a tablespace that I created. I created the tablespace with a lower case name, when I do a select * from dba_tablespaces the name is lowercase as opposed to uppercase. When I "drop tablespace spatial" oracle gives the following error message : ORA-00959: tablespace 'SPATIAL' does not exist This is oracle 8.1.7.2.? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: how to kill Distributed transaction
Do you have a transaction hanging on another database? Any entries in any of the alert logs for the participants? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Harvinder Singh aTech.com> cc: Sent by:Subject: how to kill Distributed transaction [EMAIL PROTECTED] 02/20/2002 12:53 PM Please respond to ORACLE-L Hi, We have 1 transaction hanging even if we restart the database. there is 1 entry in table dba_2pc_pending and 2 entries in dba_2pc_neighbours... How to release this transaction Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: Oracle Licensing - Concurrent users
More likely how close Uncle Larry is to Bill Gates in the World's Richest Man contest. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 > -Original Message- > From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] > > From following this thread on Oracles pricing scheme I think it is dependent on the >day of the week, the phase of the moon, the number of salmon spawning in Alaska and >how many days till X-mas. > > Dave > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI 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: Oracle Licensing - Concurrent users
Actually this came up during our license evaluation as well. We tried to go with named users, but there was a catch. We process transactions from a sort of clearinghouse. That clearinghouse is a single network connection, and we process transactions with a small number of Oracle sessions. From my perspective, we had 5 sessions performing OLTP from a single source. From Oracle's perspective a user has to be determined in the "broadest scope possible" (That is straight from the license agreement). The result was that since our clearinghouse was intermittently connected to 50,000 pharmacies, we would require over 50,000 named users. Steve McClure -Original Message- Chris Sent: Wednesday, February 20, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I don't think it was Oracle telling you that, it was the sales guy trying to get his vacation paid for -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Grabowy, Chris 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: Steve McClure INET: [EMAIL PROTECTED] Fat
RE: Dropping table space where name is lower case
Title: RE: Dropping table space where name is lower case Put the tablespace name in quotes. -Original Message- From: Browett, Darren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Dropping table space where name is lower case I am unable to drop a tablespace that I created. I created the tablespace with a lower case name, when I do a select * from dba_tablespaces the name is lowercase as opposed to uppercase. When I "drop tablespace spatial" oracle gives the following error message : ORA-00959: tablespace 'SPATIAL' does not exist This is oracle 8.1.7.2.? Thanks Darren -- Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: Dropping table space where name is lower case
try putting double quotes around the name of the tablespace Pat > > I am unable to drop a tablespace that I created. > > I created the tablespace with a lower case name, when I do a select * from > dba_tablespaces the name > is lowercase as opposed to uppercase. > > When I "drop tablespace spatial" oracle gives the following error message : > > ORA-00959: tablespace 'SPATIAL' does not exist > > This is oracle 8.1.7.2.? > > Thanks > > Darren > > > -- > Darren Browett P.Eng This message > was transmitted > Data Administratorusing 100% > recycled electrons > Information and Communication Technology > City of Coquitlam > P:(604)927 - 3614 > E:[EMAIL PROTECTED] > > --- > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Browett, Darren > 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: Pat Hildebrand 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: Dropping table space where name is lower case
Put the tablespace name in double quotes: drop tablespace "spatial"; "Browett, Darren" wrote: > I am unable to drop a tablespace that I created. > > I created the tablespace with a lower case name, when I do a select * from > dba_tablespaces the name > is lowercase as opposed to uppercase. > > When I "drop tablespace spatial" oracle gives the following error message : > > ORA-00959: tablespace 'SPATIAL' does not exist > > This is oracle 8.1.7.2.? > > Thanks > > Darren > > > -- > Darren Browett P.EngThis message > was transmitted > Data Administrator using 100% > recycled electrons > Information and Communication Technology > City of Coquitlam > P:(604)927 - 3614 > E:[EMAIL PROTECTED] > > --- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Browett, Darren > 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: Dropping table space where name is lower case
Darren, Have you tried this *exact* syntax: drop tablespace "spatial" 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- Darren Sent: 20 February 2002 20:19 To: Multiple recipients of list ORACLE-L I am unable to drop a tablespace that I created. I created the tablespace with a lower case name, when I do a select * from dba_tablespaces the name is lowercase as opposed to uppercase. When I "drop tablespace spatial" oracle gives the following error message : ORA-00959: tablespace 'SPATIAL' does not exist This is oracle 8.1.7.2.? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: Dropping table space where name is lower case
Darren, You should use quotes: drop tablespace "spatial"; Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 3:18 PM > I am unable to drop a tablespace that I created. > > I created the tablespace with a lower case name, when I do a select * from > dba_tablespaces the name > is lowercase as opposed to uppercase. > > When I "drop tablespace spatial" oracle gives the following error message : > > ORA-00959: tablespace 'SPATIAL' does not exist > > This is oracle 8.1.7.2.? > > Thanks > > Darren > > -- -- > -- > Darren Browett P.Eng This message > was transmitted > Data Administrator using 100% > recycled electrons > Information and Communication Technology > City of Coquitlam > P:(604)927 - 3614 > E:[EMAIL PROTECTED] > -- -- > --- > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Browett, Darren > 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: Igor Neyman 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: Solaris Kernel Memory Parameters Recommendations?
Details about semaphores & shared memory and how to calculate those values was once published in SunWorld Online, but the links I have are no longer valid. Based on the info in those docs, here's what I derived Suzy * -- * Semaphores/Shared Memory for ORACLE * -- * shmmax = max size per shared memory segment * shmmin = min size per shared memory segment * shmmni = max num shared memory identifiers * shmseg = max num shared memory segments per process * semmns = max num semaphores system wide (=semmni*semmsl) * semmni = max num semaphore sets system wide (=semmnu) * semmsl = max num semaphores per semaphore set (=semopm) * semmnu = max num sempahore undo structures (=semmni) * semmap = max entries per semaphore map (=semmni*semmsl) * semopm = max operations per semop call (=semmsl) * semume = max undo entries per process * semvmx = max value of a semaphore (cannot be > 32767) forceload: sys/shmsys forceload: sys/semsys set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmns=4000 set semsys:seminfo_semmni=40 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmnu=40 set semsys:seminfo_semmap=4000 set semsys:seminfo_semopm=100 set semsys:seminfo_semume=100 set semsys:seminfo_semvmx=32767 [EMAIL PROTECTED] wrote: > > In addition to what you've already received, I would include settting > SEMMNU (semaphore undo structures ) equal to SEMMNI. > > Not doing so can cause rather baffling errors at the OS level at times. > > Jared > > David Wagoner <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 02/19/02 12:04 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Solaris Kernel Memory Parameters Recommendations? > > I've read a couple of brief passages about setting the kernel memory > parameters in UNIX that are required for an Oracle installation. The > information found on MetaLink and in the Oracle 9i installation guide are > brief at best and somewhat confusing for a non-UNIX-sys admin. like > myself. Would some of you more experienced UNIX/Oracle DBAs please > provide a plain English explanation describing your strategy in setting > the following 7 parameters in the /etc/system file: > > SEMMNI > SEMMNS > SEMMSL > SHMMAX > SHMMIN > SHMMNI > SHMSEG > > To use a simple example, let's say the server has 1 GB of RAM to work > with. > > Thanks in advance for sharing, > > david > > David B. Wagoner > Database Administrator > Arsenal Digital Solutions Worldwide, Inc. > 8000 Regency Parkway, Suite 110 > Cary, NC 27511-8582 > Tel. (919) 466-6723 > Fax (919) 466-6783 > Mobile (919) 225-4962 > [EMAIL PROTECTED] > http://www.arsenaldigital.com/ > > *** NOTICE *** > This e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is privileged, work > product or exempt from disclosure under applicable law. If you have > received this message in error, or are not the named recipient(s), please > immediately notify the sender by phone or email and delete this e-mail > message from your computer. Thank you. > > > -- > 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: Suzy Vordos 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:RE: Oracle Licensing - Concurrent users
Chris, From Oracle's store site: Named User: is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time. A non human operated device will be counted as a Named User in addition to all individuals authorized to use the programs, if such devices can access the programs. If multiplexing hardware or software (e.g., a TP monitor or a web server product) is used, this number must be measured at the multiplexing front end. Now with your 911 center, if your using a backend processor to refresh the screens then all of your screens are in fact users. I know, kind of overkill, but we've had to count each and every bar code scanner we had on the assembly line as each one is a "user". End result, we went with CPU licensing. Fewer items to count (CPU's) and ended up cheaper as well. Nothing like the bear taking a large hunk out of your back side! OH, that HURTS! Dick Goulet Reply Separator Author: "Grabowy; Chris" <[EMAIL PROTECTED]> Date: 2/20/2002 12:03 PM I don't think it was Oracle telling you that, it was the sales guy trying to get his vacation paid for -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Grabowy, Chris 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 mailin
Re: Dropping table space where name is lower case
Put double quotes around it... drop tablespace "spatial" "Browett, Darren" wrote: > > I am unable to drop a tablespace that I created. > > I created the tablespace with a lower case name, when I do a select * from > dba_tablespaces the name > is lowercase as opposed to uppercase. > > When I "drop tablespace spatial" oracle gives the following error message : > > ORA-00959: tablespace 'SPATIAL' does not exist > > This is oracle 8.1.7.2.? > > Thanks > > Darren > > > -- > Darren Browett P.EngThis message > was transmitted > Data Administrator using 100% > recycled electrons > Information and Communication Technology > City of Coquitlam > P:(604)927 - 3614 > E:[EMAIL PROTECTED] > > --- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Browett, Darren > 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: Dennis M. Heisler 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: Dropping table space where name is lower case
Try: drop tablespace "spatial" -Original Message- Sent: Wednesday, February 20, 2002 3:19 PM To: Multiple recipients of list ORACLE-L I am unable to drop a tablespace that I created. I created the tablespace with a lower case name, when I do a select * from dba_tablespaces the name is lowercase as opposed to uppercase. When I "drop tablespace spatial" oracle gives the following error message : ORA-00959: tablespace 'SPATIAL' does not exist This is oracle 8.1.7.2.? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: Khedr, Waleed 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: Oracle Licensing - Concurrent users
Can you immagine living in a city of 1.6 million . you would have to have 1.6 million licenses because each one of you is a potential caller of 911 Not even Oracle is THAT greedy. Think, user = software user. i.e. the call takers, not the call makers. -Original Message- Sent: Wednesday, February 20, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I don't think it was Oracle telling you that, it was the sales guy trying to get his vacation paid for -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Grabowy, Chris 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: Kevin Lange 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
RE: Oracle Licensing - Concurrent users
>From following this thread on Oracles pricing scheme I think it is dependent on the >day of the week, the phase of the moon, the number of salmon spawning in Alaska and >how many days till X-mas. Dave -Original Message- Sent: Wednesday, February 20, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Jay: From past experience, "Named Users" refers to the users of the application, meaning for you the 911 operators. In the past, "users" referred to connections to the database. Thus an application may only have one user but several thousand connections. We had this problem when implementing CICS for Oracle on the mainframe. Even Tuxedo on client/server has this issue. These transaction monitors act as gates to the Oracle world. We had to price average usage amount to accommodate our Oracle licensing. Hope this helps. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Licensing - Concurrent users In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Karniotis, Stephen 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
Dropping table space where name is lower case
I am unable to drop a tablespace that I created. I created the tablespace with a lower case name, when I do a select * from dba_tablespaces the name is lowercase as opposed to uppercase. When I "drop tablespace spatial" oracle gives the following error message : ORA-00959: tablespace 'SPATIAL' does not exist This is oracle 8.1.7.2.? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: Oracle Licensing - Concurrent users
Title: RE: Oracle Licensing - Concurrent users Maybe it has something to do with whether you post your data to an internet or intranet site. ?? -Original Message- From: Steve McClure [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Licensing - Concurrent users Our Oracle rep fully understood that our DB is accessed via our intranet, a large third party network, and the internet. We were only required to purchase CPU based licensing. There was no additional "Web" licensing fee. After reading this, I am concerned they will be back to discuss more fees. Steve McClure -Original Message- Sent: Wednesday, February 20, 2002 9:30 AM To: Multiple recipients of list ORACLE-L Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure 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: Oracle Licensing - Concurrent users
I don't think it was Oracle telling you that, it was the sales guy trying to get his vacation paid for -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Grabowy, Chris 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: A question for people who also know Sybase
Jared, I tried the first 3 and didn't get any answer. Since we are an Oracle shop and not a Sybase shop, we don't have any Sybase support. So I posted here because somebody would have used Oracle Transparent Gateway with Sybase. -Original Message- Sent: Wednesday, February 20, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Ok, this really is an Oracle list, believe it or not. Why not?: a) do a google search b) join a sybase list c) hit the sybase tech support site d) file a support request with sybase. Jared "Bala, Prakash" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/20/02 09:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:A question for people who also know Sybase Hi, Oracle 8.1.7.2 and Sybase 12.0 client on Solaris 2.8 We are trying to access 7 remote Sybase databases (all on NT) using a Sybase client (Adaptive Server Enterprise 12.0) installed on Solaris. Have converted the IP addresses and the port numbers to Hexadecimal and have made the necessary changes to the 'interfaces' file on our Unix box. We are able to successfully connect to 5 databases and retrieve data using isql. But we get the following error for the remaining 2 sites when I issue the isql command: CT-LIBRARY error: ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed We are able to ping these 2 servers and also do the 'traceroute' successfully. Also, I am able to connect to these 2 locations using the Sybase client on my workstation. This verifies that the IP address, port#, user-id and password are correct. Just the connection through Unix fails and have to make this work so that our Oracle database can talk to Sybase using the Oracle Gateway. Oracle Gateway is able to retrieve data from the remaining 5 Sybase servers. TIA! Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash 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: Bala, Prakash 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).
How to remove java from 8.1.6 on NT 4.0?
Hi All, How to remove java from 8.1.6 on NT 4.0? I do not have a file rmjava.sql or anything like it. MetaLink says this is the file to use to remove it. Can someone clarify on how to remove java? Thanks Rick -- 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: Oracle Licensing - Concurrent users
Jay: From past experience, "Named Users" refers to the users of the application, meaning for you the 911 operators. In the past, "users" referred to connections to the database. Thus an application may only have one user but several thousand connections. We had this problem when implementing CICS for Oracle on the mainframe. Even Tuxedo on client/server has this issue. These transaction monitors act as gates to the Oracle world. We had to price average usage amount to accommodate our Oracle licensing. Hope this helps. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, February 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Licensing - Concurrent users In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Karniotis, Stephen 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: Oracle Licensing - Concurrent users
There are only 2 license types: named user and CPU. There isn't any 'web' licensing. Oracle will require you to purchase the CPU license for systems that: 1) are on the internet 2) on the intranet, unless all employees are covered under a site license 3) feed other database systems 4) subject to interpretation of your local sales critter, and highly dependant on the size of their boat payment. Jared "Steve McClure" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/20/02 10:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle Licensing - Concurrent users Our Oracle rep fully understood that our DB is accessed via our intranet, a large third party network, and the internet. We were only required to purchase CPU based licensing. There was no additional "Web" licensing fee. After reading this, I am concerned they will be back to discuss more fees. Steve McClure -Original Message- Sent: Wednesday, February 20, 2002 9:30 AM To: Multiple recipients of list ORACLE-L Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure 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: Oracle Licensing - Concurrent users
In our latest discussions with Oracle, it is my understanding that there is the Named user license and the CPU license. CPU allows an unlimited number of users. Named has a limited number of users. Now, it has always been my personal experience that nobody really knows what a user is. Ask 10 different Oracle personnel what a "user" is, and you will get 10 different answers. For example, we support a 911 center. An Oracle-based application displays the caller's information on a screen to the call taker. If you look in our database, you will see one user - it is the connection made by the software that displays the caller's info. The app maintains one connection and displays the data on the appropriate screen. Oracle is trying to tell us the the 911 callers are the "users". Give me a break! At best, the call takers might be the users. Apparently there are (or were) Term licenses also. See http://www.computerworld.com/storyba/0,4125,NAV47_STO61415,00.html Rest assured - as soon as you figure it out, they will change it. Jay >>> [EMAIL PROTECTED] 02/20/02 12:30PM >>> Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: A question for people who also know Sybase
Ok, this really is an Oracle list, believe it or not. Why not?: a) do a google search b) join a sybase list c) hit the sybase tech support site d) file a support request with sybase. Jared "Bala, Prakash" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/20/02 09:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:A question for people who also know Sybase Hi, Oracle 8.1.7.2 and Sybase 12.0 client on Solaris 2.8 We are trying to access 7 remote Sybase databases (all on NT) using a Sybase client (Adaptive Server Enterprise 12.0) installed on Solaris. Have converted the IP addresses and the port numbers to Hexadecimal and have made the necessary changes to the 'interfaces' file on our Unix box. We are able to successfully connect to 5 databases and retrieve data using isql. But we get the following error for the remaining 2 sites when I issue the isql command: CT-LIBRARY error: ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed We are able to ping these 2 servers and also do the 'traceroute' successfully. Also, I am able to connect to these 2 locations using the Sybase client on my workstation. This verifies that the IP address, port#, user-id and password are correct. Just the connection through Unix fails and have to make this work so that our Oracle database can talk to Sybase using the Oracle Gateway. Oracle Gateway is able to retrieve data from the remaining 5 Sybase servers. TIA! Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash 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: Oracle Licensing - Concurrent users
Our Oracle rep fully understood that our DB is accessed via our intranet, a large third party network, and the internet. We were only required to purchase CPU based licensing. There was no additional "Web" licensing fee. After reading this, I am concerned they will be back to discuss more fees. Steve McClure -Original Message- Sent: Wednesday, February 20, 2002 9:30 AM To: Multiple recipients of list ORACLE-L Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure 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).
how to kill Distributed transaction
Hi, We have 1 transaction hanging even if we restart the database. there is 1 entry in table dba_2pc_pending and 2 entries in dba_2pc_neighbours... How to release this transaction Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: Oracle Licensing - Concurrent users
Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, February 20, 2002 4:38 AM > To: Multiple recipients of list ORACLE-L > > > Web Licensing means that you use the DB for applications that are accessed > through the internet, > NOT INTRANET. > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > > -Original Message- > > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > > Sent: Wed, February 20, 2002 12:08 AM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: Oracle Licensing - Concurrent users > > > > Rachel - By Web license, do you mean the unlimited-user CPU-based > > licensing? > > Thanks. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Tuesday, February 19, 2002 3:05 PM > > To: Multiple recipients of list ORACLE-L > > > > > > you need to be careful if you are also using databases whose contents > > appear on the web, as Oracle will want you to use a web license > > (extremely expensive) even if the data is not directly accessed but > > appears on the web in static pages generated from the Oracle database. > > > > > > --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > > > "Smith, Ron L." wrote: > > > > > > > > We have been asked to gather statistics on the number of clients > > > using > > > > Oracle. This is being done to determine if we have sufficient > > > licensing. > > > > We have about 100 instances to monitor. > > > > > > > > Has anyone done this? Any ideas on what "Concurrent users" might > > > mean to > > > > the majority of people? > > > > > > > > We have both Oracle 7 and Oracle 8. > > > > > > > > Ron Smith > > > > DBA > > > > Kerr-McGee Corp > > > > > > > > > > Well, I have just been working on this for one of my customers last > > > week. The obvious thing is to query V$SESSION at regular intervals > > > (dbms_job can help) and what you can do is store the result through a > > > database link to a single instance. Where it was tricky was that we > > > wanted to identify 'system' processes (easy, except that job > > > processes > > > are marked as 'USER', which is debatable), and (that's where the snag > > > is) processes which are the results of a connection through a > > > database > > > link. The logic is that a database link is initiated by a 'normal' > > > connection - for which the full-blown licence is already paid. So > > > they > > > should not exactly count as much as regular connection; and if this > > > is > > > not a good argument, then it is probably possible to reduce their > > > number > > > by shifting around applications. Ultimately we could apply Larry's > > > favorite concept of 'single instance' (anyway I have always found DB > > > links messy). > > > My trouble was that nothing, but human knowledge, can tell whether > > > the > > > connection comes from a database link or is genuine (if somebody has > > > a > > > way, please share !). All the user information (machine, program, > > > module, action ...) comes from the initial connection and is > > > propagated. > > > I have solved this (not fully satisfactorily) by having a table > > > automatically inserted with unknown (machine, program) pairs and > > > manually updated to say 'If we see this program on this database, > > > then > > > it comes from a database link' - or 'anything coming from this > > > machine > > > must come from a database link'. Added something for connection from > > > HTTP servers, although I doubt that those will be spon
RE: (no subject)
One more thing about the script I sent -- that was for 8i, not 9i, so check it out in that respect, as well. Cheers, JoJo
A question for people who also know Sybase
Hi, Oracle 8.1.7.2 and Sybase 12.0 client on Solaris 2.8 We are trying to access 7 remote Sybase databases (all on NT) using a Sybase client (Adaptive Server Enterprise 12.0) installed on Solaris. Have converted the IP addresses and the port numbers to Hexadecimal and have made the necessary changes to the 'interfaces' file on our Unix box. We are able to successfully connect to 5 databases and retrieve data using isql. But we get the following error for the remaining 2 sites when I issue the isql command: CT-LIBRARY error: ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed We are able to ping these 2 servers and also do the 'traceroute' successfully. Also, I am able to connect to these 2 locations using the Sybase client on my workstation. This verifies that the IP address, port#, user-id and password are correct. Just the connection through Unix fails and have to make this work so that our Oracle database can talk to Sybase using the Oracle Gateway. Oracle Gateway is able to retrieve data from the remaining 5 Sybase servers. TIA! Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash 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: (no subject)
I'm also a brand new student of Oracle. The EXACT same thing happened to me in class a couple of weeks ago when I created a 2nd database. The reason it happened was that I didn't create the DB all in one day...and when I went in on the 2nd day to finish it, I did not startup the 2nd database before continuing to run the scripts, etc. So, the default database started and then some of the commands/scripts actually modified the default database's control files, etc. It was a real mess. We couldn't mount to delete certain files, yet we couldn't delete certain files in nomount, etc. The teacher had me run the attached script, and that fixed it. And I learned some more lessons, hahaha! I don't know if this is what happened to you, but since your situation is EXACTLY like mine, error messages, etc., I would suspect this. So check out the attached script and maybe it'll help. You'll have to modify the .sql file to replace with your database names. In the existing file, "will" is the default database and "test" is the database I was creating. Check through and fix up filenames, paths, etc. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, February 20, 2002 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: (no subject)I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I first created it, I tried to mount it after shutting down the installation seed database (database name = orcl, instance name = orcl). I kept getting the message 'cannot mount database in exclusive mode'. After several attempts to get out of exclusive mode, I gave up. The next night, without making any changes, I tried again and this time I was sucessful in mounting the bill database. I created a data tablespace (data) and four tables which I populated. Then I queried the database name from v$database and got the response 'bill'. Next I queried the instance name from v$instance and got 'orcl' when I should have gotten 'bill'. I double checked the database name and again got 'bill'.&nbs! ! p; How can this be? But the real problem is that when I tried to mount the database bill again tonight, I again got the message ''cannot mount database in exclusive mode'. I can't find an explanation for this in the book. I tried to startup nomount using the 'bill' pfile which showed an idel instance started. Then I tried to issue the alter database mount parallel command but it comes back with the 'cannot mount database in exclusive mode'. When I then query the instance_name from v$instance I get orcl instead of bill. Can any one help me out?Thanks!Bill Johnson CONTROL.SQL Description: Binary data
Re: Rollback Segments
Thanks. Yes I am on the list and on the oak table (http://www.oaktable.net ;-)) Anjo. "Gogala, Mladen" wrote: > Wow! I've been recommending your paper about Oracle7 wait events > everywhere! I didn't know that you are on this list, too. > > -Original Message- > Sent: Tuesday, February 19, 2002 2:43 AM > To: Multiple recipients of list ORACLE-L > > How about iag/iap ? And rpt ? Oh and SQL*Menu ? > And there were about 14 enqueue/locks in Oracle Version 5 as far as I can > remember. > > Anjo Kolk > > Brings back memories of joining Oracle Europe in 1985 ;-) > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, February 19, 2002 6:43 AM > > > > > I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. > > > > Hemant K Chitale > > Principal DBA > > Chartered Semiconductor Manufacturing Ltd > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM > > Sent by: [EMAIL PROTECTED] > > > > Please respond to ORACLE-L > > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) > > Subject: RE: Rollback Segments > > > > > > > > > > > > > > > > > > UFI no, but the rest... that's where I started in Oracle -- version 5 > > > > > > --- "Conboy, Jim" <[EMAIL PROTECTED]> wrote: > > > Holy cow Mladen, what a memory! > > > > > > Does anybody else remember (or admit to) using UFI? > > > > > > Jim > > > > > > ** > > > > > > ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Conboy, Jim > > > 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). > > > > > > __ > > Do You Yahoo!? > > Yahoo! Sports - Coverage of the 2002 Olympic Games > > http://sports.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > 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: Anjo Kolk > 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: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ---
re: student dba'r running 9i on windows xp
What's your ORACLE_SID set to? Did you add your new database to your listener? You didn't say how you created the second database. DBAtracker @aol.com To: Multiple recipients of list ORACLE-L Sent by: root<[EMAIL PROTECTED]> cc: Subject: (no subject) 02/20/2002 10:53 AM Please respond to ORACLE-L I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I first created it, I tried to mount it after shutting down the installation seed database (database name = orcl, instance name = orcl). I kept getting the message 'cannot mount database in exclusive mode'. After several attempts to get out of exclusive mode, I gave up. The next night, without making any changes, I tried again and this time I was sucessful in mounting the bill database. I created a data tablespace (data) and four tables which I populated. Then I queried the database name from v$database and got the response 'bill'. Next I queried the instance name from v$instance and got 'orcl' when I should have gotten 'bill'. I double checked the database name and again got 'bill'.&nbs! ! p; How can this be? But the real problem is that when I tried to mount the database bill again tonight, I again got the message ''cannot mount database in exclusive mode'. I can't find an explanation for this in the book. I tried to startup nomount using the 'bill' pfile which showed an idel instance started. Then I tried to issue the alter database mount parallel command but it comes back with the 'cannot mount database in exclusive mode'. When I then query the instance_name from v$instance I get orcl instead of bill. Can any one help me out? Thanks! Bill Johnson -- 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).
Off topic - once in a life time
Hello All An interesting date / time combination I got from SAG-L. SAG-Lers, Pardon this off-topic posting, but I know some of you might find this interesting. Depending on how you display date and time, there will be a time today at which the date and time will show the same digits repeated in perfect symmetry, which has not happened for a long, long time and will not occur again for 110 years, and then never again. At 8:02PM, the date and time will be 20.02.2002 20:02 (or 2002 2002 2002)! This will not happen again until 21.12.2112 21:12 (or Dec. 21, 2112 at 9:12PM). And then it will never happen again, ever. Enjoy! Brian Johnson Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: RE: Lost a redo disk
Dick, Thanks for the reply. I saw that Beth figured it out on her own. When you said : "In her case the first task was to point to a disk drive that's available in the first place. Rebuilding the control file has the same effect, it's just that you can 'rename' the missing log all in one step." How did you anticipate getting a redo log file to point to? I've rebuild control files, renaming files into new directories. But you need to re-create the redo log file someplace - or are you suggesting that you recreate the control file minus the missing redo log file? Following that with adding a new set of redo members makes sense to me. Of course, there is a chance of lost data. But lets face it, that train left the station when the file was lost originally. Thanks again for the reply. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 20, 2002 11:03 AM To: Mercadante; Thomas F; '[EMAIL PROTECTED]' Tom, It would appear that Beth hit the right solution in the end. In the past when I've lost a redo log it was the active one which makes for a much bigger mess. What I believe Beth was running into is that when the database opens it tries to connect with each file that makes up the database. If it can't then the open stops right there & complains. In her case the first task was to point to a disk drive that's available in the first place. Rebuilding the control file has the same effect, it's just that you can 'rename' the missing log all in one step. And true issuing a reset logs command does clear out all of the online redo. Dick Goulet Reply Separator Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> Date: 2/20/2002 10:58 AM Dick, Couldn't she just "Alter database open reset logs" - wouldn't this create a new set of redo logs? Beth - you didn't say whether you lost all of your redo logs - please do NOT do the above right away. I've never faced this, and am guessing a bit. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 20, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Beth, This is one of those conditions where not backing up everything gets one in trouble, on occasion. What I believe you'll have to do, which would be true in any case, is rebuild the control file. Now I'm not absolutely certain, but I do believe you can issue a "alter database backup controlfile to trace" command on a mounted database. That will at least give you the script you'll need. Dick Goulet Reply Separator Author: "Seefelt; Beth" <[EMAIL PROTECTED]> Date: 2/20/2002 5:28 AM Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Servic
Confusion about oradim.log file
Hi All, In 8.0.5 when I used the oradim utility to create a service I would always review the oradim.log file to see if all is well. I just created my first oracle 8i service using oradim. When I reviewed the oradim.log file I got an error message saying it cannot open the control files. Well of course not. Why in 8i does oradim.log contain this error? I can create the database fine with no problems. The docs always say to review oradim.log for errors before continuing. So why are they now putting in errors that are not really errors. Thanks Rick -- 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:RE: RE: Lost a redo disk
Tom, If you rebuilt the control file, giving the redo log a new drive to reside thereon, and then issued the "alter database open reset logs" (which btw is a part of the script created by the "alter database backup controlfile to trace" command) the missing log would in fact then exist albeit empty. And yes you could loose transactions and data if that log was the active log file at the time it died. Hopefully that was not the case, but then as you observe the train is gone. Isn't that the reason we invest in RAID & mirroring?? I think this should also server as a wake-up call at Beth's place of employment to look into some hardware/software for redundancy. Although who expects that halon system to be really needed? Dick Goulet Reply Separator Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> Date: 2/20/2002 11:40 AM Dick, Thanks for the reply. I saw that Beth figured it out on her own. When you said : "In her case the first task was to point to a disk drive that's available in the first place. Rebuilding the control file has the same effect, it's just that you can 'rename' the missing log all in one step." How did you anticipate getting a redo log file to point to? I've rebuild control files, renaming files into new directories. But you need to re-create the redo log file someplace - or are you suggesting that you recreate the control file minus the missing redo log file? Following that with adding a new set of redo members makes sense to me. Of course, there is a chance of lost data. But lets face it, that train left the station when the file was lost originally. Thanks again for the reply. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 20, 2002 11:03 AM To: Mercadante; Thomas F; '[EMAIL PROTECTED]' Tom, It would appear that Beth hit the right solution in the end. In the past when I've lost a redo log it was the active one which makes for a much bigger mess. What I believe Beth was running into is that when the database opens it tries to connect with each file that makes up the database. If it can't then the open stops right there & complains. In her case the first task was to point to a disk drive that's available in the first place. Rebuilding the control file has the same effect, it's just that you can 'rename' the missing log all in one step. And true issuing a reset logs command does clear out all of the online redo. Dick Goulet Reply Separator Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> Date: 2/20/2002 10:58 AM Dick, Couldn't she just "Alter database open reset logs" - wouldn't this create a new set of redo logs? Beth - you didn't say whether you lost all of your redo logs - please do NOT do the above right away. I've never faced this, and am guessing a bit. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 20, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Beth, This is one of those conditions where not backing up everything gets one in trouble, on occasion. What I believe you'll have to do, which would be true in any case, is rebuild the control file. Now I'm not absolutely certain, but I do believe you can issue a "alter database backup controlfile to trace" command on a mounted database. That will at least give you the script you'll need. Dick Goulet Reply Separator Author: "Seefelt; Beth" <[EMAIL PROTECTED]> Date: 2/20/2002 5:28 AM Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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 yo
RE: Oracle Licensing - Concurrent users
Hello Dennis We operate here on a site license that cover our internal users and servers. About a month ago we talked with oracle about a database that will be connected to our internet site. They come back and said that we need a separate license for this and our regular site license cover only INTERNAL use. You need a separate license if you use the DB VIA internet. I do not know if it is named or CPU or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Can anyone provide more details on "Web licensing"? I asked our manager > that > negotiates the Oracle licensing and he was only aware of Named and CPU > (formerly UPU) licensing for unlimited users. I checked at Oraclestore, > and > it only shows Named and Processor licensing. If we are missing something, > I > would like to avoid a nasty licensing surprise. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, February 20, 2002 4:38 AM > To: Multiple recipients of list ORACLE-L > > > Web Licensing means that you use the DB for applications that are accessed > through the internet, > NOT INTRANET. > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > > -Original Message- > > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > > Sent: Wed, February 20, 2002 12:08 AM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: Oracle Licensing - Concurrent users > > > > Rachel - By Web license, do you mean the unlimited-user CPU-based > > licensing? > > Thanks. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Tuesday, February 19, 2002 3:05 PM > > To: Multiple recipients of list ORACLE-L > > > > > > you need to be careful if you are also using databases whose contents > > appear on the web, as Oracle will want you to use a web license > > (extremely expensive) even if the data is not directly accessed but > > appears on the web in static pages generated from the Oracle database. > > > > > > --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > > > "Smith, Ron L." wrote: > > > > > > > > We have been asked to gather statistics on the number of clients > > > using > > > > Oracle. This is being done to determine if we have sufficient > > > licensing. > > > > We have about 100 instances to monitor. > > > > > > > > Has anyone done this? Any ideas on what "Concurrent users" might > > > mean to > > > > the majority of people? > > > > > > > > We have both Oracle 7 and Oracle 8. > > > > > > > > Ron Smith > > > > DBA > > > > Kerr-McGee Corp > > > > > > > > > > Well, I have just been working on this for one of my customers last > > > week. The obvious thing is to query V$SESSION at regular intervals > > > (dbms_job can help) and what you can do is store the result through a > > > database link to a single instance. Where it was tricky was that we > > > wanted to identify 'system' processes (easy, except that job > > > processes > > > are marked as 'USER', which is debatable), and (that's where the snag > > > is) processes which are the results of a connection through a > > > database > > > link. The logic is that a database link is initiated by a 'normal' > > > connection - for which the full-blown licence is already paid. So > > > they > > > should not exactly count as much as regular connection; and if this > > > is > > > not a good argument, then it is probably possible to reduce their > > > number > > > by shifting around applications. Ultimately we could apply Larry's > > > favorite concept of 'single instance' (anyway I have always found DB > > > links messy). > > > My trouble was that nothing, but human knowledge, can tell whether > > > the > > > connection comes from a database link or is genuine (if somebody has > > > a > > > way, please share !). All the user information (machine, program, > > > module, action ...) comes from the initial connection and is > > > propagated. > > > I have solved this (not fully satisfactorily) by having a table > > > automatically inserted with unknown (machine, program) pairs and > > > manually updated to say 'If we see this program on this database, > > > then > > > it comes from a database link' - or 'anything coming from this > > > machine > > > must come from a database link'. Added something for connection from > > > HTTP servers, although I doubt that those will be spontaneously > > > discussed during the negotiation. > > > > > > -- > > > Regards, > > > > > > Stephane Faroult > > > Oriole Ltd > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Stephane Faroult > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 F
Re: Lost a redo disk
Beth Just for the record I hope that you understand that you have to do a full export and recreate the database and a full import into the newly created database to have a supported database. The parameter _allow_resetlogs_corruption grants you right's to open the database even it it needed recover from the missing redo log file. The other thing to have in mind it that there is a possibility that you have lost committed transaction there was residing in the lost redo log :-( /regards Seefelt, Beth wrote: >Never mind. I was able to open the database. > >I renamed the redo file to a disk that is working, and then set the >_allow_resetlogs_corruption parameter to true. Then I was able to do an open >resetlogs. > >But thanks anyway to anyone who's going to respond when my question hits the list. > >Beth > >>-Original Message- >>From: Seefelt, Beth >>Sent: Wednesday, February 20, 2002 8:28 AM >>To: '[EMAIL PROTECTED]' >>Subject: Lost a redo disk >> >> >>Hi everybody, >> >>This all started with the halon firing in our data center last night around 10pm so >you can imagine my condition. >> >>I lost a disk that contained only redo logs. >> >>When I try to open the database I get >> >>ORA-00313: open failed for members of log group 1 of thread 1 >>ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' >>ORA-27041: unable to open file >>OSD-04002: unable to open file >> >>I thought what I needed to do was switch the log files, drop the members that are on >the bad disk, and then I'd be able to open the database. >> >>So I mounted the database and did >> >> alter system switch logfile; >> >>and its telling me ORA-01109: database not open >> >>I thought I could swicth logfile with the database mounted? >> >>Could someone suggest the right steps I should take to recover? >> >>Many TIA, >> >>Beth >> -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev 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: Lost a redo disk
Do u have a consistent backup of the database ?? If so, restore the same and issue the command : recover database until cancel; When all the archived logs have been applied, issue the command : alter database open resetlogs; This should create the online redologs. Hope this helps, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 February 2002 13:28 To: Multiple recipients of list ORACLE-L Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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).
(no subject)
I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I first created it, I tried to mount it after shutting down the installation seed database (database name = orcl, instance name = orcl). I kept getting the message 'cannot mount database in exclusive mode'. After several attempts to get out of exclusive mode, I gave up. The next night, without making any changes, I tried again and this time I was sucessful in mounting the bill database. I created a data tablespace (data) and four tables which I populated. Then I queried the database name from v$database and got the response 'bill'. Next I queried the instance name from v$instance and got 'orcl' when I should have gotten 'bill'. I double checked the database name and again got 'bill'.&nbs! ! p; How can this be? But the real problem is that when I tried to mount the database bill again tonight, I again got the message ''cannot mount database in exclusive mode'. I can't find an explanation for this in the book. I tried to startup nomount using the 'bill' pfile which showed an idel instance started. Then I tried to issue the alter database mount parallel command but it comes back with the 'cannot mount database in exclusive mode'. When I then query the instance_name from v$instance I get orcl instead of bill. Can any one help me out? Thanks! Bill Johnson
RE: Lost a redo disk
Dick, Couldn't she just "Alter database open reset logs" - wouldn't this create a new set of redo logs? Beth - you didn't say whether you lost all of your redo logs - please do NOT do the above right away. I've never faced this, and am guessing a bit. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 20, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Beth, This is one of those conditions where not backing up everything gets one in trouble, on occasion. What I believe you'll have to do, which would be true in any case, is rebuild the control file. Now I'm not absolutely certain, but I do believe you can issue a "alter database backup controlfile to trace" command on a mounted database. That will at least give you the script you'll need. Dick Goulet Reply Separator Author: "Seefelt; Beth" <[EMAIL PROTECTED]> Date: 2/20/2002 5:28 AM Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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: 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:RE: Lost a redo disk
Tom, It would appear that Beth hit the right solution in the end. In the past when I've lost a redo log it was the active one which makes for a much bigger mess. What I believe Beth was running into is that when the database opens it tries to connect with each file that makes up the database. If it can't then the open stops right there & complains. In her case the first task was to point to a disk drive that's available in the first place. Rebuilding the control file has the same effect, it's just that you can 'rename' the missing log all in one step. And true issuing a reset logs command does clear out all of the online redo. Dick Goulet Reply Separator Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> Date: 2/20/2002 10:58 AM Dick, Couldn't she just "Alter database open reset logs" - wouldn't this create a new set of redo logs? Beth - you didn't say whether you lost all of your redo logs - please do NOT do the above right away. I've never faced this, and am guessing a bit. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 20, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Beth, This is one of those conditions where not backing up everything gets one in trouble, on occasion. What I believe you'll have to do, which would be true in any case, is rebuild the control file. Now I'm not absolutely certain, but I do believe you can issue a "alter database backup controlfile to trace" command on a mounted database. That will at least give you the script you'll need. Dick Goulet Reply Separator Author: "Seefelt; Beth" <[EMAIL PROTECTED]> Date: 2/20/2002 5:28 AM Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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: 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: Lost a redo disk
alter database clear logfile group 1; alter database open; may help you... - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 3:28 PM Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segments
Wow! I've been recommending your paper about Oracle7 wait events everywhere! I didn't know that you are on this list, too. -Original Message- Sent: Tuesday, February 19, 2002 2:43 AM To: Multiple recipients of list ORACLE-L How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 19, 2002 6:43 AM > > I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. > > Hemant K Chitale > Principal DBA > Chartered Semiconductor Manufacturing Ltd > > > Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM > Sent by: [EMAIL PROTECTED] > > Please respond to ORACLE-L > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) > Subject: RE: Rollback Segments > > > > > > > > > UFI no, but the rest... that's where I started in Oracle -- version 5 > > > --- "Conboy, Jim" <[EMAIL PROTECTED]> wrote: > > Holy cow Mladen, what a memory! > > > > Does anybody else remember (or admit to) using UFI? > > > > Jim > > > > ** > > > > ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Conboy, Jim > > 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). > > > __ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: Anjo Kolk 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: Gogala, Mladen 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: Lost a redo disk
Never mind. I was able to open the database. I renamed the redo file to a disk that is working, and then set the _allow_resetlogs_corruption parameter to true. Then I was able to do an open resetlogs. But thanks anyway to anyone who's going to respond when my question hits the list. Beth > -Original Message- > From: Seefelt, Beth > Sent: Wednesday, February 20, 2002 8:28 AM > To: '[EMAIL PROTECTED]' > Subject: Lost a redo disk > > > Hi everybody, > > This all started with the halon firing in our data center last night around 10pm so >you can imagine my condition. > > I lost a disk that contained only redo logs. > > When I try to open the database I get > > ORA-00313: open failed for members of log group 1 of thread 1 > ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' > ORA-27041: unable to open file > OSD-04002: unable to open file > > I thought what I needed to do was switch the log files, drop the members that are on >the bad disk, and then I'd be able to open the database. > > So I mounted the database and did > > alter system switch logfile; > > and its telling me ORA-01109: database not open > > I thought I could swicth logfile with the database mounted? > > Could someone suggest the right steps I should take to recover? > > Many TIA, > > Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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).
CRITICAL: MIGRATION WORKBENCH NOT SUITABLE DRIVER FOUND.
Dear Friends, I am trying to Convert Informix 7.3 database to Oracle 8 using Work bench migration tool. I tried connecting using the disconnected model method and the conversion goes on fine..but this method does NOT convert the data. Therefore I need to connect, using the migration tool, which uses Informix JDBC driver to connect to Informix database. This way I can also convert the data from the tables. But when I enter the Informix database information and I hit the next button I get the following message "NO SUITABLE DRIVER". I have checked that JDBC connection is working fine using a JDBC small connection application. I have also made sure that ifmxjdbc.jar is specified in the CLASSPATH and also a copied it to the ORACLE_HOME/omwb/driver directory. If any one has done this before please let me what is that I am missing to make the connection using Migration tool. Neil KhotTELEFORMIX Informix Database Analysts Work 847-585-6827 Fax 847-605-1231
RE: Lost a redo disk
Nope u cannot switch when it is in mount mode have u lost all your redlogs -Original Message- Sent: Wednesday, February 20, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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: Arun Chakrapani 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: Set unused column back to normal (solved)
You either post the solution or do nothing. Your following message is meaningless just waster other people's time. Please show your courtesy before you post on a public list like this. -Original Message- Sent: Wednesday, February 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L Solved -Original Message- Sent: 20 February 2002 17:20 To: 'Multiple recipients of list ORACLE-L'; 'LazyDBA mailing list' Subject:Set unused column back to normal Hi all, Any command setting back the unused column back to used ? Negate this command please ALTER TABLE mytable SET UNUSED mycol; Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard 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). ** This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege." Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer." Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities." ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Wu 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: JDBC problem
First, need you clarify: 1: Do you use Java or JavaScript 2: How you program to access Database Roger Liu -Original Message- Sent: Wednesday, February 20, 2002 1:53 AM To: Multiple recipients of list ORACLE-L Hi, I am new to this group as well as to Oracle. I have installed Oracle 8.1.5 & Java 1.3.1_02 on Solaris system. My question is whatever JDBC drivers that are installed by default supports the java version 1.3.1_02 or i have to install JDBC drivers seperately.I am facing lot of problems in connecting to Database from java script.Please clarify my doubt. Thanks & Regards, Sankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: P.V.Sankar 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: Liu, Roger (R.) 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: Lost a redo disk
"Seefelt, Beth" wrote: > > Hi everybody, > > This all started with the halon firing in our data center last night around 10pm so >you can imagine my condition. > > I lost a disk that contained only redo logs. > > When I try to open the database I get > > ORA-00313: open failed for members of log group 1 of thread 1 > ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' > ORA-27041: unable to open file > OSD-04002: unable to open file > > I thought what I needed to do was switch the log files, drop the members that are on >the bad disk, and then I'd be able to open the database. > > So I mounted the database and did > > alter system switch logfile; > > and its telling me ORA-01109: database not open > > I thought I could swicth logfile with the database mounted? > > Could someone suggest the right steps I should take to recover? > > Many TIA, > > Beth Beth, The commands you usually play with when your database is not opened are variations on the ALTER DATABASE theme. It looks like what used to be the current log file has been damaged, and quite obviously this occurred before the checkpoint. If you have members on a good disk, what I'd try to do is to overwrite bad members with the corresponding good ones - they are supposed to be identical - then try to open the database. It may work. If it still fails, I were you I'd probably try this BUT BEWARE THAT IT MAY MEAN LOST TRANSACTIONS : 1) Drop and recreate damaged members while the database is mounted with ALTER DATABASE 2) Open the database with the RESETLOGS options. In effect, it will mean that all transactions since the latest checkpoint are lost. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Dynamic SQL
Title: Dynamic SQL Laura, Here is an example: create or replace package pkg_drill_thru as type CompanyPhone is ref cursor; Procedure get_mobile_numbers( activity_dt date, company_cd varchar2, channel_cd varchar2, subscriber_cd varchar2, initial_add number, volun_disc number, involun_disc number, volun_recon number, involun_recon number, no_install number, company_phone in out CompanyPhone); end;/ create or replace package body pkg_drill_thru as Procedure get_mobile_numbers( activity_dt date, company_cd varchar2, channel_cd varchar2, subscriber_cd varchar2, initial_add number, volun_disc number, involun_disc number, volun_recon number, involun_recon number, no_install number, company_phone in out CompanyPhone) as sql_str varchar2(2000); begin sql_str := 'select nvl(company_desc, a.company_code) company, a.channel_code, mobile_number from dly_transaction_detail a, company_dimension b where activity_date = :1 and subscriber_code = upper(:2) and a.company_code in (select company_code from company_dimension start with parent_company_code = :3 connect by parent_company_code = prior company_code union select :4 from dual) and a.channel_code in (select channel_code from channel_dimension start with parent_channel_code = :5 connect by parent_channel_code = prior channel_code union select :6 from dual) and a.company_code = b.company_code'; if initial_add = 1 then sql_str := sql_str || ' and initial_add = 1'; elsif volun_disc = 1 then sql_str := sql_str || ' and volun_disc = 1'; elsif involun_disc = 1 then sql_str := sql_str || ' and involun_disc = 1'; elsif volun_recon = 1 then sql_str := sql_str || ' and volun_recon = 1'; elsif involun_recon = 1 then sql_str := sql_str || ' and involun_recon = 1'; elsif no_install = 1 then sql_str := sql_str || ' and no_install = 1'; end if; open company_phone for sql_str using activity_dt, subscriber_cd, company_cd, company_cd, channel_cd, channel_cd; end; end; Prakash -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 19, 2002 4:57 PMTo: Multiple recipients of list ORACLE-LSubject: Dynamic SQL We have Oracle version 8.0.5 and need to use dynamic sql. Through research I know that there is a dbms_sql package that is suppose to support this, but we cannot find an example of what we are needing to do. We have been told that we can do it easily in '8i' but we are not able to upgrade yet. We are trying to populate a reference cursor via a procedure with a select statement. Has anyone done this and if so can you furnish an example? I may need to tell more about what we are doing and if so please tell me. Thank you, Laura
Re: SET TRANSACTION for a Distributed Transaction
Bill, You could do your inserts calling a stored procedure which you create on your target db and specify the rollback segment inside stored procedure. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 19, 2002 4:19 PM > Can I use SET TRANSACTION USE ROLLBACK SEGMENT for a distributed > transaction, where I"m doing a whole bunch of INSERTS on a target db that > SELECT data from a source db? > > I was thinking of constructing this to run when logged into the source db - > I'd insert data to a target db across a database link. I assume the RBS > would have to be on the target db? Or could the RBS be on the source db, > even though the inserts are taking place on the target? > > Alternatively I could write the script whereby the inserts happen on the > local db and the selects happen across the db link - in that case the SET > TRANSACTION would use a local RBS . . . > > any ideas/comments on writing putting something like this together? > > Thanks > > -bill magaliff > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Magaliff, Bill > 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: Igor Neyman 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: Dynamic SQL
Title: Dynamic SQL Laura, Here's one. In this case, if the in variable 'p_actualenddate' is passed into the procedure, and additional 'and' clause is added to the where clause. Any questions, give me a shout. PROCEDURE ListScheduleforDelete ( p_employid IN VARCHAR2, p_status IN WTW_EMPL_WEEKENDING_SCHEDULE.SCHED_STATUS_CODE%TYPE, p_actualenddate IN WTW_EMPLOYMENT.EMPLOYMENT_START_DATE%TYPE, p_refCursor IN OUT empRS ) IS sel_string VARCHAR2(2000) := ' SELECT WTW_EMPL_WEEKENDING_SCHEDULE.EMPLOYMENT_ID, ' || ' WTW_EMPL_WEEKENDING_SCHEDULE.EMPLOYMENT_WEEKEND_DATE, ' || ' WTW_EMPL_WEEKENDING_SCHEDULE.TOTAL_ACTUAL_HRS_NBR, ' || ' WTW_EMPL_SCHED_STATUS_CODE.SCHED_LONG_TXT, ' || ' WTW_EMPL_WEEKENDING_SCHEDULE.TOTAL_SCHED_HRS_NBR ' || ' FROM WTW_EMPL_WEEKENDING_SCHEDULE, WTW_EMPL_SCHED_STATUS_CODE ' || ' WHERE WTW_EMPL_WEEKENDING_SCHEDULE.EMPLOYMENT_ID = :p_employid AND ' || ' WTW_EMPL_WEEKENDING_SCHEDULE.SCHED_STATUS_CODE = :p_status AND ' || ' WTW_EMPL_SCHED_STATUS_CODE.SCHED_STATUS_CODE(+) = WTW_EMPL_WEEKENDING_SCHEDULE.SCHED_STATUS_CODE '; where_string VARCHAR2(400); where_str VARCHAR2(7) := ' AND '; ActualDatePlusSeven DATE; BEGIN IF p_actualenddate IS NOT NULL THEN ActualDatePlusSeven := p_actualenddate + 7; where_string := where_str || ' WTW_EMPL_WEEKENDING_SCHEDULE.EMPLOYMENT_WEEKEND_DATE >= ' || || ActualDatePlusSeven || || ' '; END IF; OPEN p_refCursor FOR sel_string || where_string || ' ORDER BY 2 DESC' USING p_employid, p_status; END ListScheduleforDelete; -- %%% Tom Mercadante Oracle Certified Professional -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 19, 2002 4:57 PMTo: Multiple recipients of list ORACLE-LSubject: Dynamic SQL We have Oracle version 8.0.5 and need to use dynamic sql. Through research I know that there is a dbms_sql package that is suppose to support this, but we cannot find an example of what we are needing to do. We have been told that we can do it easily in '8i' but we are not able to upgrade yet. We are trying to populate a reference cursor via a procedure with a select statement. Has anyone done this and if so can you furnish an example? I may need to tell more about what we are doing and if so please tell me. Thank you, Laura
RE: Oracle Licensing - Concurrent users
Can anyone provide more details on "Web licensing"? I asked our manager that negotiates the Oracle licensing and he was only aware of Named and CPU (formerly UPU) licensing for unlimited users. I checked at Oraclestore, and it only shows Named and Processor licensing. If we are missing something, I would like to avoid a nasty licensing surprise. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 20, 2002 4:38 AM To: Multiple recipients of list ORACLE-L Web Licensing means that you use the DB for applications that are accessed through the internet, NOT INTRANET. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 12:08 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Rachel - By Web license, do you mean the unlimited-user CPU-based > licensing? > Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, February 19, 2002 3:05 PM > To: Multiple recipients of list ORACLE-L > > > you need to be careful if you are also using databases whose contents > appear on the web, as Oracle will want you to use a web license > (extremely expensive) even if the data is not directly accessed but > appears on the web in static pages generated from the Oracle database. > > > --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > > "Smith, Ron L." wrote: > > > > > > We have been asked to gather statistics on the number of clients > > using > > > Oracle. This is being done to determine if we have sufficient > > licensing. > > > We have about 100 instances to monitor. > > > > > > Has anyone done this? Any ideas on what "Concurrent users" might > > mean to > > > the majority of people? > > > > > > We have both Oracle 7 and Oracle 8. > > > > > > Ron Smith > > > DBA > > > Kerr-McGee Corp > > > > > > > Well, I have just been working on this for one of my customers last > > week. The obvious thing is to query V$SESSION at regular intervals > > (dbms_job can help) and what you can do is store the result through a > > database link to a single instance. Where it was tricky was that we > > wanted to identify 'system' processes (easy, except that job > > processes > > are marked as 'USER', which is debatable), and (that's where the snag > > is) processes which are the results of a connection through a > > database > > link. The logic is that a database link is initiated by a 'normal' > > connection - for which the full-blown licence is already paid. So > > they > > should not exactly count as much as regular connection; and if this > > is > > not a good argument, then it is probably possible to reduce their > > number > > by shifting around applications. Ultimately we could apply Larry's > > favorite concept of 'single instance' (anyway I have always found DB > > links messy). > > My trouble was that nothing, but human knowledge, can tell whether > > the > > connection comes from a database link or is genuine (if somebody has > > a > > way, please share !). All the user information (machine, program, > > module, action ...) comes from the initial connection and is > > propagated. > > I have solved this (not fully satisfactorily) by having a table > > automatically inserted with unknown (machine, program) pairs and > > manually updated to say 'If we see this program on this database, > > then > > it comes from a database link' - or 'anything coming from this > > machine > > must come from a database link'. Added something for connection from > > HTTP servers, although I doubt that those will be spontaneously > > discussed during the negotiation. > > > > -- > > Regards, > > > > Stephane Faroult > > Oriole Ltd > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Stephane Faroult > > 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). > > > __ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists
Re:Lost a redo disk
Beth, This is one of those conditions where not backing up everything gets one in trouble, on occasion. What I believe you'll have to do, which would be true in any case, is rebuild the control file. Now I'm not absolutely certain, but I do believe you can issue a "alter database backup controlfile to trace" command on a mounted database. That will at least give you the script you'll need. Dick Goulet Reply Separator Author: "Seefelt; Beth" <[EMAIL PROTECTED]> Date: 2/20/2002 5:28 AM Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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: Oracle Developer/DBA Needed in Macon, Georgia-Local Candi
ya just have to understand where Noble is located... Most of the family trees dont have branches :-) greg -Original Message- Sent: Tuesday, February 19, 2002 3:20 PM To: Multiple recipients of list ORACLE-L HUMM, After the fiasco in Noble who in their right mind would want to go to Georgia. :-) Reply Separator Author: OraStaff <[EMAIL PROTECTED]> Date: 2/19/2002 7:38 AM Stable manufacturing firm in Macon, Georgia is looking for an Oracle developer who has some DBA functions as well. Oracle development is the key. If the candidate has strong development skills and is interested in doing some DBA functions and some knowledge of the functions, resumes would be welcomed. This is a full-time staff position. *Only candidates who live in the Macon and 285 loop area will be considered. No relocation is provided. Only sent a resume if you are in this area. ** No Sponsorship is available. DO NOT send your resume if you have H-1B status. *Candidates Need to have solid Oracle Forms, Reports, PL/SQL experience.. some DBA experience is highly preferred. Base salary is in the 70-80 K range. *U.S. citizenship or green card holders only PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Email: [EMAIL PROTECTED] Please use job code: One/Macon/Dev/DBA/Larson All inquiries held in confidence. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Loughmiller, Greg 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).
Lost a redo disk
Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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: JDBC problem
What kind of problems are you encountering? -Original Message- Sent: Wednesday, February 20, 2002 1:53 AM To: Multiple recipients of list ORACLE-L Hi, I am new to this group as well as to Oracle. I have installed Oracle 8.1.5 & Java 1.3.1_02 on Solaris system. My question is whatever JDBC drivers that are installed by default supports the java version 1.3.1_02 or i have to install JDBC drivers seperately.I am facing lot of problems in connecting to Database from java script.Please clarify my doubt. Thanks & Regards, Sankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: P.V.Sankar 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: Ji, Richard 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: Set unused column back to normal (solved)
How? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Sinard Xing [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 12:04 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Set unused column back to normal (solved) > > Solved > > -Original Message- > Sent: 20 February 2002 17:20 > To: 'Multiple recipients of list ORACLE-L'; 'LazyDBA mailing list' > Subject: Set unused column back to normal > > Hi all, > > > Any command setting back the unused column back to used ? > > Negate this command please > > ALTER TABLE mytable SET UNUSED mycol; > > > Sinardy > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Disable certain users from login to database while applying Human
Probably this might help u to arrive at a solution rather than giving the actual solution In certain situations, you may want to log in to another schema to operate on that user's objects like granting privileges, but you don't know the password for that schema and you can't wait until that user is available to assist you. Consider this situation. A typical database has the following users: SYSTEM SYS MATERIALS ACCOUNTS Assume you don't know the password for both MATERIALS and ACCOUNTS, but you want to grant privileges on MATERIALS's objects to the ACCOUNTS schema immediately. You can't achieve this objective by logging into SYS or SYSTEM schema. You should have to log in to that schema for granting privileges to others. That is, you should have to be the owner to grant privileges on the objects. At the same time, you should not disturb the existing password of the MATERIALS schema. You can perform both the objectives using the following steps: 1. Connect as SYSTEM or SYS schema and issue the following sql command: SQL> select 'alter user '||username||' identified by values '''||password|| from dba_users where username='MATERIALS'; This will return a statement like the one below alter user MATERIALS identified by values 'D0DCC7D6877E8507'; Preserve this statement, as it will help you reset the original (existing) password after finishing the work. 2. Set the new password for the MATERIALS schema by giving the following sql command: SQL> alter user materials identified by password; Here you can set any password temporarily to complete the objectives. 3. Log in to the MATERIALS schema, grant the privilege on certain objects to the ACCOUNTS schema and whatever jobs you want to complete in that schema. 4. Connect as the SYS or SYSTEM schema and execute the preserved statement. SQL> alter user MATERIALS identified by values 'D0DCC7D6877E8507'; This will reset the password to the previous one, and the user's work won't be affected. Cheers Fazal --- [EMAIL PROTECTED] wrote: > > As you are talking of Oracle Apps, NONE of the > suggested solutions : > 1. Database ON LOGON Trigger > 2. Lock Database Account > 3. Change Database Account Password > 4. Startup Database in Restricted mode > would work. > > The users connect to the Database in the APPS schema > -- this is the > "universal" > schema that Oracle Apps uses. The Patch requires > APPS so Restricted > doesn't > help (unless you grant Restricted to APPS in which > case all the users can > logon). > Ditto about locking, changing password or writing a > trigger on the APPS > schema. > > What you can do are : > 1. Shutdown the Apache server for the Self-Service > Modules > 2. Shutdown the Forms server for the Forms Module > 3. Shutdown the Concurrent Managers. > > All of the above would affect ALL users. > > Alternatively, login to the Application as the > System Administrator user > and > change the Application User Passwords for the users > whom you want disabled. > Change the passwords back to a default (WELCOME) > later. > > However, what you SHOULD do, per Oracle Support, is > 1. Shutdown 2. Shutdown > 3. Shutdown > as I have listed above. > If you are familiar with Oracle Applications > Patching and are comfortable > with reading > the Patch drivers, you can figure out what database > objects are being > modified/updated/created > and what Forms/Reports/HTML etc files are being > modified/created by the > patch. > Then you can take an intelligent decision > should you allow users to > logon when > applying the patch ? > > Hemant K Chitale > Principal DBA > Chartered Semiconductor Manufacturing Ltd > > > "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> >18/02/2002 03:28 PM > Sent by: [EMAIL PROTECTED] > > Please respond to ORACLE-L > > > > To: Multiple recipients of list > ORACLE-L <[EMAIL PROTECTED]> > > cc: (bcc: CHITALE Hemant > Krishnarao/IT/CHRT/ST Group) > > Subject: Disable certain users from > login to database while applying > > Human > > > > > > > > > > > > > > > > > Hi Gurus, > > I need to disable certain users from login to > database while I apply the > Human Resources Patches for our Oracle HR 11i > Applications. > Which is the best way to do it ? Should I write > on-logo
RE: Oracle Licensing - Concurrent users
Web Licensing means that you use the DB for applications that are accessed through the internet, NOT INTRANET. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 20, 2002 12:08 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Licensing - Concurrent users > > Rachel - By Web license, do you mean the unlimited-user CPU-based > licensing? > Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, February 19, 2002 3:05 PM > To: Multiple recipients of list ORACLE-L > > > you need to be careful if you are also using databases whose contents > appear on the web, as Oracle will want you to use a web license > (extremely expensive) even if the data is not directly accessed but > appears on the web in static pages generated from the Oracle database. > > > --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > > "Smith, Ron L." wrote: > > > > > > We have been asked to gather statistics on the number of clients > > using > > > Oracle. This is being done to determine if we have sufficient > > licensing. > > > We have about 100 instances to monitor. > > > > > > Has anyone done this? Any ideas on what "Concurrent users" might > > mean to > > > the majority of people? > > > > > > We have both Oracle 7 and Oracle 8. > > > > > > Ron Smith > > > DBA > > > Kerr-McGee Corp > > > > > > > Well, I have just been working on this for one of my customers last > > week. The obvious thing is to query V$SESSION at regular intervals > > (dbms_job can help) and what you can do is store the result through a > > database link to a single instance. Where it was tricky was that we > > wanted to identify 'system' processes (easy, except that job > > processes > > are marked as 'USER', which is debatable), and (that's where the snag > > is) processes which are the results of a connection through a > > database > > link. The logic is that a database link is initiated by a 'normal' > > connection - for which the full-blown licence is already paid. So > > they > > should not exactly count as much as regular connection; and if this > > is > > not a good argument, then it is probably possible to reduce their > > number > > by shifting around applications. Ultimately we could apply Larry's > > favorite concept of 'single instance' (anyway I have always found DB > > links messy). > > My trouble was that nothing, but human knowledge, can tell whether > > the > > connection comes from a database link or is genuine (if somebody has > > a > > way, please share !). All the user information (machine, program, > > module, action ...) comes from the initial connection and is > > propagated. > > I have solved this (not fully satisfactorily) by having a table > > automatically inserted with unknown (machine, program) pairs and > > manually updated to say 'If we see this program on this database, > > then > > it comes from a database link' - or 'anything coming from this > > machine > > must come from a database link'. Added something for connection from > > HTTP servers, although I doubt that those will be spontaneously > > discussed during the negotiation. > > > > -- > > Regards, > > > > Stephane Faroult > > Oriole Ltd > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Stephane Faroult > > 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). > > > __ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: DENNIS WILLIAMS > INE
Re: How to build an Oracle database from scratch
and just to add my 2c worth... if anyone's has sat around waiting for the jvm to be loaded, then they'll know that db creation takes a l-o-n-g time nowadays. A simple solution is to create a basic "empty" database (ie just system, undo and temp) and then close it, zip it up... Now you have a template rather for creating any number of new databases rather than watching that awful slider bar chugging away. the 9i installer does a similar thing with "database templates" hth connor --- [EMAIL PROTECTED] wrote: > This topic comes up occasionally, some of you may > find this article > useful. > > http://dbasupport.com/oracle/ora9i/solutions/createDB.shtml > > Jared > > > -- > 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: FW: rename foreign keys from system-assigned constraint names
Hello Jared
I tested it. Seems to work ok on 8.1.6 on NT.
You will need to define how to recognize system assign constraint names.
One bug found: The resulting constraint name can be longer then 32 letters
if you tables have long names.
Maybe you can use another method to determine the resulting constraint name.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, February 19, 2002 7:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: FW: rename foreign keys from system-assigned constraint
> names to
>
> Have you or anyone else on the list used this script?
>
> Successfully? More than once?
>
> Jared
>
>
>
>
>
> YTTRI Lisa <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 02/19/02 08:43 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:FW: rename foreign keys from system-assigned
> constraint names to
>
>
> Here is something that was posted before - I haven't tried it so I don't
> know how well it works (if it does).
>
> -Original Message-
> Sent: Wednesday, August 08, 2001 4:23 PM
> To: Multiple recipients of list ORACLE-L
> more
>
>
> I just found this script on another site and thought this group would
> benefit from it, as we are always looking for usefult scripts... apologies
> if the formatting is bad.
>
> Here is a script that renames foreign keys from system-assigned constraint
> names to more intelligible names. The names use the current table name and
> the referenced table name. This greatly improves readability, especially
> for
> error messages.
> DECLARE
>c_owner CONSTANT VARCHAR2 (30):= 'FLEETPRO';
>
>CURSOR cons_cur
>IS
> SELECT C.owner, C.constraint_name, C.table_name,
> TRANSLATE (C.table_name,'ABCDEFGHIJKLMNOPQRSTUVWXYZ_',
> 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')
> as RTrimTable
>
> , CR.owner as ROwner, CR.constraint_name as RCName,
>CR.table_name as RTable,
>TRANSLATE (CR.table_name,'ABCDEFGHIJKLMNOPQRSTUVWXYZ_',
> 'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as RtrimRTable
>
> FROM all_constraints C, all_constraints CR
> WHERE C.owner = 'FLEETPRO'
> AND C.owner = CR.owner
> AND C.constraint_type in ('R')
> AND UPPER(SUBSTR(C.constraint_name,1,3)) <> 'FK_'
> AND C.r_constraint_name = CR.constraint_name
> ORDER BY C.table_name,CR.table_name;
> -- AND rownum < 50;
>
>cons_rec cons_cur%ROWTYPE;
>
>CURSOR col_curs
>IS
> SELECT column_name, position
> FROM all_cons_columns cc
>WHERE cc.owner = cons_rec.owner
> AND cc.constraint_name = cons_rec.constraint_name
> AND cc.table_name = cons_rec.table_name
>ORDER BY position;
>
>CURSOR col_R_curs
>IS
> SELECT column_name, position
> FROM all_cons_columns cc
>WHERE cc.owner = cons_rec.ROwner
> AND cc.constraint_name = cons_rec.RCname
> AND cc.table_name = cons_rec.RTable
>ORDER BY position;
>
>v_table_name all_constraints.table_name%type;
>v_Rtable_name all_constraints.table_name%type;
>v_ctr int;
>
>v_fklist VARCHAR2 (1000);
>v_fklist_R VARCHAR2 (1000);
>v_global_name VARCHAR2 (80);
> BEGIN
>OPEN cons_cur;
>v_table_name := NULL;
>v_Rtable_name := NULL;
>v_ctr := 0;
>
>LOOP
> FETCH cons_cur INTO cons_rec;
> EXIT WHEN cons_cur%NOTFOUND;
>
> v_fklist := NULL;
> v_fklist_R := NULL;
>
> FOR col_rec IN col_curs
> LOOP
> IF v_fklist IS NULL THEN
> v_fklist := '( ' || col_rec.column_name;
> ELSE
> v_fklist := v_fklist || ', ' || col_rec.column_name;
> END IF;
> END LOOP;
>
> FOR col_rec IN col_R_curs
> LOOP
> IF v_fklist_R IS NULL THEN
> v_fklist_R := '( ' || col_rec.column_name;
> ELSE
> v_fklist_R := v_fklist_R || ', ' || col_rec.column_name;
> END IF;
> END LOOP;
>
>
> IF ((v_table_name = cons_rec.table_name)
>AND (v_Rtable_name = cons_rec.Rtable))
>THEN v_ctr := v_ctr + 1;
> Else
> v_ctr := 0;
> v_table_name := cons_rec.table_name;
> v_Rtable_name := cons_rec.Rtable;
> End If;
>
> v_fklist := v_fklist || ')';
> v_fklist_R := v_fklist_R || ')';
>
> DBMS_OUTPUT.put_line
>
> 'alter table ' || cons_rec.owner || '.' || cons_rec.table_name
> );
> DBMS_OUTPUT.put_line
>
> 'drop constraint ' || cons_rec.constraint_name || ';'
> );
> DBMS_OUTPUT.put_line
>
> 'alter table ' || cons
RE: Set unused column back to normal (solved)
Solved -Original Message- Sent: 20 February 2002 17:20 To: 'Multiple recipients of list ORACLE-L'; 'LazyDBA mailing list' Subject:Set unused column back to normal Hi all, Any command setting back the unused column back to used ? Negate this command please ALTER TABLE mytable SET UNUSED mycol; Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard 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).
Set unused column back to normal
Hi all, Any command setting back the unused column back to used ? Negate this command please ALTER TABLE mytable SET UNUSED mycol; Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard 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).
Set unused column back to normal
Hi all, Any command setting back the unused column back to used ? Negate this command please ALTER TABLE mytable SET UNUSED mycol; Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard 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: Library Cache wait -- Who is holding this latch
I think that nobody is holding the latch anymore. WAITSTATE = WAITED SHORT. Anjo. George Schlossnagle wrote: > You shouldn't need to do that. To find out who the holders are of all latches >currently being aited on by ithers you could do > > SELECT lh.sid, ln.name, sq.sql_text > FROM v$latchholder lh, v$sqlarea sq, v$session se, v$session_wait sw, v$latchname ln > WHERE sw.event = 'latch free' > AND sw.p1raw = lh.laddr > AND ln.latch# = sw.p2 > AND se.sid = lh.sid > AND se.sql_address = sq.address > AND se.sql_hash_value = sq.hash_value > > // George Schlossnagle > // Principal Consultant > // OmniTI, Inc http://www.omniti.com > // (c) 301.343.6422 (e) [EMAIL PROTECTED] > // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 > > On Tuesday, February 19, 2002, at 11:28 AM, Diego Cutrone wrote: > > you'll have to take a library cache dump and look for the latch number >displayed in the P1 Field of your query. > > HTH > Greetings > Diego Cutrone > > - Original Message - > From: Gupta, Brijesh > To: Multiple recipients of list ORACLE-L > Sent: Friday, February 15, 2002 12:08 PM > Subject: Library Cache wait -- Who is holding this latch > > Hi All > I have a session which is waiting for Library Cache latch for 6 hours. How >can I find who is holding this latch. > This session is executing a pl/sql script ( Not package ). Latch# 60 is >library cache latch. > > > Here is from v$session_wait > >1 select * from v$session_wait >2* where sid=1005 > PROD>/ > Press Enter to Continue > > SIDSEQ# EVENT P1TEXT > --- --- -- >- > P1RAWP2TEXT > P2 P2RAW > > --- -- > > Wait Sec in > P3TEXTP3 >P3RAW time Wait STATE > --- > -- > 10055987 latch free address > @9925 > 0701C0A5E228 number > 60 003C > tries 0 00 > -1 32,962 WAITED SHORT > > > > > Thanks > > > > Brijesh Gupta > Oracle Production DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk 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: Rollback Segments
On Tuesday 19 February 2002 20:53, bill thater wrote: > > i had to do a bunch with SQL*Calc because damagement understood > Lotus123. it was less than enjoyable.;-) I was porting SQL*Calc to Unix - that was even less than enjoyable! Rgds, Bjørn. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= 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: Disable certain users from login to database while applying H
Hi Hemant, Thanks for your earlier reply. I will not lock APPS, APPLSYS and APPLSYSPUB accounts as these accounts are needed for the HR patches. In my company, we do have in-house applications which use client-server forms/reports to access (read-only privilege) the HR tables. We created user accounts for these applications. The last time when I applied HR patches, I encountered deadlock despite shutting down the concurrent manager, forms server, report server , apache server, web db 2.5 server etc. I suspected some of my users were accessing the HR tables via sqlplus/client-server forms/reports, thereby causing deadlocks. This time round, I will lock the user accounts which use client-server forms/reports to access (read-only privilege) the HR tables. Hope it helps. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 4:44 PM To: CHAN Chor Ling Catherine (CSC) Cc: [EMAIL PROTECTED] Subject:RE: Disable certain users from login to database while applying H Catherine Which database accounts will you lock ? You can't lock APPS, APPLSYS and APPLSYSPUB as APPLSYSPUB and APPS will be used by all users and APPS and APPLSYS will be used by the patch. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> 19/02/2002 05:23 PM Sent by: [EMAIL PROTECTED] Hi Gurus, Thanks for replying to my qn. "Startup Database in Restricted mode" will not work (for more details, pls refer to the email below). The following solutions : 1. Database ON LOGON Trigger => don't know whether it will work 2. Lock Database Account => I am going to use this solution. 3. Change Database Account Password => I believe it will work In our Oracle HR, we also support oracle client-server forms/reports, so I've to disable their accounts so that they do not access the HR database using sqlplus/forms/reports while I am applying patches. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: Disable certain users from login to database while applying Human As you are talking of Oracle Apps, NONE of the suggested solutions : 1. Database ON LOGON Trigger 2. Lock Database Account 3. Change Database Account Password 4. Startup Database in Restricted mode would work. The users connect to the Database in the APPS schema -- this is the "universal" schema that Oracle Apps uses. The Patch requires APPS so Restricted doesn't help (unless you grant Restricted to APPS in which case all the users can logon). Ditto about locking, changing password or writing a trigger on the APPS schema. What you can do are : 1. Shutdown the Apache server for the Self-Service Modules 2. Shutdown the Forms server for the Forms Module 3. Shutdown the Concurrent Managers. All of the above would affect ALL users. Alternatively, login to the Application as the System Administrator user and change the Application User Passwords for the users whom you want disabled. Change the passwords back to a default (WEL
RE: Disable certain users from login to database while applying H
Catherine Which database accounts will you lock ? You can't lock APPS, APPLSYS and APPLSYSPUB as APPLSYSPUB and APPS will be used by all users and APPS and APPLSYS will be used by the patch. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>19/02/2002 05:23 PM Sent by: [EMAIL PROTECTED] Hi Gurus, Thanks for replying to my qn. "Startup Database in Restricted mode" will not work (for more details, pls refer to the email below). The following solutions : 1. Database ON LOGON Trigger => don't know whether it will work 2. Lock Database Account => I am going to use this solution. 3. Change Database Account Password => I believe it will work In our Oracle HR, we also support oracle client-server forms/reports, so I've to disable their accounts so that they do not access the HR database using sqlplus/forms/reports while I am applying patches. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: Disable certain users from login to database while applying Human As you are talking of Oracle Apps, NONE of the suggested solutions : 1. Database ON LOGON Trigger 2. Lock Database Account 3. Change Database Account Password 4. Startup Database in Restricted mode would work. The users connect to the Database in the APPS schema -- this is the "universal" schema that Oracle Apps uses. The Patch requires APPS so Restricted doesn't help (unless you grant Restricted to APPS in which case all the users can logon). Ditto about locking, changing password or writing a trigger on the APPS schema. What you can do are : 1. Shutdown the Apache server for the Self-Service Modules 2. Shutdown the Forms server for the Forms Module 3. Shutdown the Concurrent Managers. All of the above would affect ALL users. Alternatively, login to the Application as the System Administrator user and change the Application User Passwords for the users whom you want disabled. Change the passwords back to a default (WELCOME) later. However, what you SHOULD do, per Oracle Support, is 1. Shutdown 2. Shutdown 3. Shutdown as I have listed above. If you are familiar with Oracle Applications Patching and are comfortable with reading the Patch drivers, you can figure out what database objects are being modified/updated/created and what Forms/Reports/HTML etc files are being modified/created by the patch. Then you can take an intelligent decision should you allow users to logon when applying the patch ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> 18/02/2002 03:28 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Disable certain users from login to database while applying Human Hi Gurus, I need to disable certain users from login to database while I apply the Human Resources Patches for our Oracle HR 11i Applications. Which is the best way to do it ? Should I write on-logon trigger to disable or should I take away their privileges to logon to report/forms/sqlplus ? What about the rest of the DBA Applications administrator ? What do U guys do to solve the dead-lock problem (If my users access the HR tables while I apply the patches, I will encounter dead-lock problem) ? Please advise. Thanks. Regds, New Bee -- Ple
Re: Rollback Segments
Bambi, HLI and OCI - that reminds me of another nice one from the dark ages. Some of you around here, who consider yourself "old" in terms of Oracle may remember, the oci call osql3(), which was later superceeded by oparse() (version 6/7-ish, I think). Well, the reason for the old call being called osql3() was that it was new with version 3! In version two, osql() was found, but it was limited to 6000 bytes of SQL statement text, where osql3() made it possible to go to to 64k. Rgds, Bjørn. On Tuesday 19 February 2002 20:18, you wrote: > Bjorn, you old coot, you've got me beat. I do remember the UFI prompt > though... User Friendly Interface... and the "real geeks" would program > their own SQL*Plus environment using HLI (now OCI) with the OROL option > which would allow the rollback of a single statement rather than a whole > transaction. Now, in my day, we had fire but we had to make our own coal > and we kept warm on the hides of old terminals that used to roam the > plains. What were things like in your day? > > Bambi. > > > -Original Message- > Sent: Tuesday, February 19, 2002 5:23 AM > To: Multiple recipients of list ORACLE-L > > There must be somebody beside myself remembering version 3, which did not > have read consistency - the great new feature of version 4. In 3, doing > > UFI> insert into emp select * from emp; > > would cause anything from having 28 rows in emp till having and endless > loop > > in the kernel only finishing when your database file ran full... > > Yep - we are some old bitter men around here... > > /Bjørn. > > On Tuesday 19 February 2002 06:43, you wrote: > > I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. > > > > Hemant K Chitale > > Principal DBA > > Chartered Semiconductor Manufacturing Ltd > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM > > Sent by: [EMAIL PROTECTED] > > > > Please respond to ORACLE-L > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST > > Group) Subject: RE: Rollback Segments > > > > > > > > > > > > > > > > > > UFI no, but the rest... that's where I started in Oracle -- version 5 > > > > --- "Conboy, Jim" <[EMAIL PROTECTED]> wrote: > > > Holy cow Mladen, what a memory! > > > > > > Does anybody else remember (or admit to) using UFI? > > > > > > Jim > > > > > > ** > > > > > > ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Conboy, Jim > > > 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). > > > > __ > > Do You Yahoo!? > > Yahoo! Sports - Coverage of the 2002 Olympic Games > > http://sports.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > 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: =?iso-8859-1?q?Bj=F8rn=20Engsig?= 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: Email --> DB (export/parse)
Hello Kitri The outlook export have indeed an option for csv files. You select export/import, export to file, select the folders and then select CSV format. It needs something from the ValuePack to work. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] > Sent: Tue, February 19, 2002 8:50 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Email --> DB (export/parse) > > Check out Import/Export feature of MS Outlook (File-> Import and Export). > I > believe there is an option to export Outlook items to a .csv format file. > I have not used it, as this feature is not installed on my PC but the > online > Help describes what it does. > > HTH, > > > - Kirti > > > -Original Message- > Sent: Tuesday, February 19, 2002 10:18 AM > To: Multiple recipients of list ORACLE-L > > > Hi, > > Does anyone know of a utility that would allow me to > export email, from say Outlook or Outlook Express, > directly to a database or to a flat file (delimited) > for import into a database? It doesn't need to be > fancy, basically just date/time, to/from, subject, > body. > > Thanks. > -w > > __ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Walter K > 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: Deshpande, Kirti > 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Oracle Licensing - Concurrent users
Thanks for the information Suhen. Seems like my company purchaser got the wrong information when he bought the license. Regards, Leo -Original Message- Date: Tue, 19 Feb 2002 21:28:31 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Leo, > > The named user license is concurrent per session/connections to the > database. > Although you have 1 userid defined you will not be allowed to have more than > 5 users connect to the instance simultaneously. > > Regards > $uhen > > While we are on the topic of oracle licensing, can someone help to clear up > some doubts on named user licensing that I have? > > We have an existing 5-named user license for a small oracle 8i (8.1.5) > database we have, but right now, it seems to be restricting the number of > user sessions to 5 sessions even though the sessions are all using the same > userid. > > Is this how the named user license is supposed to work? I was under the > impression that the named user license was for restricting the number of > users which you can create for a database and not the number of sessions. > Or am I missing out on some settings/parameters to be defined? > > Regards, > Leo > > -Original Message- > Date: Tue, 19 Feb 2002 12:00:30 -0800 > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > > I suggest you talk to your Oracle rep before getting started. > > > > 'Concurrent' licensing is no longer a valid licensing model for Oracle. > > > > They sell by named user or per CPU. Their criteria for making you > > use the CPU licensing is rather broad. > > > > Just went through a licensing audit here. Lots o fun, let me tell you. > > > > While on the subject, does anyone have a good app/spreadsheet > > or template of some kind for tracking Oracle license use? > > > > It needs to track EE and Std versions, named and CPU licenses, > > servers, databases on the servers, users on the databases. > > > > I've cobbled my own stuff together from bits of string and baling wire, > > but I'm getting tired of messing with modifying SQL everytime I want > > a different view of the data, or to see if I can squeeze another app > > in without licensing more users. > > > > Thanks, > > > > Jared > > > > > > > > > > > > "Smith, Ron L." <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 02/19/02 11:14 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > cc: > > Subject:Oracle Licensing - Concurrent users > > > > > > We have been asked to gather statistics on the number of clients using > > Oracle. This is being done to determine if we have sufficient licensing. > > We have about 100 instances to monitor. > > > > Has anyone done this? Any ideas on what "Concurrent users" might mean to > > the majority of people? > > > > We have both Oracle 7 and Oracle 8. > > > > Ron Smith > > DBA > > Kerr-McGee Corp > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Smith, Ron L. > > 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: Kwek Li Gek > 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
