Recent content by derekludwig

I would like to set up a solaris-8 system with a QFE as router for my two internal network with some basic failover capabilities. My current setup is: wan-A <====[rtr]====> lan-0 wan-B <====[rtr]====> lan-1 What I want is: ____ wan-A <====| |====> lan-0...

Have a co-worker trying to run sqlplus from windows-2000 in order to connect to a database on a Solaris system. The tnsnames.ora contains: FRED = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = name)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = fredb...

We have a W2K advance server (our domain controller) running exchange 2000 that has become unusable to do the misconfiguration of the disks, installation of unapproved software, and general neglect. What we like to do is install (not upgrade) W2K3 w/ exchange 2003 (aka &quot;small business...

Thanks for the suggestion, I had already posted it to the Oracle forum as well. And got pretty much the same answer: too many connections. And thank you for the suggestion of closing the dataset when done ... this in an application I am inheriting, and I am deciding what sort of sauce to use...

Thanks for the information. You would think an error like ORA-314159: too many TNS connections could have been used here. Ah well. ---------------- Derek Ludwig derek<at>ludwig.com

I recently inherited responsibility of a PHP/Oracle application, and recently the following warning message popped up: Warning: ocilogon(): _oci_open_server: ORA-12540: TNS:internal limit restriction exceeded in <FILE> on line 3 and from the <FILE>: $P = ocilogin($user,$pswd) Any ideas...

I've recently inherited a database that has been w/o an active dba in a while, so I am playing catch up with the various issues. I am currently working on: Warning: ocilogon(): _oci_open_server: ORA-12540: TNS:internal limit restriction exceeded in /data/htdocs/www.starchefs.com/poll/poll.php...

Thanks everyone. Found the REALLY tiny labels, and successfully replace the SIMMS, everything is now better. Did I mention that the labels were REALLY tiny? Thanks again. ---------------- Derek Ludwig derek<at>ludwig.com

I am very surprised you cannot create a crontab if you are allow to run at, at the two are sides of the same coin (please feel free to use a better similie). And to add to the naggiman's list: at -c jobId lists jobId's script, which might help diagnose your problem of not running the script...

D'OH (-: (brain was not functioning at 1am) ---------------- Derek Ludwig derek<at>ludwig.com

Pardon? I am surprised that you have permission to run at, but not cron, as they usually come as a set. Have you tried crontab -e? Of course you have .... go beat on your S/A. Good luck. ---------------- Derek Ludwig derek<at>ludwig.com

While +([0-9]) does match integers, is 0000003 an integer? (It may or may not be, depending on the situation). Now something like: @(?([-+])[1-9]*([0-9])|0) might be more applicable, integers with no leading zeros with an optional sign, or a plain 0. This would accept +23...

If the records are sorted [sort -o file file], then I suggest uniq: uniq -d file will give you a single instance of every duplicated (and triplicated, quadruplicated, etc) record. If you need to know how many times a record was duplicated: uniq -dc file Some uniq's support the -D...

Might i suggest using cron, with the following crontab entry: 0 1,13 * * * ${DIR}/leads.ksh this would ensure that leads is invoked at 1am and 1pm. ---------

I realize that this may be a bit off topic, but is there a reason for not using cron to run the script at the same time every day? Or are you worried that the original script would take more than 24 hours to run? Derek