test
test... We have been having mail problems. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
merant drivers on citrix
Found this note on Citrix web site: DataDirect does support the use of Connect for ODBC on Citrix Metaframe and Windows Terminal Server environments. Note that due to known problems with the Microsoft MSI Engine, the installation of Connect for ODBC is currently not supported through the Citrix Metaframe or Windows Terminal Server environments. Therefore, if can use the driver on citrix but can't install it, how do you use it??? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
Re: oracle client on PC's
most of the remote sites do not have a file server at all. They access file servers at the "main office" for everything.>>> [EMAIL PROTECTED] 1/6/04 2:54:26 PM >>> --- Jeffrey Beckstrom <[EMAIL PROTECTED]> wrote:> Rather than installing the Oracle client on every> client PC, we have been:> - installing client on 1 PC> - copying directory to a network server> - extract the registry for "oracle" key> - fix registry that was extracted to reference the> network drive> - load registry on client PCs> - add the network pc as a search drive to the client> pc.> > We are now experiencing problems over the WAN and> looking at ways to eliminate the Oracle dll> overhead. Short of installing Oracle on every> client PC, what are our options?> > Jeffrey Beckstrom> Database Administrator> Greater Cleveland Regional Transit Authority> 1240 W. 6th Street> Cleveland, Ohio 44113Jeffrey,Does each WAN user reside in a location that has somesort of file server? By each office location havingits own oracle client installation on a local fileserver, the .dll traffic would be minimized. You might still decide to keep the Oracle Clientconfiguration files centralized at the main office(via the use of the TNS_ADMIN environment variable).We took the route of providing all the developerdesktops with a full fat client, but used a responsefile (for OUI) to specify only the minimum filesrequired for our environment. I'd be happy to passalong the response file.We do use centralized [tnsnames,sqlnet].ora files, butalso use ONAMES as a backup names resolution method.Haven't tackled that OID thingy yet.hth.Paul__Do you Yahoo!?Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakeshttp://hotjobs.sweepstakes.yahoo.com/signingbonus-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Paul Drake INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: oracle client on PC's
The application is a third-party application using Merant's ODBC driver. How do people normally install the client. Do you do an install to every workstation??? >>> [EMAIL PROTECTED] 1/6/04 2:54:34 PM >>> At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote:>Rather than installing the Oracle client on every client PC, we have been:>- installing client on 1 PC>- copying directory to a network server>- extract the registry for "oracle" key>- fix registry that was extracted to reference the network drive>- load registry on client PCs>- add the network pc as a search drive to the client pc.>>We are now experiencing problems over the WAN and looking at ways to >eliminate the Oracle dll overhead. Short of installing Oracle on every >client PC, what are our options?There is a reason that Oracle doesn't support configurations like this. There is a fair amount of "chatter" between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems.How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers.Justin CaveDistributed Database Consulting-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Justin Cave INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
oracle client on PC's
Rather than installing the Oracle client on every client PC, we have been:- installing client on 1 PC - copying directory to a network server - extract the registry for "oracle" key - fix registry that was extracted to reference the network drive - load registry on client PCs - add the network pc as a search drive to the client pc. We are now experiencing problems over the WAN and looking at ways to eliminate the Oracle dll overhead. Short of installing Oracle on every client PC, what are our options? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
RE: pga_aggregate_target
Will look at what you suggest. The Oracle docs suggest you using a formula based on amount of system memory. However, this is not the only database on the server. >>> [EMAIL PROTECTED] 12/26/03 3:29:26 PM >>> Jeffrey, If you are simply looking at a conversion from 8i to 9iR2, and you're not going to be implementing a bunch of new 9i features (that could affect PGA usage), then it's probably reasonably straightforward. You can look at 'session pga memory' and 'session pga memory max' statistics in V$SESSTAT to get an idea of current PGA memory consumption in 8i. The 'max' statistic is probably more interesting in terms of total aggregate memory consumption
pga_aggregate_target
Starting an upgrade project for 8i to 9i R2. How can I come up with a reasonable starting value for the pga_aggregate_target parameter? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
ora-942 message in alert log
Yesterday, we received the below message in our alert log. Normally, we do not see such messages in an alert log. It might be a spurious message since in the associated trace file it first says: FATAL ERROR IN TWO-TASK SERVER: error = 12571 which is a networking error. Maybe just had a connection problem and gave a bad error. Mon Dec 22 12:05:43 2003Errors in file f:\oracle\trace\ORA04312.TRC:ORA-00942: table or view does not exist In the trace file: *** SESSION ID:(13.65246) 2003-12-22 12:05:43.380FATAL ERROR IN TWO-TASK SERVER: error = 12571*** 2003-12-22 12:05:43.427ksedmp: internal or fatal errorORA-00942: table or view does not existNo current SQL statement being executed. @m:\sql\grants\triggers\pa_projects_all_rta Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
ora-942 message in alert log
Yesterday, we received the below message in our alert log. Normally, we do not see such messages in an alert log. It might be a spurious message since in the associated trace file it first says: FATAL ERROR IN TWO-TASK SERVER: error = 12571 which is a networking error. Maybe just had a connection problem and gave a bad error. Mon Dec 22 12:05:43 2003Errors in file f:\oracle\trace\ORA04312.TRC:ORA-00942: table or view does not exist In the trace file: *** SESSION ID:(13.65246) 2003-12-22 12:05:43.380FATAL ERROR IN TWO-TASK SERVER: error = 12571*** 2003-12-22 12:05:43.427ksedmp: internal or fatal errorORA-00942: table or view does not existNo current SQL statement being executed. @m:\sql\grants\triggers\pa_projects_all_rta Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113 ORA04312.TRC Description: Binary data
test
test
test
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test
Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
"extra" thread with SQL*Net DCD turned on
For the past 1.5 years, starting at Oracle 8.1.7.3.2 and now 8.1.7.4.10 on windows; we have encountered a problem wherein we encounter a runaway thread during patching of Oracle Applications 11i. This thread is not know to v$session and orakill will not terminate it. The only solution has been stop the database and service. Recently, following implementation of HRMS F and its prerequisites (including FND G), the runaway thread problem mutated to a major thread leakage. In our dev/test instances, with the above patches installed, we would hit 1000 threads assigned to oracle.exe per task manager After a long ODC session with support and continuously monitoring of the threads, it appeared that the "extra" thread created for each connection was not always being terminated. You get two threads per connect of which one appears to be for DCD. Friday, we turned off ODC in test and appear stable. We are now trying in dev to confirm this may be a solution. If so, we will turn it off in production and implement the patches. Does anyone have similar problems with DCD. We had seen some bugs on this but they were with 8.1.7.2.x. During our ODC session, we asked about known bugs and there were none. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: spurious threads
Tried it a number of times. Lately Oracle has us run a MS utility to take "hang dump" but no answers so far.>>> "Tanel Poder" <[EMAIL PROTECTED]> 9/18/03 9:17:17 AM >>> Well, have you tried it? In my understanding orakill is actually an OS thread killer written by Oracle, it just searches the appropriate oracle.exe based on SID and kills the thread with OS thread id in it. It does not log on to Oracle to check whether Oracle knows anything about this thread or not, it just simply kills the thread with id you provide and that's it. Tanel. ----- Original Message - From: Jeffrey Beckstrom To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 4:05 PM Subject: Re: spurious threads We know the thread id from running pslist from sysinternals.com. Orakill will not kill it probably since doesn't think it really exists.>>> [EMAIL PROTECTED] 9/18/03 9:49:41 AM >>> Hi! Orakill is able to kill threads based on thread id. But since you can't find out the "runaway" thread id-s from v$process, you could find all thread id-s in oracle.exe, minus those spids which exist in v$process and kill those. But I definitely recommend to turn to support first, because killing threads that way isn't a nice thing to do in production system and might be good enough only for temporary workaround, not for continous usage. Tanel. - Original Message - From: Jeffrey Beckstrom To: Multiple recipients of list ORACLE-L Sent: Thursday, September 18, 2003 4:19 PM Subject: spurious threads We have had an ongoing problem for nearly 1.5 years now starting with 8.1.7.3.2. If we patch the Oracle Apps 11i, a majority of the time, the oracle.exe process gets a runaway thread. A thread exists in the oracle.exe but not in v$process/v$session. Shutting down the database does not resolve the problem. Only stopping the service will resolve it. Two weeks ago implemented FND G/HRMS F in dev/test with production scheduled for this weekend. Since then have noticed high thread counts. Dev has topped out at 1000+, test is currently at 809 with only 50 v$process entries Help. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: spurious threads
We know the thread id from running pslist from sysinternals.com. Orakill will not kill it probably since doesn't think it really exists.>>> [EMAIL PROTECTED] 9/18/03 9:49:41 AM >>> Hi! Orakill is able to kill threads based on thread id. But since you can't find out the "runaway" thread id-s from v$process, you could find all thread id-s in oracle.exe, minus those spids which exist in v$process and kill those. But I definitely recommend to turn to support first, because killing threads that way isn't a nice thing to do in production system and might be good enough only for temporary workaround, not for continous usage. Tanel. - Original Message - From: Jeffrey Beckstrom To: Multiple recipients of list ORACLE-L Sent: Thursday, September 18, 2003 4:19 PM Subject: spurious threads We have had an ongoing problem for nearly 1.5 years now starting with 8.1.7.3.2. If we patch the Oracle Apps 11i, a majority of the time, the oracle.exe process gets a runaway thread. A thread exists in the oracle.exe but not in v$process/v$session. Shutting down the database does not resolve the problem. Only stopping the service will resolve it. Two weeks ago implemented FND G/HRMS F in dev/test with production scheduled for this weekend. Since then have noticed high thread counts. Dev has topped out at 1000+, test is currently at 809 with only 50 v$process entries Help. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
spurious threads
We have had an ongoing problem for nearly 1.5 years now starting with 8.1.7.3.2. If we patch the Oracle Apps 11i, a majority of the time, the oracle.exe process gets a runaway thread. A thread exists in the oracle.exe but not in v$process/v$session. Shutting down the database does not resolve the problem. Only stopping the service will resolve it. Two weeks ago implemented FND G/HRMS F in dev/test with production scheduled for this weekend. Since then have noticed high thread counts. Dev has topped out at 1000+, test is currently at 809 with only 50 v$process entries Help. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
set correct "next" time after fixing broken job
If I mark a job as broken to prevent its being run and later mark it as being unbroken, it appears that by default the "next run date" is set as the current date. If I want to have the job rescheduled back to its original date/time, is there a way to do that. Let's say the job runs daily at 10:00 p.m. If I mark the job as broken and later as unbroken without specifying a date, it runs immediately. However, I know that I can code a date when I unbreak the job, but how can I do this in sql without hardcoding a date. We have several jobs we would sometimes like halted during maintenance and would like to avoid having to hardcode a date when unbreak them. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Oracle 11i
Has Oracle made any progress on the problem. We have duty managered the TAR with no solution to date. Last update is that Oracle wants an ODC session. We are W2K on two tier. What services are giving you a problem? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 9/10/03 11:54:33 AM >>> We are having issues with reports server, too... I think it is Autoconfig. Did YOU notice that you got a whole NEW set of services (are you on Win?) when you went auto config... FEATURE!! Some of the new ones work sometimes, sometimes only the old ones will. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ >\< \ >\< \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -----Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 10, 2003 9:49 AMTo: April Wells; [EMAIL PROTECTED]Subject: RE: Oracle 11i We went from 11.5.6 to 11.5.9. As part of upgrade we implemented autoconfig. Initiallly could not print. Then put on a patch for grants and now can print - patch was titled fixes for non-standard schemas. Still can not access report server. Don't know if due to autoconfig or 11.5.9 since did not stop in between. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 9/10/03 11:39:25 AM >>> Anything break badly? We are going to be starting in about a month down the 11.5.8 -> 11.5.9 road. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ >\< \ >\< \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 11i Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the unified driver to bring all of the products bang up to date. Just when you think you're on the home straight. A driver file with 920,000 lines that starts 71,000 scripts. It's enough to start me drinking! Mike -Original Message- Sent: 10 September 2003 14:49 To: Multiple recipients of list ORACLE-L Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb. If you start with 11.5.8 or below, you'd also want to download the 11.5.9 patch anyway, which is a further 2.5Gb or so... on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at [EMAIL PROTECTED] wrote: > Tanel, > the 11.5.9 docs ask you to get in touch if you're interested in a DVD > release. It doesn't sound like it's actually available but they must be > gauging interest for future releases. > > Cheers, > Mike > > -Original Message- > Sent: 10 September 2003 02:50 > To: Multiple recipients of list ORACLE-L > > > > > You can't download 11i, you can order it for evaluation from Oracle, it's > about 50 CD (when the heck will they put it on DVD?), > > > Cheers, > Tanel. > > > > ** > ** > E mail Disclaimer > > You agree that you have read and understood this disclaimer and you agree to > be bound by its terms. > > The information contained in this e-mail and any files transmitted with it (if > any) are confidential and intended for the addressee only. If you have > received this e-mail in error please notify the originator. > > This e-mail and any attachments have been scanned for certain viruses prior to > sending but CE Electric UK Funding Company nor any of its associated companies > from whom this e-mail originates shall be liable for any losses as a result of > any viruses being passed on. > > No warranty of any kind is given in respect of any information contained in > this e-mail and you should be aware that that it might be incomplete, out of > date or incorrect. It is therefore essential that you verify all such > information with us before placing any reliance upon it. > > CE Electric UK Funding Company > Lloyds Court > 78 Grey Street > Newcastle upon Tyne > NE1 6AF > Registered in England and Wales: Number 3476201 > > ** >
RE: Oracle 11i
We went from 11.5.6 to 11.5.9. As part of upgrade we implemented autoconfig. Initiallly could not print. Then put on a patch for grants and now can print - patch was titled fixes for non-standard schemas. Still can not access report server. Don't know if due to autoconfig or 11.5.9 since did not stop in between. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 9/10/03 11:39:25 AM >>> Anything break badly? We are going to be starting in about a month down the 11.5.8 -> 11.5.9 road. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ >\< \ >\< \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 11i Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the unified driver to bring all of the products bang up to date. Just when you think you're on the home straight. A driver file with 920,000 lines that starts 71,000 scripts. It's enough to start me drinking! Mike -Original Message- Sent: 10 September 2003 14:49 To: Multiple recipients of list ORACLE-L Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb. If you start with 11.5.8 or below, you'd also want to download the 11.5.9 patch anyway, which is a further 2.5Gb or so... on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at [EMAIL PROTECTED] wrote: > Tanel, > the 11.5.9 docs ask you to get in touch if you're interested in a DVD > release. It doesn't sound like it's actually available but they must be > gauging interest for future releases. > > Cheers, > Mike > > -Original Message- > Sent: 10 September 2003 02:50 > To: Multiple recipients of list ORACLE-L > > > > > You can't download 11i, you can order it for evaluation from Oracle, it's > about 50 CD (when the heck will they put it on DVD?), > > > Cheers, > Tanel. > > > > ** > ** > E mail Disclaimer > > You agree that you have read and understood this disclaimer and you agree to > be bound by its terms. > > The information contained in this e-mail and any files transmitted with it (if > any) are confidential and intended for the addressee only. If you have > received this e-mail in error please notify the originator. > > This e-mail and any attachments have been scanned for certain viruses prior to > sending but CE Electric UK Funding Company nor any of its associated companies > from whom this e-mail originates shall be liable for any losses as a result of > any viruses being passed on. > > No warranty of any kind is given in respect of any information contained in > this e-mail and you should be aware that that it might be incomplete, out of > date or incorrect. It is therefore essential that you verify all such > information with us before placing any reliance upon it. > > CE Electric UK Funding Company > Lloyds Court > 78 Grey Street > Newcastle upon Tyne > NE1 6AF > Registered in England and Wales: Number 3476201 > > ** > ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary,
is lazydba list server down
I have not received mail from it in several days...is it down? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: domain vs local account
Same here. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 >>> [EMAIL PROTECTED] 7/22/03 11:54:38 AM >>> As our ops mgr is wont to say, "he's on crack". Nearly all of our Oracle installs on Win2k are by a domain user that may also be a domain admin. Never caused any problems, no one has ever asked. Jared On Tuesday 22 July 2003 08:04, Joe Armstrong-Champ wrote: > During a recent tar I was told by an Oracle tech that Oracle windows > installs done by a domain user (versus local user) would not be > supported by Oracle. We used the domain acct (which is also an > administrator on the machine)so that it could see the tns_admin > directory on the network. We have not had any problems with the software > as a result. The box is w2k, Oracle 8.1.7.4. > > Do most people use local accts? Are there any other reasons for > using/not using a domain acct? > > Thanks. > Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: import from 8i to 9i /IMP-00003:ORA-02298
Could your export file be corrupt. There have been a few alerts on 8.1.7 exports producing bad dump files. One alert is Note:223399.1. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 7/8/03 3:34:29 PM >>> What userid is exporting data and importing data? Try exporting and importing as system. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 08, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: import from 8i to 9i /IMP-3:ORA-02298 I tried importing data first then enabling constraints, same problem. I have disabled(it is not enabled to begin with but reporting 'ENABLED' in USER_CONSTRAINTS) one of those constraints and tried to enable it manually. Same error. And I have checked the data again. It is having parent keys. Thanks, Surendra
RE: Oracle Auditing
What do you want to audit. If all table access then I would think you would impact performance. Are you just trying to audit signon's? If so, the apps does that automatically. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 6/18/03 11:14:59 AM >>>String? Length of??It realy does depend on how much you want to audit, and how frequently, andhow big your system is, and how much traffic it carries etc etc.For example, if no one used your db for a month, your audit tables would bepretty small (grin!)peter> -Original Message-> From: Kevin Toepke [mailto:[EMAIL PROTECTED]> Sent: 18 June 2003 14:50> To: Multiple recipients of list ORACLE-L> Subject: Oracle Auditing> > > Greetings and Salutations!> > At the direction of the external auditors I have been instructed to> install/configure oracle auditing in our Oracle Applications > databases.> (sweet!) The next step is to estimate how much space all of > the auditing> information will take. (I plan on moving the data from AUD$ > to another table> on a daily basis)> > Can anyone out there in oracle-l land help me give a > reasonable estimate?> > TIA> > Kevin Toepke> Technical Analyst> R+L Carriers> (937) 382-1494 x1308> (800) 558-5456 x1308> > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net> -- > Author: Kevin Toepke> INET: [EMAIL PROTECTED]> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> -> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).> *This e-mail message, and any files transmitted with it, areconfidential and intended solely for the use of the addressee. Ifthis message was not addressed to you, you have received it in errorand any copying, distribution or other use of any part of it isstrictly prohibited. Any views or opinions presented are solely thoseof the sender and do not necessarily represent those of the BritishGeological Survey. The security of e-mail communication cannot beguaranteed and the BGS accepts no liability for claims arising as aresult of the use of this medium to transmit messages from or to theBGS. . http://www.bgs.ac.uk*-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Robson, Peter INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: JDBC and MTS
I recall an old bug where MTS would sleep for a bit - don't recall the bug anymore. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 6/17/03 12:35:20 PM >>>b) I use server=dedicated, is srvr=dedicate a short hand version ofit?-Original Message-Sent: Tuesday, June 17, 2003 8:25 AMTo: Multiple recipients of list ORACLE-LOK. Let me get some things straight:a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone.b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection.c) What was the issue that you faced? That was my original question.On 2003.06.17 07:09, Regis Biassala wrote:> Richard is right...If ur Java application uses it own connection> pooling...then do not use MTS...it slows down connections and more...We> faced the same issue here> > Our configuration allows DBA to choose weather connection pooling should> handled by the app or the database...> Use dedicated servers if there's noway you can disable the application> connection pooling...> > > Regis> > -Original Message-> Sent: Tuesday, June 17, 2003 6:05 AM> To: Multiple recipients of list ORACLE-L> > > I used to seen problems with JDBC Thin with MTS on Linux and switching to> a dedicated connection seemed to fix the problem. But JDBC Thin and MTS> worked fine on my Solaris box. Not sure with HP-UX. Is the Java> application> running on an Application Server?> > Richard Ji> > -Original Message-> Sent: Monday, June 16, 2003 11:25 PM> To: Multiple recipients of list ORACLE-L> > > I'm not a Java expert so please forgive me my ignorance. JDBC application> is facing very strange performance problems during connect. Every now and> then> everything appears to be hung and then, 10 minutes later, users proceed> normally but with the elevated blood pressure and serious lack of patience.> I was told that JDBC has it's own connection pooling mechanism and that it> will start it's own dedicated server connection. It seems though that the> string "SRVR=DEDICATED" has been ignored and that users are acquiring a> shared> server connection.> Does anybody in this group have any experience with JDBC and MTS? Version is> 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with> listeners on all 4 nodes for load balancing purposes. I found surprisingly> little material on the Metalink. No network collisions, no retransmits, no> timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet> and I would be very surprised if approximately 100 users could kill it with> a> JDBC application. They could use DBA as a human sacrifice, though.> > > > --> Mladen Gogala> Oracle DBA> --> Please see the official ORACLE-L FAQ: http://www.orafaq.net> --> Author: Mladen Gogala> INET: [EMAIL PROTECTED]> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> -> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).> --> Please see the official ORACLE-L FAQ: http://www.orafaq.net> --> Author: Richard Ji> INET: [EMAIL PROTECTED]> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> -> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).> *> This electronic transmission is strictly confidential and intended solely> for the addressee. It may contain information which is covered by legal,> professional or other privilege. If you are not the intended addressee,> you must not disclose, copy or take any action in reliance of this> transmission. If you have received this transmission in error,> please notify the sender as soon as possible.> > This footnote also confirms that this message has been swept> for computer viruses.>
Re: copying datafile nt4-w2k
Presuming this is a cold backup. I recall trying it about a year or so ago with a hot backup and had a problem with recovery not knowing when to stop - it kept wanting more log files.>>> [EMAIL PROTECTED] 3/28/03 1:43:41 PM >>>Certainly possible.I'm currently copying 8.0 files on NT to Win2k servers with8.1.7 installed. Rebuild the controlfile, open the databaseand upgrade. Works great.JaredOn Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote:> hi all>> We are planning an upgrade from NT4 to W2K.> I am considering to create a new instance on another server with W2K> installed and copying the datafiles> from the server with NT4 on it.> Is this possible ? Or do i have to use the exp/imp strategy ?>> thanks>> vr.gr.> Geo Kor> Sr. System Engineer I&DM Db> RDW Voertuiginformatie en -toelating> Holland-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jared Still INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Quick Question -- 8.1.7 logs applied to 9.2.0 database
I doubt it. I once tried recoverying a hot backup from 8.1.6 to 8.1.7 and recovery kept asking for logs. Oracle stated can only recover to the same base version. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 3/24/03 4:04:22 PM Nick Wagner wrote:> > Can I take a hot backup of an 8.1.7 instance... and then upgrade the> backup to 9.2.0 (upgrading data dictionary tables and everything) and> then apply logs created by the 8.1.7 instance to this 9.2.0 backup?> > Please answer as soon as possible...> > Thanks!> Nick Wagner> > With all the new stuff related to redo logs (logical standby, etc.)brought by 9.x, I wouldn't try it.-- Regards,Stephane FaroultOriole Software-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephane Faroult INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Perl Book
Do you know if this book covers the Perl basics or does it assume you know Perl Already. >>> "Larry Hahn" <[EMAIL PROTECTED]> 3/13/03 9:39:02 AM >>> st1\:*{behavior:url(#default#ieooui) }Jeffrey, I am emailing you direct because my reply to the list is not going through. I have heard a lot about the following book:Perl for Oracle DBAs By Andy Duncan, Jared Still I have not read it myself, but it comes highly recommended to me. Larry HahnDatabase ManagerJournal Sentinel, Inc333 W. State St.Milwaukee, Wi 53201 -Original Message- Sent: Thursday, March 13, 2003 8:01 AM To: Multiple recipients of IOUGA-VMS-L Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Perl Book
Do you know if this book covers the Perl basics or does it assume you know Perl Already.>>> "Larry Hahn" <[EMAIL PROTECTED]> 3/13/03 9:39:02 AM >>> Jeffrey, I am emailing you direct because my reply to the list is not going through. I have heard a lot about the following book:Perl for Oracle DBAs By Andy Duncan, Jared Still I have not read it myself, but it comes highly recommended to me. Larry Hahn Database Manager Journal Sentinel, Inc 333 W. State St. Milwaukee, Wi 53201 -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 8:01 AMTo: Multiple recipients of IOUGA-VMS-LSubject: OTC: Perl Book Looks like I have a need write a Perl program to access a database. Any suggestions on a good book. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204--=ED1CD27.57364D29--* This message is coming from the IOUGA VMS mailing list at resource.to. To unsubscribe, please send an e-mail to [EMAIL PROTECTED] with UNSUBSCRIBE IOUGA-VMS-L in the body. Alternatively, you can send a message to [EMAIL PROTECTED], which will automatically unsubscribe the account from which the e-mail was sent. You can get a list of the commands and options that this listserv accepts by sending an e-mail with HELP in the body to [EMAIL PROTECTED] --=extPartTM-000-dd73ad26-5541-11d7-b2dc-00a0c9dfd5bc--
OTC: Perl Book
Looks like I have a need write a Perl program to access a database. Any suggestions on a good book. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
perl 5.8 access to oracle
Just installed Perl 5.8. Ran ppm3 to install the DBD package and PPM couldn't find it. I looked at activeperl site, it stated dbd for Oracle failed. I have now installed perl 5.6 and can find dbd/dbi files. With Perl 5.8, are you supposed to use something other than dbd/dbi to access an Oracle database? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: Service startup on Windows 2000 fails
what happens if try starting the listener from the command line. >>> [EMAIL PROTECTED] 2/19/03 9:08:53 AM >>> Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried:Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Koivu, Lisa INET: [EMAIL PROTECTED] City Network Services-- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Support Alert 223399.1 on Export Bug 2598387
I just checked - there is no fix yet for it other than the workaround.>>> [EMAIL PROTECTED] 2/4/03 9:53:53 AM >>> We already made the change even though we use buffer at 64K Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 9:29 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Support Alert 223399.1 on Export Bug 2598387 I noticed that Alert 223399.1 had been added to the 9iRelease2 and 8.1.7 Support Status and Alerts summaries a few days ago. The bug described is quite significant. Last weekend I had upgraded an 8.1.7.2 database to 9.2.0.2 using export-import [as we were upgrading the OS and rebuilding the RAID-5 arrays and re-organising the file systems at the same time] and I can't just go back and verify each of the multi-million-row tables. Look up bug 2598387 -- it's scary. Hemant Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: discoverer 3i to 4i upgrade
But we rolled out the 3i version. 3i user no such option. Are you sure you can do it via 3i user. 3.1 client server can but no such option in 3i user.>>> [EMAIL PROTECTED] 1/30/03 4:54:03 PM >>>Jeff,Not sure which version of 3i you are on, but we are using 3.1.36 and thereis an option to save to file system. It can be enabled/disabled forindividual users using the Admin version.HTHSrini ChavaliOracle DBACummins IncJeffrey Beckstrom <[EMAIL PROTECTED]>@fatcity.com on 01/30/2003 02:52:44PMPlease respond to [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>cc:when we rolled out discoverer last year, we used the 3i version and not the3.1 client/server version.Now planning upgrade to 4i.One step is to save the 3i workbooks prior to dropping the current EUL.Since 3i does not have a "save to file system" option, short of having tonow roll-out the client server version, how can I save the currentworkbooks. Even if I wanted to save them myself I can't since would needto login as the workbooks owner.Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204_This e-mail transmission and any attachments to it are intended solely forthe use of the individual or entity to whom it is addressed and may containconfidential and privileged information. If you are not the intendedrecipient, your use, forwarding, printing, storing, disseminating,distribution, or copying of this communication is prohibited. If youreceived this communication in error, please notify the sender immediatelyby replying to this message and delete it from your computer.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
discoverer 3i to 4i upgrade
when we rolled out discoverer last year, we used the 3i version and not the 3.1 client/server version. Now planning upgrade to 4i. One step is to save the 3i workbooks prior to dropping the current EUL. Since 3i does not have a "save to file system" option, short of having to now roll-out the client server version, how can I save the current workbooks. Even if I wanted to save them myself I can't since would need to login as the workbooks owner. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
toad question
What privileges are needed for a "toad" user to view another users packages. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: Export/Import Error and Validation !!!
check out note 199416.1 - talks about export corruption on certain releases.>>> [EMAIL PROTECTED] 1/8/03 2:44:15 PM >>>Tracy Rahmlow wrote:> > We attempted to reorg a table and data corruption resulted. We have isolated> the issue and currently have a tar open with Oracle. But basically, when we> export the table with a buffer=10485760 the import process corrupts the data.> The row count matches, however some fields that initially were null now contain> data (there were some other odd data issues in addition). No errors were> produced during either the export or import process. When we used a> buffer=65536 the table data was correct. This is reproducable. Has anybody> seen this before? (AIX 4.3.3 / Oracle 8.1.7.3) Can the buffer size be set too> high?This is just an idea based on past problems with the OCIs, but arraysize (as in 'array fetch') is limited to 32K (smells of signed shortindex). Your buffer size indirectly specifies the number of rows youreturn with a single batch (something in the order of magnitude ofbuffer / avg_row_len). It is not impossible, if your rows are short,that your theoretical array size is past the limit and that Oracledoesn't handle it properly.-- Regards,Stephane FaroultOriole Software-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephane Faroult INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Oracle Portal w/Single-signon
Saw demos of Oracle Portal and really liked it. Have decided to implement it. We are also running Oracle Apps 11i (11.5.3 patched to 11.5.6+). From what I have seen it appears that portal must be installed in the 11i database. This just does not seem to make sense. Why would my intranet site have to be controlled by 11i availablilty. What happens if 11i is down for patching, etc. Can someone shed some light on this. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: [Q] how to check ORACLE thread and kill it on NT????
wonderfull:)) For me at least. I have been waiting ages for somebody to hit our problem. Oracle has been looking at it for months. In our case, it only happens during patching of the Oracle Apps 11i software. does this match: CPU goes to 100% (in some cases may not be that high - usually is but had a case of only at 20 %). no users logged into the database - check v$session if use pslist utility from sysinternals.com to list threads in the oracle process, you find the thread consuming cpu does not exist in the v$session view. Using orakill on the thread consuming CPU has no impact. Shutting down the database does not resolve. must stop the service to get the cpu back to normal. restart database and resume patching and all is fine. If this matches your problem would really be interested since Oracle says we are the only one with the problem. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 10/30/02 1:34:08 PM >>>We have problem on ORACLE on NT (Oracle 8.1.7). The oracle.exe show ituse 100% CPU usage, but their is NO user inside ORACL (select usrname fromv$session).I used to remember NT resource kit have tool can check which thread underORACLE.exe use most CPU time and have tool can kill it.Can anyone give me a hint?Thanks._Broadband? Dial-up? Get reliable MSN Internet Access. http://resourcecenter.msn.com/access/plans/default.asp-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: dist cash INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: what is purify
but we did not download or install it.>>> [EMAIL PROTECTED] 10/24/02 10:39:07 AM >>>See:http://www.rational.com/products/purify_nt/index.jspI think this is what they are talking about.RFRobert G. Freeman - Oracle OCPOracle Database ArchitectCSX Midtier Database AdministrationAuthor of several Oracle books you can find on Amazon.com!Londo Mollari: Ah, arrogance and stupidity all in the same package. Howefficient of you. -Original Message-Sent: Thursday, October 24, 2002 8:54 AMTo: Multiple recipients of list ORACLE-LHave we had several cases where oracle.exe on NT during patching of OracleApps 11i gets a runaway thread. This thread is not known to Oracle - not inv$session. Even if shutdown database, still at 100%. Must halt the servicefor it to resolved.Oracle is theorizing backupexec from Veritas might be a problem - butdoesn't make sense since that service is always running.Now in a dump, Oracle see's something called purify and want us to disableit to see if that makes a difference.Never heard of purify - what is this??Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Freeman, Robert INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
what is purify
RE: oem 9.2.x - thin client
But the one on the error log does not match the version on the server.>>> [EMAIL PROTECTED] 10/16/02 4:09:59 PM >>> it takes sometime to download the jinitiator -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]]Sent: quarta-feira, 16 de Outubro de 2002 20:40To: Multiple recipients of list ORACLE-LSubject: oem 9.2.x - thin client Anybody get the web client to work. I launch from ie 5.5 and get a window that "console applet has been launched" but nothing happens. In apache error log is:[Wed Oct 16 12:36:04 2002] [error] [client 10.4.2.1] File does not exist: d:/oracle/oem/oem_webstage/java-plugin/jinit11816.exe On the server we have jinit11818 not 16. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
oem 9.2.x - thin client
Anybody get the web client to work. I launch from ie 5.5 and get a window that "console applet has been launched" but nothing happens. In apache error log is:[Wed Oct 16 12:36:04 2002] [error] [client 10.4.2.1] File does not exist: d:/oracle/oem/oem_webstage/java-plugin/jinit11816.exe On the server we have jinit11818 not 16. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Need help from anybody using veritas netbackup on Nt
We use backupexec and it has an oracle agent. Maybe need something similar for netbackup. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 10/16/02 10:08:30 AM >>> No they are just using the open file option is there any other oracle agent apart from the oracle intelligent agent which you are talking about, Please let me know Thanks -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Need help from anybody using veritas netbackup on Nt Are you using the Oracle Agent to backup the DB files or you are just using the open file option? Regards Naveen -Original Message-From: Arun Chakrapanirao [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: Need help from anybody using veritas netbackup on Nt Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
exp/imp bug - Note:199416.1
Has anybody put on the patch to resolve this. On Nt, looks like fixed in 8.1.7.4.5. However, searching on the bug 2410612 reveals two other corruption bugs that appear unresolved. Have people put this patch on or waiting for a complete resolution. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: SNP uses 60% of CPU on Windows2000 - please help
Could you have a "lost" thread. We have experienced, on multiple servers, running 8.1.7.3.2. We put a patch on Oracle Applications 11i and only during the very large patches, CPU goes to 100% and stays there. If look at the threads, the one using cpu is not known to Oracle. Have had a tar open for a while on this. Oracle believes it is a logon request getting stuck. weird part is that the Oracle Apps patching program does not see an error and continues on. If we stop the database, cpu stays at 100% until we stop the service. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 9/17/02 3:35:05 PM >>>That was the starting point of entire problem. An IIS administrator came to me complaining that Oracle.exe uses 99% of CPU. Indeed, it does.What is actually wrong with oracle.exe using 99% of CPU? Every other process shows 00 under CPU and small numbers under time. I am getting to think that I was sent on a wild goose chase.That web site is up and response time is not worse that it has always been. The server is very slow in processing o/s management requests (starting performance monitor or sql*plus, or something of a sort) - well ... Thank you anyway. inka-Original Message-Sent: Tuesday, September 17, 2002 2:33 PMTo: Multiple recipients of list ORACLE-LGo to your Task Manager again and pick the "processes" tab. Click on 'CPU'to sort the processes by CPU usage or 'CPU Time" to get who has run up themost CPU usage since you last booted the system. All of your Oracle treadsrun in one process, ORACLE.EXE. The dllhost.exe should be there as aseparate process. Though from what you show in your query I could bewrong. "Inka Bezdziecka" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> @cupe.ca> Subject: RE: SNP uses 60% of CPU on Windows2000 - please help Sent by: root 09/17/2002 01:28 PM Please respond to ORACLE-L Thanks,my problem is that I hardly know how to spell Windows. Performance monitorshows Paging file usage at zero.On Oracle side I altered system and set job_queue _process = 1.when I runselect vb.name NOME, vp.program PROCESSNAME,vp.spid THREADID, vs.sid SID, vs.programfrom v$session vs, v$process vp, v$bgprocess vbwhere vb.paddr <> '00' andvb.paddr = vp.addr andvp.addr = vs.paddr;I got an output:NOME PROCESSNAME THREADID SID PROGRAMPMON ORACLE.EXE 1580 1 ORACLE.EXEDBW0 ORACLE.EXE 1404 2 ORACLE.EXELGWR ORACLE.EXE 1584 3 ORACLE.EXECKPT ORACLE.EXE 1588 4 ORACLE.EXESMON ORACLE.EXE 1592 5 ORACLE.EXERECO ORACLE.EXE 1596 6 ORACLE.EXESNP0 ORACLE.EXE 1600 7SNP2 ORACLE.EXE 2624 35 dllhost.exeSNP3 ORACLE.EXE 2532 8 dllhost.exeARC0 ORACLE.EXE 1636 11 ORACLE.EXESNP4 ORACLE.EXE 1784 18 dllhost.exeSNP5 ORACLE.EXE 644 23 dllhost.exeAs far as I know, dllhost.exe is ASP execution engine. So the culprit maybe on the application side, not Oracle.Does that make any sense?inka-Original Message-Sent: Tuesday, September 17, 2002 10:49 AMTo: Multiple recipients of list ORACLE-LI have had times on Win NT boxes when the CPU went to 100%. My experienceis that this happens when the OS is thrashing the swapfile (writing it intoand out of memory on a continuous basis). If the disk I/O is also veryhigh then that may be what's happening. However, 800M free out of 2G doesnot look too bad. If you don't have the high disk I/O then the
ctrl c on PCs
In sql*plus, if do a ctrl-c from within sqlplus I am returned to the dos prompt. However, from OpenVMS, I am kept in sql*plus. We have some scripts that do a pause in them so can terminate if a problem. However, if hit ctrl-c during the pause sql*plus ends commiting the updates. Shouldn't sql*plus just return to a prompt or is this normal on windows. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: ALTER TABLE MOVE command causes table to grow
But that's 10% per block. If all of the blocks had used the pctfree area then would have a lot of growth.>>> [EMAIL PROTECTED] 9/5/02 12:08:30 PM >>>Had an annoying surprise last week. A table had grown unexpectedly largeand I scheduled a time over the weekend to move it to its own tablespacefrom my "medium" tablespace. The table ended up growing 50%. I had anticipated it might grow somewhatgiven the PCTFREE of 10% but freeing up that space in the blocks should, atmost, have caused it to grow by 10% (assuming that 10% was completely full).Does anyone have ideas as to why it would have grown by so much? Indexesare in a different tablespace and the only other change was from an extentsize of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2Solaris 2.6Thanks,Jay Miller-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Miller, Jay INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
nt password change and OEM
On NTs that are not a Primary or Backup Domain controller, OEM install instructions were to create a local user id. This works with no problems. However, we have just implemented a policy wherein all NT account passwords now change every 90 days. Therefore, looking for suggestions on how to change the NT password and OEM passwords on a regular basis. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
oracle failsafe
Looking for some white papers on this subject.
dbms_stats vs analyze for statistics
Doing a dbms_stats with method option of 'for all indexed columns size 254' with compute optin. I notice that only indexed columns are getting column stats - as expected. Howver, if do an anaylze command instead, all columns get some sort of stats. For non-index columns, stats are apparently the min/max values for the column. Anybody see a problem with only getting column stats for the indexed columns as dbms_stats is giving me. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: runaway oracle.exe thread on NT / W2K
Problem is that can not reproduce on demand. Yesterday, we were doing the wrap up for PO G patches, i.e. generate messagess, flexfields, etc. Experienced the problem, tried redoing the same tasks and worked. Then after bringin up concurrent manager, lots of compile flexfield requests started (we had upped number of standard managers from 6 to 30). Since CPU at 100%, kept lowering number of standard managers from 30 to 20 and eventually back to 6. When requests done noticed cpu at 50%. Stopped everything and still at 50% due to a thread. Have been running 8.1.7.3.2 on another dev database for about a month with no problems, but there also had the problem but don't recall when since at the time thought it was a fluke. Did not get concerned until happened again (couple times) on another server and that's when openned the TAR. Therefore, don't know how to reproduce but getting leary of moving it to production. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 6/6/02 7:31:32 PM >>> If you cannot tie that thread to v$process then it is likely a problem with a background thread. If you are using sqlnet expire time it creates 2 threads for each connection, the timer thread will not show up in v$process. There are also a few other threads that will not show up related to process management. One approach: Once you have a database instance with this problem that you are willing to crash you can attach to it with a debugger to get a look at what is up. The simple way to do this with little expertise is to use: drwtsn32 -p This will generate a dump file (given that you haven't reconfigured dr watson) that support can review (well, the BDE group can) for content. They'll need to know the EXACT version of the database you have as well as the OS version (including service packs and hot fixes) to get the right dbg symbols in place. Regards,Michael SaleAuthor: Oracle9i for Windows(R) 2000 Tips & Techniqueshttp://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jeffrey BeckstromSent: Thursday, June 06, 2002 2:05 PMTo: Multiple recipients of list ORACLE-LSubject: runaway oracle.exe thread on NT / W2K This has now happened on 3 separeate boxes. This has happened while putting on an Oracle Applications patch or in the last case, after starting the concurrent managers for 11i with a lot of requests scheduled to compile all of the flex fields. In every instance, the thread id does not match anything in oracle. We notice that box is using 50-100% cpu even though nothing is running. Stop concurrent managers. Terminate web sessions. Exit all sqlplus sessions. Use pslist from sysinternals.com and it shows a running thread of oracle.exe using lots of user and kernal time. This thread id is not shown in v$session/process Oracle has not been of much help to date. Even after doing a shutdown immediate, cpu is still high and thread is running. Have to stop the service to get rid of it all. We had been on 8.1.7.1.5 but upgraded to 8.1.7.3.2 since minimum for our Oracle Apps patches was 8.1.7.2.x just went to the latest and greatest since know eventually would be required. Has anyone else seen anything like this. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204p
RE: runaway oracle.exe thread on NT / W2K
Tried it, but after 5 minutes - still there. Interestingly, is that if do shutdown immediate, the thread is still there!!!>>> [EMAIL PROTECTED] 6/6/02 7:21:57 PM >>>Jeffrey,As an idea - does orakill let you kill the thread off?This may let you "workaround" the issue without restarting the service.Bruce Reardon-Original Message-Sent: Friday, 7 June 2002 6:05This has now happened on 3 separeate boxes. This has happened while putting on an Oracle Applications patch or in the last case, after starting the concurrent managers for 11i with a lot of requests scheduled to compile all of the flex fields. In every instance, the thread id does not match anything in oracle.We notice that box is using 50-100% cpu even though nothing is running. Stop concurrent managers. Terminate web sessions. Exit all sqlplus sessions. Use pslist from sysinternals.com and it shows a running thread of oracle.exe using lots of user and kernal time. This thread id is not shown in v$session/processOracle has not been of much help to date.Even after doing a shutdown immediate, cpu is still high and thread is running. Have to stop the service to get rid of it all.We had been on 8.1.7.1.5 but upgraded to 8.1.7.3.2 since minimum for our Oracle Apps patches was 8.1.7.2.x just went to the latest and greatest since know eventually would be required.Has anyone else seen anything like this.Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
runaway oracle.exe thread on NT / W2K
This has now happened on 3 separeate boxes. This has happened while putting on an Oracle Applications patch or in the last case, after starting the concurrent managers for 11i with a lot of requests scheduled to compile all of the flex fields. In every instance, the thread id does not match anything in oracle. We notice that box is using 50-100% cpu even though nothing is running. Stop concurrent managers. Terminate web sessions. Exit all sqlplus sessions. Use pslist from sysinternals.com and it shows a running thread of oracle.exe using lots of user and kernal time. This thread id is not shown in v$session/process Oracle has not been of much help to date. Even after doing a shutdown immediate, cpu is still high and thread is running. Have to stop the service to get rid of it all. We had been on 8.1.7.1.5 but upgraded to 8.1.7.3.2 since minimum for our Oracle Apps patches was 8.1.7.2.x just went to the latest and greatest since know eventually would be required. Has anyone else seen anything like this. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: rebuilding indexes
But when you rebuild, it will reestablish the pctfree in all of the index blocks. If you had a lot of activity this free space would have been used in the original index and is now reclaimed. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 5/31/02 1:11:54 PM >>> storage parameter difference? None are you moving from one tablespace to another without specifying parameters? No pctfree/pctused influence? none I should have put this in the original message. Indexes stayed in original tablespace with identical storage parameters, but number of extents went from 20 to 25 (each extents is 65 8-K blocks) Matt Adams - GE Appliances - [EMAIL PROTECTED] Contrary to popular opinion, Unix is user friendly. It's just particular about who it makes friends with. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: rebuilding indexes storage parameter difference? are you moving from one tablespace to another without specifying parameters? pctfree/pctused influence? --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> wrote: > Under what conditions would an 'alter index .. rebuild' > actually case the size of the index to increase > by about 12 percent? > > > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] > Contrary to popular opinion, Unix is user friendly. > It's just particular about who it makes friends with. > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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).
Runaway threads in 8.1.7.3.2 on NT/W2K
We are running Oracle 8.1.7.3.2 on W2K/NT. We have experienced a problem while applying Oracle Apps patches that CPU shot to 100% for 4 threads. The weird part is that the patch had aborted so nothing was running in the database. Bouncing database cleared the problem. Continued with more patches and noticed CPU running at 25% with nothing running. Again bounced database and back to normal. Latest item we noticed today is that CPU is normal (less than 5%) with no users but we have 40 threads showing in task manager. Did shutdown immediate and count only went down to 30. Bounced database and now have 12 threads. If connect / disconnect, I see the count go up and then down again. Looks like Oracle is missing some threads - possibly why during our patching of the Oracle Apps we see CPU out of control. We have a TAR on this but so far Oracle is lost regarding the high CPU. Especially given that don't have it right now. Hoping the extra threads will point to something. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
recovery keeps wanting logs
Recently installed a W2k server on a SAN. Using backupexec for W2K. Initial test worked great. This week one final test before moving a production database to it. Backed up the database. Restored the database. Launched recovery, it requested the log from during the backup and then wanted more! - there is no more. Today did a test to see if it is Veritas. - put back saved disk copy of the database- started the database- manually set system, psrbs and pstemp to backup mode- ran ocopy to do the backup- set tablespaces to end backup mode- switched logfile- shutdown database- renamed directory to save- renamed the directory containing the 3 copied tablespaces to "f:\htst"- started the service- recreated the controlfile containing only these 3 tablespaces- did recover until cancel- did the log switched to and then cancelled recovery- alter database open says system needs more logs!!! Therefore, not Veritas problem. Any help appreciated. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
backupexec from Veritas on NT
Just installed latest backupexec w/agent on a new server. Testing a recoveryby trying to restore to a different directory. Files are getting a prefixadded to them. For example, backed up database htst on drive f. when restore,files are getting prefixed with fhtst. Veritas is telling us "this is how it now works". Can't believe there is no way around it. Otherwise, how take backups for disaster recovery onto a different server or cloning a 24x7 database.We routinely clone production to test/development and need to be able torestore a database backup to a different server and/or directory (in thecase where test is on a production server).Any ideas. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
upgrade from 8.1.6 to 8..1.7.3
On the same server running 8.1.6.1.5 and 8.1.7.3.2. Now ready to upgrade the 8.1.6 database to 8.1.7. Our 8.1.7 is 8.1.7.3.2, in the 8.1.7.3.0 readme it stated: Database Migration When migrating a database from an earlier release, for instance 8.0 to 8.1, you must complete the database migration to the 8.1.7 release prior to applying this patch set. You cannot perform the 8.1.7 migration after a patch set has been installed Being NT I really can't install another home of 8.1.7. Does this mean I can't upgrade directly from 8.1.6 to 8.1.7.3.x I have never heard of this before and have done it for other releases. The following is from note 148903.1 talking about upgrading to the latest version of 8.1.7 with the oracle apps. While not applicable to my case, it even states when upgrading from 8.1.6 to 8.1.7, install 8.1.7 and patch to current release and then upgrade the database: You will be upgrading directly to the current 8.1.7 patch set level. You may disregard any admonition in the 8.1.7 patch set README that warns that you cannot upgrade directly to that patch set level. So can I upgrade directly or not. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Developer access in test database
Like I said this is test. In prod, they only have select access. However, since in test have "any" rights, were able to get a sys object.>>> [EMAIL PROTECTED] 4/12/02 9:13:19 AM >>>Jeff,We have dba privileges granted to schema owners in devl databases, testdatabase mimics the prod, so they just have appropriate roles. In prod, noschema level access, everyone goes in with their own id, and no one hasthose ANY privileges.In next couple of months, we are cutting off developer access to prod. Forfixing bugs and debugging, we create a database (named DAYOLD) that is sameas production database at 5am that day. It's is all automatic, works fineand all developers are getting adjusted to the fact that prod access isgoing away.Also we have a benefit of this dayold database, we can run and test allweekly releases on the dayold database, the day before they are applied toproduction, so we can catch all errors and get them fixed by developersbefore the code release, this is imp because when we do the code release,most of the developers are probably still in bed that early in the am.Raj__Rajendra Jamadagni MIS, ESPN Inc.Rajendra dot Jamadagni at ESPN dot comAny opinion expressed here is personal and doesn't reflect that of ESPN Inc.QOTD: Any clod can have facts, but having an opinion is an art!-Original Message-Sent: Friday, April 12, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LIn our test databases, I have always granted select,insert,update,delete anytable to the developers.While yesterday, one updated a "sys" table.Be non-production, I always felt if it is destroyed can always be recreated.What table privileges do you grant in "test".Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Developer access in test database
In our test databases, I have always granted select,insert,update,delete any table to the developers. While yesterday, one updated a "sys" table. Be non-production, I always felt if it is destroyed can always be recreated. What table privileges do you grant in "test". Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
move database to new server and higher version of same 8.1.7
I don't think this should be a problem but just asking. This is all on NT/W2K On server A, I have a database running 8.1.7.1.5 On server B, I have other databases running 8.1.7.3.2. To consolidate servers I plan to:1. Take a hot backup (since it is production) of the database on Server A.2. Restore the backup to server B.3. Copy archive logs, online redo logs and control file from server A to B.4. Start the database on server B and initiate recovery - required since was a hot backup and to get any logs generated from time of backup and until actual switch over.5. Run the 8.1.7.3.2 patch scripts. I don't think this should be a problem since both databases are 8.1.7 just different versions. Note, no upgrade scripts will be run other than catalog/catproc per the 8.1.7.3.2 instructions. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: 8.1.7.3.1. patch for NT
Where did you get the patch from. I had a TAR inquireing about 8.1.7.3.2 for NT and as an aside the analyst mentioned that 3.1 was available but had been pulled with no new release date Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 3/25/02 1:45:52 PM >>>FYI,I noticed that two fies are in the patch, but not mentioned in readme.txt:Oranls8.dllOranls8.symWe are now getting bizarre errors on our 8.1.7.3.1. database:For one Web appication:Ora-02088 distributed option cannot be foundFor another:Ora-01003 no statement parsedI opened a support call.Regards,Patrice BoivinSystems Analyst (Oracle Certified DBA)Systems Admin & Operations | Admin. et Exploit. des systèmesTechnology Services | Services technologiquesInformatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPOE-Mail: [EMAIL PROTECTED]--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Boivin, Patrice J INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
poxconst - contract status report
It is using all 800 M of temp tablespace in our system. How much do you have allocated to get this program to run. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
webdba from BMC
I was looking at their site today and came across a free product called WEBDBA. Any opinions on it. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Redo Logs Question
I try to average 1 every hour or so depending on volume. You do have archiving on don't you. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 12/31/01 11:05:20 AM >>>Tom: File sizes of 5k are not good. If you have the room on your server, Iwould increase that significantly. Perhaps to 50-60m. Log switching every90 sec. is not good. There are many INIT.ORA parameters that control the performance of redologs. LOG_BUFFERS or LOG_BUFFER_SIZE is one of them. This defaults, Ibelieve, to 32k. Increase this to over 512k. There are many more. Look atyour INIT.ORA settings. Also, if you can identify the type of hardware you are running as adatabase server, we can give you some additional choices.Thank YouStephen P. KarniotisTechnical Alliance ManagerCompuware CorporationDirect: (248) 865-4350Mobile: (248) 408-2918Email: [EMAIL PROTECTED]Web: www.compuware.com-Original Message-Sent: Monday, December 31, 2001 10:20 AMTo: Multiple recipients of list ORACLE-LSubject: Redo Logs QuestionHere is the background of the stiuation I am facing.We are piloting a application that uses a hybred store and forward system toaggregate all of our disparate student data into one central database.Currently there are 20 schools integrated into the system with another 48 togo, those 20 schools hold about half of our 46k student population.The system allows (requires) student demographics to be entered through aweb client, while grades, attendance, health, conduct, etc. are uploadedover night.The system comes with the redo log file size set to 5k, which when the usersin the 20 pilot schools get going causes a log switch about every 90seconds. In my limited, steep learning curve expereince, this does not seemlike a good thing. Add to that, they cancelled the Oracle Tuning class,which I have to wait until the system is in to take now.So my questions (that the books don't really seem to want to answer):How frequently should redo log file switches occur?How large should my redo logs be?I am guessing the answer to both of these questions is, It Depends. So myquestion really is, how do I determine what the correct settings for myinstallation are?Tom-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Tom Schruefer INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
luminate
luminate.com had Oracle monitoring software. Their site now states bought out by EMC. I can not find it on EMC's site. Anyone know if the software still exists. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
changing password of default users
Due to a security problem, we are looking into changing the passwords for several default users: ORDSYS ORDPLUGINS MDSYS CTXSYS I seem to recall that if the password for these users was changed, some sql file was to be changed as well so that future runs of "catalog", etc would not have a problem. I am now unable to find such a document. Anyone know what I am talking about. Can I simply change the passwords?? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Oracle8i on WinNT - renaming disc drives
If by "rename disk drives" means changing the drive letter where Oracle is installed. You may have to re-install Oracle since the regisry will now have the wrong values. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 11/28/01 9:55:31 AM >>>Ron,When you say log files in the init.ora I assume you mean archive log files.(Mr. P. Dantic)Anyway, getting back to the task at hand, a far easier way to do it is toissue a backup controlfile to trace. Change the location of the files in thetrace file you have generated, shutdown the DB, move the files to the newlocations you have specified in the trace file. Run the trace file you haveedited and open your DB.This is a very simplistic explanation of the process but it is foolproof, itis widely documented on the web and in my experience works everytime, I havehad to do this many times without any issues.BACK IT UP FIRST, do the process and BACK IT UP AGAIN !HTHLee-Original Message-Sent: 28 November 2001 14:05To: Multiple recipients of list ORACLE-LSonja,It is a complicated process to rename disk drives in the Oracleenvironment. Depending in the drives that Oracle uses and what arechanges(renamed) could really cause you frustration.The initxxx.ora lists the current location of the controlfiles, logfiles,dump dirs, trace dirs, etc.You will have to startup the database (if it can find the controlfile) and"alter database rename .. to .." for each of the effected datafiles. It canbe a long and detailed process. These are just a few thoughts off the top ofmy head.Make notes and document everything to CYA.Good LuckROR mª¿ªm>>> [EMAIL PROTECTED] 11/28/01 05:20AM >>>List hi!Oracle 8.1.7 on WinNT.Our Windows guys want to rename disc drives for some administration reasons.I'm really in UNIX so I'm wondering could you give me some advices on thismatter.As far as I know, I have to recreate control files, with new drives. Isthere anything else I should do? Some Windows stuff?TIA, Sonja-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ron Rogers INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
accessing reports processed by the reports server
We are a two node install of Oracle Apps 11i all on NT. The question though is really with the reports server and the web server being on separate nodes. We are an apps 11i two node install. From the apps, we are able to submit a business intelligence report to the report server. However, the browser never returns. Continually tries to open a page forever. Oracle's current thought is that since the web server and report server are on different nodes, the browser could not access it. Therefore, changed the mapping for the apps "cache" to point to the database server and run apache as a user. If enter the URL directly of where the report is in the database server's file system cache, can now view it. However, the apps still hangs. If try to access the report from the "showjobs" screen, it hangs as well. Almost like web server asking the report server for the report but never gets a response?? This has been going on for a few weeks now and getting no where. Any help greatly appreciated. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
test
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Client install from hell
We have had the same problem for a long time. Work-around was to do a custom install and pick a few products at a time. Then one day decided to install Oracle workflow client and did not have a "custom" option. Oracle solved problem by granting full control to system/everyone on the drive installing to. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 10/22/01 7:50:19 AM >>>Dave,I suspect this is bug 1291239 "OUI DISAPPEARS WHILEINSTALLING OLE DB COMPONENTS" that is not yet fixed. The workaround is to do as Simon said and install inmultiple passes. 1- Choose the custom install type. Select forinstallation only the problem component (e.g. OracleProvider for OLE DB). The last itemName in theinstallactions.log is the "problem component." De-select all other components you're allowed to. Thiswill ensure that you only install the minimum numberof components possible to install the problemcomponent.2- After the first session is done, now restart OUIand start a new installation. This time you can selectthe typical install type (or any other install type).The items installed during the first pass will not bereinstalled during the second pass.BTW, both bug 1291239 and bug 1560970 appear to berelated to having the Novell client installed. Perchance is that installed on the ones giving youproblems?HTH,-- Anita--- [EMAIL PROTECTED] wrote:> > "Farnsworth, Dave" <[EMAIL PROTECTED]>> on 10/19/2001 07:15:24 PM> > Please respond to [EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L> <[EMAIL PROTECTED]>> cc: (bcc: Simon Anderson/SSplc)> > > I think I've seen this before, it certainly sounds> familiar...> I've no idea what causes it, but I found a> workaround was to only install a> small number of components at a time - for some> reason, that seems to work.> > Let us all know if you come up with a better> solution.> > Simon Anderson> > > I am having a problem on a couple of client> installs. I have Oracle 8.1.7> to be installed on NT 4.0 SP6. The install starts> out fine, I select a> Orahome and then it starts to install. When it gets> to 90% all of a sudden> the install wizard screen just disappears without> any error messages. I can> see that it created a new directory and copied a> bunch of files to the hard> drive. I can even double click on the SQLPlus icon> and it launches asking> me for a username, password, and database.> Then if I put the client CD back in and click on the> "show installed> components", it tells me that there are no Oracle> components installed. I> look in the registry and a registry for Oracle has> been created. I have> done this about twenty times and get the exact same> results. I even tried a> different CD but that does not change things.> During the install Oracle will write to a log but> this log tells me nothing> except what it installed, without one stinking clue> as to what is causing> this to puke.> I get this just on two PC's with identical results. > Has anyone seen this> before? I can go to other PC's and install without> a hitch. These PC's do> work and have plenty of disk space.> Any ideas, ,,,anything?> > Thanks,> > Dave__Do You Yahoo!?Make a great connection at Yahoo! Personals.http://personals.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: A. Bardeen INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Changing optimizer mode and collecting statistics
Would suggest testing first with choose. If you were application was written for RULE it might not run good for CHOOSE. It could run better, same or worse. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> [EMAIL PROTECTED] 10/18/01 9:20:24 AM >>>Hello We upgraded our Oracle version from 7.3 to Oracle 8.1.7 for a couple ofmonths ago. In Ora 7 environment we used optimizer mode RULE, but now wewould like to change to CHOOSE, and hopefully gain some performance. As far as I understand everything, we must collect statistics for thedifferent schemas in the database to have any advantage of the cost basedoptimizer mode. Our plan is to do this once a week (is this good enought ortoo often?). According to Oracle manual, I should use the dbms_stats packageto get statistics. So a run the following procedure to get statistics:DBMS_STATS.GATHER_SCHEMA_STATS (ownname => '', estimate_percent => 10, block_sample => TRUE, method_opt => 'FOR ALL COLUMNS SIZE1', degree => NULL, granularity => 'DEFAULT', cascade => TRUE);I plan to schedule this and run it once a week. Is this all I have to do? Itseem too easy. There must some catch somewhere or ??I'm thankfull for any help/Jonas-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jonas A Wetterberg INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
veritas backupexec horribly slow on one NT server
Running backupexec 7.3 on 5 database servers. 4 of 5 run at 40-50 M/minute. One is running at only 20 M / minute. weird thing is that the slow one is running on our fastest box (2 - 1000 MHz processors). Any ideas. Veritas just says that the database is slow. While this is a development instance with all users currently locked out. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
internal error 729
COmpiling invalid objects in 11.5.3. Getting following - used to work!!! In the trace file al I see is the following over and over Exception in getMemberoracle.aurora.classverifier.VerifierException: Class is invalid at oracle.aurora.vm.ByteCodeOptimizer.lookupBCO(ByteCodeOptimizer.java) at oracle.aurora.vm.ByteCodeOptimizer.getMember(ByteCodeOptimizer.java) at oracle.aurora.vm.ByteCodeOptimizer.optimizeInvokeVirtual(ByteCodeOptimizer.java) at oracle.aurora.vm.ByteCodeOptimizer.optimize(ByteCodeOptimizer.java) at oracle.aurora.rdbms.ResolutionDriver$ResolutionState.verificationStatus(ResolutionDriver.java) at oracle.aurora.rdbms.ResolutionDriver.verificationStatus(ResolutionDriver.java) at oracle.aurora.rdbms.Compiler.verificationStatus(Compiler.java) Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
oem 2.2 web based
Accessing via fat client works. Installed web portion on our web server and configured apache per the docs. However, it keeps trying to download oemapp_cgi.exe. Any ideas would be appreciated. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
mambar for Oracle by luminate
Anybody using Mamba without the luminate.net service. Opinions of it. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Veritas Backup Exec Error
OS is NT. 1010 means OCI version error. Successfully compiled and ran the OCI test program Oracle supplies.>>> [EMAIL PROTECTED] 7/25/01 4:43:30 PM >>> Hi, I use this same product, however I don't use it to actually backup the databases. But you never know, maybe my memory will come back to me and I could semi help.:) What OS are you using, what's the 1010 error again? KK -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jeffrey BeckstromSent: Wednesday, July 25, 2001 3:47 PMTo: Multiple recipients of list ORACLE-LSubject: Veritas Backup Exec Error Installed 8.0.6/8.1.6 as part of Oracle Financials 11i on a new server. Installed 8.1.7 in a separate home. Installed Veritas Backup Exec. The Oracle Agent keeps getting a 1010 error. Thinking might be related to the 8.1.7 stuff, renamed the 8.1.7 directory. Still get the same error. We have two other servers which are working fine. The only notable difference is that these servers at one time had Oracle 7.3 installed. Help!!! Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Veritas Backup Exec Error
Installed 8.0.6/8.1.6 as part of Oracle Financials 11i on a new server. Installed 8.1.7 in a separate home. Installed Veritas Backup Exec. The Oracle Agent keeps getting a 1010 error. Thinking might be related to the 8.1.7 stuff, renamed the 8.1.7 directory. Still get the same error. We have two other servers which are working fine. The only notable difference is that these servers at one time had Oracle 7.3 installed. Help!!! Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
OEM nmi.log file growing
We have shutdown one of our databases for extended maintenance. The nmi.log is growing about 1k per minute with the following messages. Short of removing the database from the listener, which I do not really want to do since the database will eventually be brought back up, how can I stop the messages. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: 81714 aborted upgrade and core dumps on NT
We have been running 8.1.7 for a couple weeks. The clients are 8.1.6 still>>> [EMAIL PROTECTED] 7/10/01 11:55:59 AM >>>Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have someas yet unexplained errors connecting older versions to 8.1.7 - most notablywith large objects.-Original Message-[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 3:05 AMTo: Multiple recipients of list ORACLE-LHi,I have just had the experience of upgrading to 81714, discovering a problemin our application that did not show up in any testing and having to go backto 815.The 815 instance is on a different server to the 817 instance and we stillhave the 817 instance available for further troubleshooting.This is on NT4.With 817, we were getting ora-3113 in the forms application and in ODBCconnections and also seeing ora-03121 as well.We got core dump files produced (under 817 they are produced on NT) butOracle support does not seem to know how to interpret them on NT - hasanyone had any experience with this?No mention of the core dump file was contained within the alert log and nofiles were produced in the user dump directory.When I turned sql trace on for the session running forms, the ora-3113 didnot occur - has anyone seen behaviour like this where SQL Trace will causean ora-3113 to stop occurring?All suggestions on what to look for or how to interpret NT core dumps arewelcome.Thanks,Bruce Reardon[EMAIL PROTECTED]-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Shaw, John B INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
killed sessions staying around
Killed several sessions, but none will terminate. All were connected via ODBC. Users have rebooted, etc. These sessions are several days old and killed today. Was going to try ORAKILL, but there is no thread number. Apparently, entry is on v$session but no corresponding row in v$process. Oracle only suggestion is to exit application gracefully. Oh yeah, like I can enforce that - don't touch the power off switch. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: Deadlock Detection
Is it 8.1.6.3?>? It had lots of deadlock problems.>>> [EMAIL PROTECTED] 6/22/01 9:35:56 AM >>>All,My current application (still under development) is experiencing Oracledeadlock problems. The applications people are performing stress testingwhere the application is being repeatedly called simulating actual usershitting the database.The application is written using VB thru ADO and COM, Oracle 816 on NT.My problem is that, while I can review the trace file produced, I can'tfigure out what the actual deadlock is occurring on. I have seen deadlocktrace files that clearly state "table blah", but in this case, I get:*** 2001-06-21 14:32:03.841*** SESSION ID:(27.31211) 2001-06-21 14:32:03.810DEADLOCK DETECTEDDeadlock graph: -Blocker(s)-Waiter(s)-Resource Name process session holds waits process session holdswaitsDX-003b- 22 18 X 24 27Xsession 18: DID 0001-0018-003C session 27: DID 0001-0018-003CRows waited on:Session 27: no row*** 2001-06-21 14:32:03.857ksedmp: internal or fatal errorORA-00060: deadlock detected while waiting for resourceIs there something like TKPROF that will process the trace file and give memore info on what is happening? It looks like I am waiting for a resourceto be freed, but which one is the question.thanks for any help.Tom MercadanteOracle Certified Professional-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
ADMIN: Please vote (was: RE: OT SPAM : Become an Oracle
vote for close>>> [EMAIL PROTECTED] 6/14/01 3:25:48 PM >>>I too got it, so I'm presuming they harvested this list. I'll take a lookinto the logs when I return from this business trip I'm on. I appreciateall the confirming responses. Should I find that they harvested the list,they will be removed and banned from all lists here (this is policy).However, it's becoming apparent that more spammers find this list useful andharvest from it. I have the ability to hide the subscriber list fromeveryone. I don't typically do this because there are legitimate reasons toallow people to view the subscriber list. In cases of abuse, it's a common(and effective) way to mitigate the problem. If I hide it, no one will beable to directly harvest addresses.I'll take a short vote. Please respond to me privately (here at thisaddress) if you would prefer to have the subscriber list kept open toanyone, or closed to everyone. I'll close the voting on the 19th. Remember!Don't reply to the list!! :-)Note that this doesn't affect your ability to join or leave the list; itonly affects your ability to do a WHO on the list.thanks,bruceListMaster, Fat City Network Services-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Bruce Bergman INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: how determine chaining if using gather_stats
from the docs, it states it does not compute chained row count.>>> [EMAIL PROTECTED] 6/1/01 10:00:26 AM >>>Hi Jeffrey,If you've decided to use dbms_stats, I don't know the reasons to use analyzeanymore.In terms of stored statistics DBMS_STATS will give you the same and a littlemore.I mean for example integral statistics for your partition tables. And youcan analyze tables in parallelRegards,Ed-Original Message-Sent: 1 2001 ?. 16:55To: Multiple recipients of list ORACLE-LSince oracle seems to be pushing the dbms_stats.gather_stats procedure forgetting table statistics. Do you run a separate analyze command to find thenumber of chained rows since gather stats does not get this value. Or areyou still using "analyze".Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
how determine chaining if using gather_stats
Since oracle seems to be pushing the dbms_stats.gather_stats procedure for getting table statistics. Do you run a separate analyze command to find the number of chained rows since gather stats does not get this value. Or are you still using "analyze". Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
analyze of fnd_lobs hangs
In oracle financials 11.5.3, have table called fnd_lobs. analyze table estimate statistics/compute statistics hangs. validate structure hangs - drives cpu to 60-80 percent but never finishes. dbms_stats.table_gather - works!!! Anybody else see this. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
storage area networks
Anyone using storage area networks for an Oracle database. Who is the vendor and what is your opinion of the product. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 Anyone using storage area networks for an Oracle database. Who is the vendor and what is your opinion of the product. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re:date of last password change
Thought of that, but the column is null. >>> <[EMAIL PROTECTED]> 3/19/01 8:50:21 AM >>> AH, another well written third party application!! OH, well, it's the expiry_date in DBA_USERS. Dick Goulet Reply Separator________ Author: "Jeffrey Beckstrom" <[EMAIL PROTECTED]> Date: 3/19/2001 5:05 AM anyone know of a way to find the date a user's password was last changed. I can not set up a profile with an password life time since the user logs in via a third party application which can not handle the message about grace logins. Therefore, I was going to email users when password is N days old. If user does not change then would lock user out. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 anyone know of a way to find the date a user's password was last changed. I can not set up a profile with an password life time since the user logs in via a third party application which can not handle the message about grace logins. Therefore, I was going to email users when password is N days old. If user does not change then would lock user out. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 -- 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). Thought of that, but the column is null.>>> <[EMAIL PROTECTED]> 3/19/01 8:50:21 AM >>>AH, another well written third party application!! OH, well, it's theexpiry_date in DBA_USERS.Dick GouletReply SeparatorAuthor: "Jeffrey Beckstrom" <[EMAIL PROTECTED]>Date: 3/19/2001 5:05 AManyone know of a way to find the date a user's password was last changed. I cannot set up a profile with an password life time since the user logs in via athird party application which can not handle the message about grace logins. Therefore, I was going to email users when password is N days old. If user doesnot change then would lock user out.Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META content="text/html; charset=iso-8859-1" http-equiv=Content-Type><META content="MSHTML 5.00.3211.1700" name=GENERATOR></HEAD><BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px"><DIV>anyone know of a way to find the date a user's password was last changed. I can not set up a profile with an password life time since the user logs in via a third party application which can not handle the message about grace logins. Therefore, I was going to email users when password isN days old. If user does not change then would lock user out.</DIV><DIV> </DIV><DIV>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland Regional Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio 44113<BR>(216) 781-4204</DIV></BODY></HTML>-- Please see the official ORACLE-L FAQ: http://www.orafaq.com">http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
oem 2.2 with Oracle Apps 11.5.3
Anyone know if can use OEM 2.2 with Oracle Apps 11.5.3. OEM 2.2 is supposed to be able to co-exist with 8.1.6 as long as put in a separate home. Would I have to put OEM last in the search path since it will also install sqlpluse? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 Anyone know if can use OEM 2.2 with Oracle Apps 11.5.3. OEM 2.2 is supposed to be able to co-exist with 8.1.6 as long as put in a separate home. Would I have to put OEM last in the search path since it will also install sqlpluse? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
date of last password change
anyone know of a way to find the date a user's password was last changed. I can not set up a profile with an password life time since the user logs in via a third party application which can not handle the message about grace logins. Therefore, I was going to email users when password is N days old. If user does not change then would lock user out. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 anyone know of a way to find the date a user's password was last changed. I can not set up a profile with an password life time since the user logs in via a third party application which can not handle the message about grace logins. Therefore, I was going to email users when password is N days old. If user does not change then would lock user out. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
11.5.3 on nt lost old oracle home
We had been running 7.3.4 server partitioned to 8.1.6 on NT. Installed Financials 11.5.3 from staging area and tried to bring 10.7 backup. Will upgrade once complete category 2 steps for the apps. Eventually got it up. The problem is that now can not get access to a 7.3.4 database we were using for other apps on the same development NT system. Apparently, installer created a new home putting only 8.0.6 in it. My old home of 7.3.4/8.0.6 exists on disk but not to the old installer (not the universal one). I tried switching oracle homes but all that did was alter the path. Right now I have products installed in the old default_home which can not uninstall or do anything with since the installer is not looking at them. I deleted the sid and tried using oradim73 to recreate it but it gets a illegal read or some such error. Probably because the registry says to use the home layed down by 11.5.3 for 8.0 databases and not my old oracle home. Any ideas on how to get 7.3 back?? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 We had been running 7.3.4 server partitioned to 8.1.6 on NT. Installed Financials 11.5.3 from staging area and tried to bring 10.7 backup. Will upgrade once complete category 2 steps for the apps. Eventually got it up. The problem is that now can not get access to a 7.3.4 database we were using for other apps on the same development NT system. Apparently, installer created a new home putting only 8.0.6 in it. My old home of 7.3.4/8.0.6 exists on disk but not to the old installer (not the universal one). I tried switching oracle homes but all that did was alter the path. Right now I have products installed in the old default_home which can not uninstall or do anything with since the installer is not looking at them. I deleted the sid and tried using oradim73 to recreate it but it gets a illegal read or some such error. Probably because the registry says to use the home layed down by 11.5.3 for 8.0 databases and not my old oracle home. Any ideas on how to get 7.3 back?? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Mixed case table in Pro*Cobol
Trying to access a table via a DB_LINK. The table is mixed case so need the double quotes. SQL*Plus likes the statement but Pro*cobol apparently gets confused by the quotes. Any suggestions. 1784 EXEC SQL Error at line 1785, column 55 in file interface.PCO 1785 INSERT INTO DBO."GCRTA_employeeInput"@ADS 1785 ..1 1785 PCB-S-00400, Encountered the symbol "@ADS" when expecting one of the fo^ . ( SELECT PARTITION VALUES @ The symbol "." was substituted for "@ADS" to continue. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204
RE: Ugly error in alert log
We usually put our archives in separate subdirectories per database, i.e. \archives\sid name\.arc. Also, are you naming your archives the same? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 >>> lerobe - Lee Robertson <[EMAIL PROTECTED]> 2/22/01 10:51:34 AM >>> Nope. > Lee Robertson > Acxiom > Tel: 0191 525 7344 > Fax: 0191 525 7007 > Email: [EMAIL PROTECTED] > -Original Message- Sent: 22 February 2001 15:20 To: Multiple recipients of list ORACLE-L Do you use the same location for your archivelog destination for 2 databases? Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 22, 2001 4:20 AM > All, > > Oracle 8.0.6.0.0 > Tru64 4.0f > > Anyone seen this before an d if so how did you solve it. Oracle have so far > drawn a big fat blank on this one. > > Thu Feb 1 00:03:25 2001 > ARCH: Archival error occurred on a closed thread. Archiver continuing. > Thu Feb 1 00:03:25 2001 > ORACLE Instance /usr/users/oracle/scripts/ - Archival Error. Archiver contin > uing. > ARCH: Connecting to console port... > Thu Feb 1 00:03:25 2001 > ORA-00305: log 12 of thread 2 inconsistent; belongs to another database > ORA-00312: online log 12 thread 2: '/app/oracle/oradata/drd180redo202.log' > ARCH: Connecting to console port... > > Regards & TIA > > Lee > > > > The information contained in this communication is > confidential, is intended only for the use of the recipient > named above, and may be legally privileged. If the reader > of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or > copying of this communication is strictly prohibited. > If you have received this communication in error, please > re-send this communication to the sender and delete the > original message or any copy of it from your computer > system. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). We usually put our archives in separate subdirectories per database, i.e. \archives\sid name\.arc. Also, are you naming your archives the same? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> lerobe - Lee Robertson <[EMAIL PROTECTED]> 2/22/01 10:51:34 AM >>>Nope.> Lee Robertson> Acxiom> Tel: 0191 525 7344> Fax: 0191 525 7007> Email: [EMAIL PROTECTED]> -Original Message-Sent: 22 February 2001 15:20To: Multiple recipients of list ORACLE-LDo you use the same location for your archivelog destination for 2databases?Ruth- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Thursday, February 22, 2001 4:20 AM> All,>> Oracle 8.0.6.0.0> Tru64 4.0f>> Anyone seen this before an d if so how did you solve it. Oracle have sofar> drawn a big fat blank on this one.>> Thu Feb 1 00:03:25 2001> ARCH: Archival error occurred on a closed thread. Archiver continuing.> Thu Feb 1 00:03:25 2001> ORACLE Instance /usr/users/oracle/scripts/ - Archival Error. Archivercontin> uing.> ARCH: Connecting to console port...> Thu Feb 1 00:03:25 2001> ORA-00305: log 12 of thread 2 inconsistent; belongs to another database> ORA-00312: online log 12 thread 2: '/app/oracle/oradata/drd180redo202.log'>
c++ install failed on oraspawn
Currently running Oracle Financials 10.7 on NT with Oracle 7.3.4 server partitioned to 8.1.6 on the same node. In preparation for upgrading to 11i: I successfully installed C++, MKS Toolkit and "make" on the web server. Now trying to install C++ on the database server and keep getting messages from vs60wiz.exe that ordinal 2 could not be located in oraspawn. The install program then Dr. Watson's. This box has Oracle 7 and 8.0.6 in one home and 8.1.6 in a separate home. Suggestions??? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 Currently running Oracle Financials 10.7 on NT with Oracle 7.3.4 server partitioned to 8.1.6 on the same node. In preparation for upgrading to 11i: I successfully installed C++, MKS Toolkit and "make" on the web server. Now trying to install C++ on the database server and keep getting messages from vs60wiz.exe that ordinal 2 could not be located in oraspawn. The install program then Dr. Watson's. This box has Oracle 7 and 8.0.6 in one home and 8.1.6 in a separate home. Suggestions??? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: 8.1.5 or 8.1.7 and app 11.0 or 11i
Is 8.1.7 even certified with the APPS?? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 >>> Mukesh Ghildiyal <[EMAIL PROTECTED]> 2/8/01 1:55:58 PM >>> Hello everyone I am in the process of upgrading oracle financial application from 10.7 (now running on HPUX 10.20 and oracle 7.3.4.4) to 11.0 or 11i. I have two questions 1- which one of the oracle version is more stable 8.1.5 or 8.1.7 (I will be upgrading HPUX to 11.0) 2- what is the difference between 11i and 11.0 and what are the gotchas to look for and what is the recommended verion. 3- which combination is more appropriate and stabe, please tell HPUX 11.0 oracle 8.1.7 app 11i HPUX 11.0 oracle 7.3.4.4 app 11.0 HPUX 11.0 oracle 8.1.7 app 11.0 HPUX 10.20 oracle 8.1.5 app 10.7 HPUX 11.0 oracle 8.1.7 app 10.7 Or any other recommended combination Thank you very much in replying to this I need help here Thanks again __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mukesh Ghildiyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Is 8.1.7 even certified with the APPS?? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204>>> Mukesh Ghildiyal <[EMAIL PROTECTED]> 2/8/01 1:55:58 PM >>>Hello everyoneI am in the process of upgrading oracle financialapplication from 10.7 (now running on HPUX 10.20 andoracle 7.3.4.4) to 11.0 or 11i. I have two questions 1- which one of the oracle version is more stable8.1.5 or 8.1.7 (I will be upgrading HPUX to 11.0) 2- what is the difference between 11i and 11.0 andwhat are the gotchas to look for and what is therecommended verion.3- which combination is more appropriate and stabe,please tell HPUX 11.0 oracle 8.1.7 app 11i HPUX 11.0 oracle 7.3.4.4 app 11.0 HPUX 11.0 oracle 8.1.7 app 11.0 HPUX 10.20 oracle 8.1.5 app 10.7 HPUX 11.0 oracle 8.1.7 app 10.7Or any other recommended combinationThank you very much in replying to this I need help here Thanks again__Do You Yahoo!?Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/">http://personal.mail.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com">http://www.orafaq.com-- Author: Mukesh Ghildiyal INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Re[2]: People Soft dba info
I have been supporting Peoplesoft for 5 years now. Like Dick says, it is NOT written for Oracle and does not use constraints, packages, etc. It has its own data dictionary which it uses when altering tables. I wrote SQL to repopulate the Peoplesoft dictionary with sizing from the catalog. Never had any classes just picked it up. When needed some help, asked our developers who went to the classes. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 >>> <[EMAIL PROTECTED]> 2/1/01 10:32:17 AM >>> Mike, Does PeopleSoft have database training, Yes. Will it help you with Oracle, NO WAY IN HELL!. PeopleSoft uses Sql*Server in their development & training. They also don't do anything outside of the PeopleTools suite. Therefore, for database sizing, performance tuning, backup & recovery, etc... Your on your own. To PeopleSoft a "database" is equal to a schema, although they don't really like, but do accept, having more than one schema inside one database instance. I do recommend the following PeopleSoft classes though, PeopleTools I & II (this is the basic stuff), Configuration & Administration (configuration pertains to the Application server from BEA & the process scheduler), Upgrade & Data Management workshop (really gets into the upgrade process which is very involved). If possible you should also take a PeopleCode class. Dick Goulet Reply Separator Author: "Mike Lanteigne" <[EMAIL PROTECTED]> Date: 2/1/2001 6:48 AM Hi Joan, I'm starting a job soon supporting a database holding PeopleSoft data, so I was looking for a heads up on what I should expect. 'PeopleSoft Training' -- See, I didn't know they had specific PeopleSoft database training, so that's good to know. I'll look at the places you suggested, Thanks Mike - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 1:37 PM > Mike, > > I do have a lot information. I've been working for peoplesoft/oracle dba for > 2 years and got all the peoplesoft training. What kind of information you > want? If you just want basic information. IOUG has a peoplesoft sig group, > they have a lot of papers for all HR and FR. Peoplesoft customer connection > has tons of info for a oracle dba too. > > Joan > > -Original Message- > Lanteigne > Sent: Wednesday, January 31, 2001 12:21 PM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > I was wondering if anyone has info or leads in the particulars of managing > an Oracle database supporting PeopleSoft. Oracle version 7.3. > > Thanks > > Mike > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mike Lanteigne > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Joan Hsieh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Mike Lanteigne INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want