test

2004-01-12 Thread Jeffrey Beckstrom
test... We have been having mail problems. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113

merant drivers on citrix

2004-01-07 Thread Jeffrey Beckstrom
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

oracle client on PC's

2004-01-06 Thread Jeffrey Beckstrom
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

Re: oracle client on PC's

2004-01-06 Thread Jeffrey Beckstrom
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

Re: oracle client on PC's

2004-01-06 Thread Jeffrey Beckstrom
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

RE: pga_aggregate_target

2003-12-29 Thread Jeffrey Beckstrom
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

pga_aggregate_target

2003-12-26 Thread Jeffrey Beckstrom
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

2003-12-23 Thread Jeffrey Beckstrom
Yesterday, wereceived 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

ora-942 message in alert log

2003-12-23 Thread Jeffrey Beckstrom
Yesterday, wereceived 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

test

2003-12-04 Thread Jeffrey Beckstrom
test

test

2003-11-03 Thread Jeffrey Beckstrom
-- 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

test

2003-10-17 Thread Jeffrey Beckstrom
-- 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

test

2003-10-15 Thread Jeffrey Beckstrom
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

test

2003-10-03 Thread Jeffrey Beckstrom
-- 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

extra thread with SQL*Net DCD turned on

2003-09-29 Thread Jeffrey Beckstrom
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

spurious threads

2003-09-18 Thread Jeffrey Beckstrom
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

Re: spurious threads

2003-09-18 Thread Jeffrey Beckstrom
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 no

Re: spurious threads

2003-09-18 Thread Jeffrey Beckstrom
se. 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

set correct next time after fixing broken job

2003-09-16 Thread Jeffrey Beckstrom
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

RE: Oracle 11i

2003-09-10 Thread Jeffrey Beckstrom
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

RE: Oracle 11i

2003-09-10 Thread Jeffrey Beckstrom
: 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

is lazydba list server down

2003-08-14 Thread Jeffrey Beckstrom
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

2003-07-22 Thread Jeffrey Beckstrom
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

RE: import from 8i to 9i /IMP-00003:ORA-02298

2003-07-08 Thread Jeffrey Beckstrom
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]

RE: Oracle Auditing

2003-06-18 Thread Jeffrey Beckstrom
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,

RE: JDBC and MTS

2003-06-17 Thread Jeffrey Beckstrom
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

Re: copying datafile nt4-w2k

2003-03-28 Thread Jeffrey Beckstrom
Presuming this is a coldbackup.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

Re: Quick Question -- 8.1.7 logs applied to 9.2.0 database

2003-03-25 Thread Jeffrey Beckstrom
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)

OTC: Perl Book

2003-03-13 Thread Jeffrey Beckstrom
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

RE: Perl Book

2003-03-13 Thread Jeffrey Beckstrom
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: Thurs

RE: Perl Book

2003-03-13 Thread Jeffrey Beckstrom
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

perl 5.8 access to oracle

2003-03-11 Thread Jeffrey Beckstrom
Just installed Perl 5.8. Ran ppm3 to install the DBD package andPPM couldn'tfind 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

Re: Service startup on Windows 2000 fails

2003-02-19 Thread Jeffrey Beckstrom
(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

RE: Oracle Support Alert 223399.1 on Export Bug 2598387

2003-02-04 Thread Jeffrey Beckstrom
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

Re: discoverer 3i to 4i upgrade

2003-01-31 Thread Jeffrey Beckstrom
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

discoverer 3i to 4i upgrade

2003-01-30 Thread Jeffrey Beckstrom
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

toad question

2003-01-29 Thread Jeffrey Beckstrom
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 !!!

2003-01-09 Thread Jeffrey Beckstrom
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

Oracle Portal w/Single-signon

2002-11-18 Thread Jeffrey Beckstrom
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

Re: [Q] how to check ORACLE thread and kill it on NT????

2002-10-30 Thread Jeffrey Beckstrom
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 -

what is purify

2002-10-24 Thread Jeffrey Beckstrom

RE: what is purify

2002-10-24 Thread Jeffrey Beckstrom
-- 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

RE: Need help from anybody using veritas netbackup on Nt

2002-10-16 Thread Jeffrey Beckstrom
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

oem 9.2.x - thin client

2002-10-16 Thread Jeffrey Beckstrom
Anybody get the web client to work. I launch from ie 5.5 andget 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

RE: oem 9.2.x - thin client

2002-10-16 Thread Jeffrey Beckstrom
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

exp/imp bug - Note:199416.1

2002-10-03 Thread Jeffrey Beckstrom
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

RE: SNP uses 60% of CPU on Windows2000 - please help

2002-09-17 Thread Jeffrey Beckstrom
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

ctrl c on PCs

2002-09-06 Thread Jeffrey Beckstrom
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

Re: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Jeffrey Beckstrom
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

nt password change and OEM

2002-08-22 Thread Jeffrey Beckstrom
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

oracle failsafe

2002-07-25 Thread Jeffrey Beckstrom
Looking for some white papers on this subject.

dbms_stats vs analyze for statistics

2002-07-22 Thread Jeffrey Beckstrom
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

RE: runaway oracle.exe thread on NT / W2K

2002-06-07 Thread Jeffrey Beckstrom
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

RE: runaway oracle.exe thread on NT / W2K

2002-06-07 Thread Jeffrey Beckstrom
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

runaway oracle.exe thread on NT / W2K

2002-06-06 Thread Jeffrey Beckstrom
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

RE: rebuilding indexes

2002-05-31 Thread Jeffrey Beckstrom
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

Runaway threads in 8.1.7.3.2 on NT/W2K

2002-05-23 Thread Jeffrey Beckstrom
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

recovery keeps wanting logs

2002-05-07 Thread Jeffrey Beckstrom
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

backupexec from Veritas on NT

2002-04-23 Thread Jeffrey Beckstrom
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

upgrade from 8.1.6 to 8..1.7.3

2002-04-17 Thread Jeffrey Beckstrom
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

RE: Developer access in test database

2002-04-12 Thread Jeffrey Beckstrom
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

move database to new server and higher version of same 8.1.7

2002-04-11 Thread Jeffrey Beckstrom
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

Re: 8.1.7.3.1. patch for NT

2002-03-25 Thread Jeffrey Beckstrom
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

poxconst - contract status report

2002-03-15 Thread Jeffrey Beckstrom
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

2002-01-24 Thread Jeffrey Beckstrom
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

2001-12-31 Thread Jeffrey Beckstrom
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

luminate

2001-12-17 Thread Jeffrey Beckstrom
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)

changing password of default users

2001-11-29 Thread Jeffrey Beckstrom
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

RE: Oracle8i on WinNT - renaming disc drives

2001-11-28 Thread Jeffrey Beckstrom
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

test

2001-11-15 Thread Jeffrey Beckstrom
-- 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

accessing reports processed by the reports server

2001-11-15 Thread Jeffrey Beckstrom
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,

Re: Client install from hell

2001-10-22 Thread Jeffrey Beckstrom
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

veritas backupexec horribly slow on one NT server

2001-09-17 Thread Jeffrey Beckstrom
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

internal error 729

2001-09-06 Thread Jeffrey Beckstrom
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

oem 2.2 web based

2001-09-05 Thread Jeffrey Beckstrom
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

mambar for Oracle by luminate

2001-08-15 Thread Jeffrey Beckstrom
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

2001-07-26 Thread Jeffrey Beckstrom
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

Veritas Backup Exec Error

2001-07-25 Thread Jeffrey Beckstrom
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

OEM nmi.log file growing

2001-07-18 Thread Jeffrey Beckstrom
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

RE: 81714 aborted upgrade and core dumps on NT

2001-07-10 Thread Jeffrey Beckstrom
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

killed sessions staying around

2001-07-03 Thread Jeffrey Beckstrom
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.

Re: Deadlock Detection

2001-06-22 Thread Jeffrey Beckstrom
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

ADMIN: Please vote (was: RE: OT SPAM : Become an Oracle

2001-06-14 Thread Jeffrey Beckstrom
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

how determine chaining if using gather_stats

2001-06-01 Thread Jeffrey Beckstrom
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

RE: how determine chaining if using gather_stats

2001-06-01 Thread Jeffrey Beckstrom
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

analyze of fnd_lobs hangs

2001-05-21 Thread Jeffrey Beckstrom
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

storage area networks

2001-03-28 Thread Jeffrey Beckstrom
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 !DOCTYPE HTML PUBLIC "-

date of last password change

2001-03-19 Thread Jeffrey Beckstrom
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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=

oem 2.2 with Oracle Apps 11.5.3

2001-03-19 Thread Jeffrey Beckstrom
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

Re:date of last password change

2001-03-19 Thread Jeffrey Beckstrom
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

c++ install failed on oraspawn

2001-02-12 Thread Jeffrey Beckstrom
ep 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 Author

Re: 8.1.5 or 8.1.7 and app 11.0 or 11i

2001-02-08 Thread Jeffrey Beckstrom
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

Re: Re[2]: People Soft dba info

2001-02-01 Thread Jeffrey Beckstrom
. 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