Re: DBMS_STATS

I don't know from Steve. However I can tell from my experience that the options GATHER STALE and GATHER EMPTY have problems. Regards. --- Anand Prakash <[EMAIL PROTECTED]> wrote: > Steve > > You mentioned about dbms_stats having some teething > problem on version 8.1.6. Can you provide some mor

Bored!!!

Dear Audrey, Change your employer, go some place where you have N number of platforms and N types of DB's. I am sure u will soon say the opposite. Regards __ Visit us at www.singaporeair.com.

Setting event 10032

hi all, this is an excerpt from Steve Adams site http://www.ixora.com.au/newsletter/2000_12.htm First you need to determine the largest disk sort that is performed by the batch process. This can be done by setting event 10032 at level 1 in the session and then examining the process trace fil

Re: Why default domain?

In short, I don't. I use local resolution (as our ONS is frequently down and unreliable) and none of my aliases have domain names attached to them. In my sqlnet.ora, the entries about default domain, etc. are all commented out. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio

RE: Rename alert log

Hi, I have just found the email I posted earlier about this in the List archives. To find it search for "when it will need to delete the alert log file" I can't comment on the accuracy with respect to Unix as don't use it. Under NT as others have said you can just rename the alert logfil

RE: Sizing a new server

Hi Lisa, I also have good feelings for VMS so don't see the problem with an Alpha. As for the disk farms, the RAID 7000 gave very good performance on VMS so 2 of the es10K should be excellent. You and your company are of course aware that Compaq is planning to stop Alpha chip development in 2-3

Re: oradim

Try the Oracle 8i Admin guide for NT Here's the ORADIM part: http://www-wnt.gsi.de/oragsidoc/doc_817/win.817/a73008/ch5.htm#1027981 Jared lhoska@calibre

HASH_MULTIBLOCK_IO_COUNT

Jared - we were wrong, there are worse applications than Remedy out there. I may be involved with one now. The application uses massive sql statements generated from a VB front-end connecting to COBOL on the server via ODBC that runs against the database. Some of our power users have been receiv

Why default domain?

The O'Reilly Net8 book states: "It's possible to run a Net8 network without using domains at all." If this is true, why create net service names that are qualified by a domain name, why define a default domain in sqlnet.ora, etc.? What benefit do you get by setting things up to use a domain? -

Privilege problem ?????

Hi all, I wrote a script for developers to run. I have svrmgrl, connect internal in the script. The developer got error since he doesn't have privileges. So how to make the script runnable by non dbas??? Thanks. Andrea __ Do You Yahoo!? Get pe

RE: Email/Paging/Mobile Phone alerts

Does anyone have a similiar script for doing the same on Windows NT.   Thanks Ravindra -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John CarlsonSent: Thursday, February 22, 2001 5:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: E

Re: How to execute Unix Command/program within a pl/sql block.

Unless I disrember, you can create a PL/SQL wrapper for your Java stored procedure, and call OS commands from that. Another way is to create an external library to do it for you. This can also be in in Java, or in C. Jared

DBMS_STATS

Steve You mentioned about dbms_stats having some teething problem on version 8.1.6. Can you provide some more details? I was planning to implement on version 8.1.6.2 on Compaq Tru64 unix 5.1. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ana

Re: oradim

when you create the bat file using the db assist you should see in that bat file like below set ORACLE_SID=orcl e:\orant\bin\oradim80 -new -sid orcl -intpwd oracle -startmode auto -pfile e:\orant\database\initorcl.ora e:\orant\bin\oradim80 -startup -sid orcl -starttype srvc,inst -usrpwd oracle

Re: UNIX

Nope, you don't need an entry in the /etc/vfstab. You can just do a mountand you're set. Of course that won't be remounted when you reboot unless you put it in the vfstab. This is a classic blunder (you mount a new fs by hand, add datafiles and forget to add it to the vfstab. Low and beho

Re: need to recreate database

Tuesday, July 10, 2001, 1:26:38 PM, Lyuda wrote: lcc> I have not done it before and if I was doing it I would probably do lcc> export/import type of thing but the higher ups would like to have it done lcc> this way. Uh oh. Damagement at work again. Let the "higher ups" do it themselves if they ar

RE: oradim

If you have already installed the oracle binaries on the machine the next thing you should do is to use oradim utility or the best thing is use database assistant which will create the oradim script for you.In order to get this oradim script all you have to do is to save the database creation s

Re: UNIX

Richard, I think I know what you want. If you are trying to determine the actual physical disks that your datafiles are layed out on, and you're on Solaris, you probably need to use the 'vxprint' command. This assuming you have Veritas volume manager, which many Solaris sites use. What you fi

lock problem

Hi, we need to create a index on hot table(lot of updates r going on) but we r getting error: ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified when i use create indexonline it just hangs there... Is there any option to create index while not stopping the bat

RE: UNIX

Shoot, had to look up pedantic... Ok, I agree that df looks at /etc/mnttab to see mounted file systems, but in order for an SA to mount a slice of a disk, that slice information must be present in /etc/vfstab. At least that's the way I learned. It's possible to have a mounted file system withou

RE: oradim

Lyuda, Besides a brief mention in the Oracle8i for Windows 2000 Release Notes, all I've found (and needed, for that matter) is via executing "oradim -help" at the command line. Oradim doesn't do very much and "oradim -help" lays it all out for you. Jack Jack C.

RE: UNIX

You do have 4 disks, it's t0, t1, t2 and t3. Each target is a separate disk. You can use the "format" command to see the disks and it's partitions. >>> [EMAIL PROTECTED] 07/10/01 04:20PM >>> Joe, Chris uh, yeah Joe, I guess that's what I'm asking...I'm just trying to map the tablespaces/da

RE: UNIX

Somebody posted this url here a while back.  It's a pretty neat tool, but you gotta have root access to run it. http://members.tripod.com/rose_swe/cfg/cfg.html   --- === Michael P. Vergara  | I’ve got a PBS

Re: UNIX

Not to be pedantic, but df -k shows all mounted partitions, regardless of whether they are in /etc/vfstab or not. It requires read permisions on /etc/mnttab (whihc should be readable by everyone, but I suppose some sick SA could change it so that only root could read it. The system would functio

Re: need to recreate database

Lyuda, My guess is that if your networking folks performed the "copy" for you and now all you have to do is get it up and running, you're probably better off starting over. If the database wasn't shutdown when the controlfiles were copied, you're hosed. I have no idea what you mean by copying

RE: UNIX

Richard, as for the raid one, you'll need to find out what raid software is being used and that should let you peek underneath the logical volumes to see how the physical disks are sliced/diced.     joe >>> [EMAIL PROTECTED] 07/10/01 04:20PM >>> Joe, Chris   uh, yeah Joe, I guess that's

Re: Installation oracle through responsefile

With WWS help, we have tried the non-interactive installation. We have NEVER gotten it to succeed. Terry Brijesh Lal wrote: > Hi All > > I am trying to install oracle 8.16 in non-interactive > mode(silent) mode. However installation does not > proceed and fails > I am giving following command >

RE: UNIX

Richard, df -k will show you what slices of a disk have an entry in /etc/vfstab AND have been mounted using the mount command in Solaris. Whoever has root privileges to the system (or have been given the right permissions) can use the format command to see all disks attached to the machine, no m

RE: UNIX

Joe, Chris   uh, yeah Joe, I guess that's what I'm asking...I'm just trying to map the tablespaces/datafiles to the disk and "df -k" gives me something like   Filesystem    Mounted on/dev/dsk/c0t3d0s0 //proc   /procfd  

Re: Rename alert log

Does anyone know starting from which version you have to do the tricky thing to rename the alert.log? Or is this only apply to certain OS platforms? I am on 8.1.7 EE on Solaris8 and I can still just move the alert.log and Oracle will just recreate one when it needs to write the next message. I

RE: OT - get together for list participants in DC area

:) -Original Message- Sent: Tuesday, July 10, 2001 3:54 PM To: Multiple recipients of list ORACLE-L Or the eau de fava bean... "Mohan, Ross" wrote: > > It's possible, sure..good idea. > > It may just wind up being you and I > Alex, in which case I can buy your beersif you don

Re: need to recreate database

Lyuda, If the database is still running on the old server, and the disk structure is the same on the new server, the easiest way is to do an export of the old database and an import with full=Y on the new server. If the database was shut down before the files were copied, this should also wo

Installation oracle through responsefile

Hi All I am trying to install oracle 8.16 in non-interactive mode(silent) mode. However installation does not proceed and fails I am giving following command runInstaller -silent -responsefile /oracle/response/ ee_typical.rsp However in /tmp/silentInstall.log I get following error No forced val

Re: OT - get together for list participants in DC area

Or the eau de fava bean... "Mohan, Ross" wrote: > > It's possible, sure..good idea. > > It may just wind up being you and I > Alex, in which case I can buy your beersif you don't mind the speedo. > > :) > > -Original Message- > Sent: Monday, July 09, 2001 5:26 PM > To: Multipl

Re: Rename alert log

For the listener I had do the following to get listener to archive its old logs lsnrctl set log_file $ORACLE_HOME/network/log/listener1.log    mv  $ORACLE_HOME/network/log/listener.log  $ORACLE_HOME/network/log/listener.log.$QUALIFIER    lsnrctl set log_file $ORACLE_HOME/network

Re: UNIX

Richard, are you asking about how to see the underlying striping/slicing?  I thought only the unix/sysadmin could tell you for sure, or the person who did the original slicing.   joe       >>> [EMAIL PROTECTED] 07/10/01 01:51PM >>>Does anyone know of a command or file that would display the

RE: Rename alert log

Yup -Original Message- L. Sent: Tuesday, July 10, 2001 03:57 To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTE

RE: Rename alert log

Title: RE: Rename alert log same here. jon -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rename alert log I am running 8.1.7 and just last week renamed my alert.log

oradim

Can anyone point to oradim utility documentation? I am having a little hard time finding it. Thank you. Lyuda Hoska -- 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 Dieg

RE: Rename alert log

Oh yea, I forgot to mention that I have Oracle running on NT. :( Dave -Original Message- Sent: Tuesday, July 10, 2001 2:06 PM To: Multiple recipients of list ORACLE-L I am running 8.1.7 and just last week renamed my alert.log while the database was up and everything seemed to work fin

Re: help how get the n top rows for any table?

Alexander, Tuesday, July 10, 2001, 1:45:51 PM, you wrote: AO> Hi, gurus!!! AO> A need know how get n top row for any table somebody can help me!! AO> Thanks!!! AO> @lex AO> AO> Lic. Alexander Ordóñez Arroyo AO> Caja Costarricen

RE: O9i Licensing

Specifically, what Steve and I are looking for are a list of things that, in 8i, were NOT included in the Standard Edition but MIGHT be included in the Standard Edition in 9i. Bitmapped indexes, partitioning, and transportable tablespaces are a few. Oracle has done this sort of thing in the past

Re: need to recreate database

>>> [EMAIL PROTECTED] 07/10/01 01:26PM >>>Hello,I need to recreate a database, basically make a complete copy of one of theexisting databases on a new server.  My networking people already copied alldatafiles, control file, log files, init file, etc to the target server.They also reproduced o

No Subject

Registry, services? OH wait must be an NT thing, sorry, i was having an acid flashback that unix was going down the tubes. Sorry, joe Coed-naked Database Administration Find 'em fragmented, leave 'em coalesced. >>>[EMAIL PROTECTED] 07/10/01 01:26PM >>> Hello, I need to recreate a database,

RE: UNIX

Df -k This does not cover raid volumes, that would depend which volume manager your using. -Original Message- Sent: Tuesday, July 10, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box

RE: Rename alert log

I am running 8.1.7 and just last week renamed my alert.log while the database was up and everything seemed to work fine. It created a new alert log on the fly. Dave -Original Message- Sent: Tuesday, July 10, 2001 1:01 PM To: Multiple recipients of list ORACLE-L In 816 on NT, you can r

RE: Rename alert log

Hmmm...in Oracle 7.3.4,, 7.3.5, 8.0.5, 8.0.6, 8.1.6, and 8.1.7 on HP/UX 10.20/11.0, a rename of the alert log causes a new one to be created with the next message. My "AlertLogChecker" renames the alert log if it finds an error in there. As I'm attempting to size partitions for a non-partitioned

RE: Rename alert log

dunno about NT, I do know that it changed on Unix.. as per a thread here in the not too distant past. I believe Anita had posted something on it.. and that it WAS a change from prior versions. I am an Oracle on NT ignoramus :) >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >Reply-To: [EMA

RE: Date / Time

Sajid: Try this piece. I use a version of it for my uptime.sql script: TO_CHAR(TRUNC(date1 - date2)) || ' day(s), ' || TO_CHAR(TRUNC(MOD(date1 - date2 - 1, 1) * 24)) || ' hour(s), ' || TO_CHAR(TRUNC(((MOD(date1 - date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24))) * 60)) || ' minute

UNIX

Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box and/or the corresponding disks for each mount point??? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat

RE: Client Connection-SQLNET ?/? ODBC.

Hello James, Every ODBC connection I've seen or used has connected through SQL Net (i.e,., app->odbc->sqlnet->database). But ODBC isn't really my area of expertise... Jay Miller -Original Message- Sent: Tuesday, July 10, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Dear DBA

Re: Date / Time

Hi The script below may help you - it will display different components in separate columns, modify it with your two dates and proper table name and remove what you don't need select sysdate, sysdate - to_date('0307200100', 'DDMMHH24MISS') diffr, trunc(sysdate - to_date(

Re: help how get the n top rows for any table?

If you're running Oracle8i, you can do this: SELECT * FROM (SELECT * FROM my_table ORDER BY col_name_1 DESC) WHERE ROWNUM < 10; Use this workaround with prior releases: SELECT * FROM my_table a WHERE 10 >= (SELECT COUNT(DISTINCT maxcol) FROM my_table b WHERE b.max

RE: Rename alert log

In 816 on NT, you can rename it any time you want. is this changing in 817 Rachel? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 10, 2001 1:27 PM To: Multiple recipients of list ORACLE-L depends on the version of the database you are running.. it

RE: OEM 2.2 client for Sun

Look in your $ORACLE_HOME/bin directory.  There should be an "oemapp" executable.  The OEM console is started by:  "oemapp console".    hth -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 11:41 AMTo: Multiple recipients of list ORACLE-L

RE: Rename alert log

Ron: If you mean, "Can the alert log be renamed for archiving purposes while the db is up?" the answer is yes. Oracle will just recreate the alert log the next time it needs to write an entry to it. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --

Re: Date / Time

On Tue, Jul 10, 2001 at 05:26:09AM -0800, Sajid Iqbal wrote: > I want to display the "time elapsed" between two dates - in days, hours, > minutes and seconds. > > If I do "select date1 - date2", the result is : 12.0194907 > > Is there a function that will turn the number of days into something

RE: gzip does not want to work with files > 2G

I also uses gzip 1.3 on Solaris 8 (1999-12-21 build). The one that comes with Solaris 8 was 1.2.24 or something which doesn't support file >2G. Did you get rid of the old gzip 1.2.24? Make sure it's using the new one that you installed not the old version. >>> [EMAIL PROTECTED] 07/10/01 10:0

RE: Rename alert log

Yes. Rename delete trimmedetc. -Original Message- Sent: Tuesday, July 10, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: 81714 aborted upgrade and core dumps on NT

Hello, you can email me with zipped core file. 10/7/01 07:51:51, "Jeffrey Beckstrom" <[EMAIL PROTECTED]> wrote: > > > >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

RE: Rename alert log

Yes, it can. Just rename it and there will be new one created with an old name at some point. -Original Message- Sent: Tuesday, July 10, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the off

Re:RE: O9i Licensing

Walt, Thanks man, my 401K can use the boost!! Dick Goulet Reply Separator Author: "Weaver; Walt" <[EMAIL PROTECTED]> Date: 7/10/2001 8:02 AM Well, if you're lucky enough to use the Enterprise Edition you'll be saving money. We use the Standard

OT - get together for list participants in DC area

It's possible, sure..good idea. It may just wind up being you and I Alex, in which case I can buy your beersif you don't mind the speedo. :) -Original Message- Sent: Monday, July 09, 2001 5:26 PM To: Multiple recipients of list ORACLE-L There will be MAOP DBA SIG meeting on J

RE: O9i Licensing

This is the list for 8i: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server .817/a76962/ch4.htm http://technet.oracle.com/doc/oracle8i_816/server.816/a76962/ch4.htm http://technet.oracle.com/doc/server.815/a68020/ch4.htm Although they are two different URL's the

Question about OFA and RAID 5

Any suggestions on the message below would be greatly appreciated. Thanks in advance. I have been appointed our new Oracle DBA and have since been taking classes and reading books. I quite enjoyed the recent thread on OFA. I seem to have a bit of a quandary, here it is. We have 68 school

help how get the n top rows for any table?

Hi, gurus!!! A need know how get n top row for any table somebody can help me!! Thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Inform

RE: Rename alert log

Yes -Original Message- Sent: Tuesday, July 10, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED

RE: Performance/Optimization/Monitoring Tools

Other than those from the companies you have mentioned (and personally - as already mentioned - I would stay away from CA) here are a few others to bear in mind: NORAD Surveillance Module - www.bradmark.com (also www.cool-tools.co.uk) (Sits in between Spotlight & Foglight from Quest, except chea

Re: Rename alert log

depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, sim

RE: Performance/Optimization/Monitoring Tools

I would say now that CA owns ERwin it pretty much is terminal, regardless of whether or not its the last release they send out. -Original Message- Sent: Monday, July 09, 2001 9:00 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: > For those of you who maybe interes

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.---

RE: Client Connection-SQLNET ?/? ODBC.

Yes, you do need to have Net8 installed in order for Cold Fusion to connect to the database through ODBC. It uses ODBC through SqlNet. First set up the Sqlnet connection to the database, then set up the ODBC connection using the service name you used for the Sqlnet connection. hth, Robin

RE: O9i Licensing

Yeah, I noticed that about the pricing too, for the E10k it is still 2.6 Million, same exact price as before. -Original Message- Sent: Tuesday, July 10, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Both are still there, and despite the hype it actually looks like a price incre

need to recreate database

Hello, I need to recreate a database, basically make a complete copy of one of the existing databases on a new server. My networking people already copied all datafiles, control file, log files, init file, etc to the target server. They also reproduced operating system directory structure. What I

OT : Oracle datawarehouse DBA available in Canada

Hi, Sorry for the out of topic post. I'm going back to Canada. I'll be looking for a position as an Oracle devlopment dba in the datawarehousing field for the Montreal area. I do not know if they are recruiters looking for candidates in the Montreal area but if so you can contact me at [EMA

RE: Client Connection-SQLNET ?/? ODBC.

Yes you need SQLNET. odbc uses sqlnet on the client. -Original Message- Sent: Tuesday, July 10, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Dear DBA Colleagues, Please pardon me if this question is a bit elementary, but this concerns applications connecting to Oracle. Most

RE: Sizing a new server

Title: RE: Sizing a new server Actually, it really depends on the industry at the moment as to whether or not money is no object.  Currently money is a huge issue.  The semi-conductor fabs are not doing so hot right now (at least not the memory producing ones).  Fabs are all pretty much in a

Re:Client Connection-SQLNET ?/? ODBC.

James, First off, Linux does not use DLL's, that's a MicroSlop thing. It does make use of .so files for Shared Object, which is a Unix thing. Now as to the subject of ODBC: ODBC stands for Open Data Base Connectivity which again was a MicroSlop idea that has caught one. OK, I'll give G

RE: Date / Time

SELECT 12.0194907 ,FLOOR((12.0194907*86400)/86400) || ':' || TO_CHAR(TO_DATE(ROUND(SUBSTR(12.0194907,INSTR(12.0194907,'.'))*86400),'s '),'HH24:MI:SS') FROM dual HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajend

RE: Alert log scan script

Ron, I've attached one that I also got from the list some time ago, you may need to use something like bablefish to translate the comments :) HTH Mark -Original Message- L. Sent: Tuesday, July 10, 2001 02:32 To: Multiple recipients of list ORACLE-L Last week I was bit by a corrupt bl

Re: OEM 2.2 client for Sun

i dont know the answer to that one for sure, but its available for linux(java based) so i'd think it should be available.   joe >>> [EMAIL PROTECTED] 07/10/01 09:45AM >>> Hi gurus, We work with OEM 2.1 client on PC and Sun stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stati

RE: Rename alert log

Ron: Yep. Do it every night at midnight. But...you can't just rename it! If you do a command like... mv alert_SID.log alert_SID_010710.log touch alert_SID.log ...Oracle will still append new entries to the old file, and your new alert_SID.log file will continue to have 0 bytes. What you need

old stats and temp space

Is there any correlation between out of date analyze stats and temp space usage? i.e., could old stats cause overly large temp space usage? Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706

RE: 12514 Error

Hi Definitely check whether you can ping the server from the client. If not, then it's a network config problem. After that, I once had this problem when a highly creative user (actually, our CTO) had entered a setting for Oracle Names when we were using local names only. I had to delete the se

Re: Alert log scan script

Try AlertView from zephyrus.com. It is a free tool for analyzing your alert logs. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 9:31 AM > Last week I was bit by a corrupt block on an index. I run Analyze every > w

ORA:12514 Error

Hi, I had installed oracle 8.1.7 on WINNT and installed oracle client with administrator utility on win2k system. When i want to connect to this client on win2k to server on winnt. But i am getting the error ORA:12514. Can any one slove this for me. The listener.ora and tnsnames.ora files seems to

Rename alert log

Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public In

RE: db-links question

Alex, Yes, the connection remains open unless it is explicitly closed (see Note: 1034343.6). The session also takes out a lock on the local RBS (see Note:74811.1) as this could be part of a distributed transaction. If this is a long running query this can lead to abnormal growth in the RBS sinc

RE: any dangers of using UTL_SMTP

Thank you very much everybody for your expert comments. That really helped me to put my case with manager who has concerns about using UTL_SMTP with loading java in database. Thanks again Sandesh -Original Message- Sent: Friday, July 06, 2001 4:38 PM To: Multiple recipients of list ORAC

RE: O9i Licensing

haven't found it in the concepts manual... can't remember where it was in the 8i docs >From: "Orr, Steve" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: O9i Licensing >Date: Tue, 10 Jul 2001 06:05:25 -0800 > >Thanks

Re: Alert log scan script

I believe that a dedicated window running tail -f 10 /alert_log_filename will keep an eye on the last 10 lines of the alert log in Unix/Linux. - jeremy donson CateredComputing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat C

Re: Date / Time

Sajid Iqbal wrote: > > Hello All > > I want to display the "time elapsed" between two dates - in days, hours, > minutes and seconds. > > If I do "select date1 - date2", the result is : 12.0194907 > > Is there a function that will turn the number of days into something more > legible? Ideally

RE: Sizing a new server

Title: RE: Sizing a new server Hi Lisa,   That doesn't sound too bad, the 8400 is a solid piece of kit. 64-bit, up to 14 CPUs and 28G of memory. They have seriously good I/O bandwidth. Needs a three-phase power supply and weighs, literally, half a tonne. And best of all, you can run VMS on

RE: 81714 aborted upgrade and core dumps on NT

Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have some as yet unexplained errors connecting older versions to 8.1.7 - most notably with large objects. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:05 AM To: Multiple recipients of list OR

RE: Oracle support phone number

1-800-223-1711 (Silver) -Original Message- Sent: Monday, July 09, 2001 4:52 PM To: Multiple recipients of list ORACLE-L 1-407-240-8900 -Original Message- ] Sent: Monday, July 09, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Could some

Oracle DBA with Data Warehouse Exp.-Albany, New York

Healthcare solutions company in Albany, New York needs an Oracle DBA to join it's I.T. team. This company provides technical solutions to pharmacy, HMO and hospital clients. They are calling it a "Developmental DBA": You will be responsible for all facets of development related to the logical data

Re: Date / Time

Sajid, Unfortunately, I ran into the same problem. I didn't find anything to do it for me, either, so I had to write the pl/sql code. It is very long and messy, but can be done. When I did it, I didn't even attempt the days notation. Here is the code that I wrote: date

Client Connection-SQLNET ?/? ODBC.

Dear DBA Colleagues, Please pardon me if this question is a bit elementary, but this concerns applications connecting to Oracle. Most of our Oracle Apps are PowerBuilder-based such that we use the appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to SQLNET and the Oracle RDBMS

RE: can/do indexes chain?

Even for inserts, index key values cannot span multiple blocks. An attempt to create an index where a single key value won't fit in a single block will result in an ORA-1450 "maximum key length exceeded". -- Anita --- "Hillman, Alex" <[EMAIL PROTECTED]> wrote: > Update in the index is done as d

RE: O9i Licensing

Well, if you're lucky enough to use the Enterprise Edition you'll be saving money. We use the Standard Edition, and at this time it looks like it's going to cost us quite a bit more, actually, for a per-processor license. So, we're currently in delicate negotiations with our Oracle rep and vario

  1   2   >