RE: Could not run export utility from cron job
Ken: When running from cron the user's .profile does not get executed. So your ORACLE_BASE, ORACLE_HOME etc does not get created in your os environment. So on the line that you want to execute the export. Before the exp command add . ~/.profile (without the double quotes) exp user/password tables.dmp. This will execute the .profile first, set your environments and then do the export. Ron *** Ron Cetnar Supervising Programmer/Analyst/Oracle DBA ITS - University Applications Development State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 *** -Original Message- Sent: Wednesday, December 10, 2003 12:39 PM To: Multiple recipients of list ORACLE-L -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nguyen, David M Sent: Wednesday, December 10, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Subject: Could not run export utility from cron job I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. $exp user/password tables.dmp Thanks, David I'm pretty sure that jobs running out of cron do not source in .profile so you probably don't have the Oracle environment set and therefor exp is not in your PATH. Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Simpson, Ken 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: Ron Cetnar 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).
Oracle db using IBM FAStT disk storage questions
Is anyone using Oracle database with IBM disk storage FAStT? I was wondering if you had any performance problems, pitfalls and any- other stories that you might want to inform me about? Before we commit ourselves in purchasing this SAN your info would be appreciated. We are a PeopleSoft shop running their Higher Education products 8. Running on RS6000 H-80 with AIX 4.3.3, soon going to 5.2. Oracle version 9.0.2.3. You can email me (address below) directly or to the list. Thanks Ron *** Ron Cetnar Supervising Programmer/Analyst/Oracle DBA ITS - University Applications Development State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 ***
set oracle-l nomail
Title: Message SET ORACLE-L NOMAIL
RE: client/desktop management from network / was: Re: Net 8 insta
Eric: Thanks for your reply. We use Dell desktops here and have a state contract with Dell. I'll have our Lan people check with Dell. Have a good one. Ron -Original Message- Sent: Wednesday, March 27, 2002 3:23 PM To: Multiple recipients of list ORACLE-L installation on a server consider an alternative (maybe for future): use the network to standardize desktop settings, but not to store/run the executable. there is software that will vacuum custom client/desktop settings from the network side, and allow you to deploy those settings (elsewhere). sort of like Ghost on steroids. (this is being studied here to rapidly re/deploy OS images and standard loads in university computer labs.) eg, here is a product that our Dell rep brought in for a demo: http://www.altiris.com/ (I think at an educational discount, they were talkin' something like $60,000 for 2,000 nodes?) note: Dell, IBM (and probably Compaq/etc.) have similar capabilities, in the case of IBM, it is (suppposedly) bundled with all Netvista desktops, but watch out, in many instances the hardware-vendor desktop management stuff only does limited OS/BIOS type stuff, not applications. (eg, http://www.pc.ibm.com/us/pc/um/index.html ) due to the design/setup overhead involved, it is probably not worth setting up such stuff *just* for the Oracle client, but maybe you can get your LAN people to look into it long term for general use, and then use it for Oracle client stuff also? you would probably want to have WoL capable boxes. regards, ep ORACLE-L Digest -- Volume 2002, Number 086 -- From: Rodd Holman [EMAIL PROTECTED] Date: 26 Mar 2002 13:18:12 -0600 Subject: Re: Net 8 installation on a server rather than client question I did this for a while with the 7.3 client. Performance was abysmal. My network admin also was on my case about network traffic. I don't know if the Net8 client would be better or not. Pointing TNS_ADMIN to a network drive is great, but unless there have been significant changes in the client, I would be more inclined to have it local. What I did for the network install was to set up a machine installing the client to a network drive. Exported the registry key for Oracle. Copied the Windows system files to a network location. Added that location to the PATH variable. It was cumbersome, but it worked. On the other machines I imported the registry file, added the PATH variable, and TNS_ADMIN variable. The problem with all this is when you upgrade the client, you have to upgrad all the user registries with the new keys and structure changes that Oracle makes. You may as well install each machine. ... On Tue, 2002-03-26 at 09:18, Ron Cetnar wrote: Question to the list. Is there was way to install Net 8 on a nt server and have client pc's execute the Net 8 from the server instead of loading Net 8 on the client's pc. To avoid installation of Net 8 on the clients. I already have the tnsnames.ora file on the server and with a bat file that updates the registry on the client to point to the server to get the tnsnames file. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Ron Cetnar 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).
Net 8 installation on a server rather than client question
Title: Net 8 installation on a server rather than client question Question to the list. Is there was way to install Net 8 on a nt server and have client pc's execute the Net 8 from the server instead of loading Net 8 on the client's pc. To avoid installation of Net 8 on the clients. I already have the tnsnames.ora file on the server and with a bat file that updates the registry on the client to point to the server to get the tnsnames file. Currently using Net 8 ver 8.1.6 Thanks Ron *** Ron Cetnar Supervising Programmer/Analyst/DBA State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 ***
Oracle shareware web site.
I'm looking for the web site that has a export utility called something like TAB/EXT. Does anyone know the URL for this site? TIA, Ron *** Ron Cetnar Supervising Programmer/Analyst/DBA State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Cetnar 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).
