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

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

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

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 | Ive got a PBS mind in an MTV

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/datafiles

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

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

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

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

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 are

Re: UNIX

Nope, you don't need an entry in the /etc/vfstab. You can just do a mount options block_device mount_point and 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

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

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:

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

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:

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

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

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

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

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: 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 logfile

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,

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

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.

<    1   2