Re: dbsnmp/intelligent agent for linux
On Tue, 4 Jun 2002, Peter Gram wrote: > Hi Gabriel The agent configuration is very version dependent so please > inform the version of Oracle you are trying to use. Here is how to start > the Agent with 9.2, 9i and properly 8.1.7 > i am sorry ... i somehow removed that paragraph while editing the text ... i am using 'Oracle9i Enterprise Edition Release 9.0.1.0.0' i tried that and was told dbsnmp (for unix blanketly) was the command of choice. here is its output ... $ ./agentctl start DBSNMP for Linux: Version 9.0.1.0.0 - Production on 04-JUN-2002 03:07:21 Copyright (c) 2001 Oracle Corporation. All rights reserved. NMS-00010: Parsing parameter file failed. nmiclbg_ensureAlive:: Initialize error for nmigenctx ... is there a file i need to tweak for this? --- Gabriel C. Millerd | To choose one's victim, to prepare one's plan Script Monkey | minutely, to slake an implacable vengeance, and | then go to bed... There is nothing sweeter in the | world. --Josef Stalin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd 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).
dbsnmp/intelligent agent for linux
i have read and read about this beast but most of the documentation is very confusing (more reference than howto) and the 'tips' seems to be folkloreish or guesses. i gather there are some things that need to be done to these files: $ORACLE_HOME/network/admin/snmp_rw.ora $ORACLE_HOME/network/admin/listener.ora and that the 'lsnrctl' should have the dbsnmp_(start|stop) options. mine doesnt but i assume that is because it isnt configured properly or i mooked something else up. any help you can give me would be great ... thanks --- Gabriel C. Millerd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd 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).
Re: dblink mysql to oracle
On Mon, 3 Jun 2002, Igor Neyman wrote: > Read on Oracle's Heterogeneous Services, allows to connect (through db-link) > to foreign databases using ODBC. > this seems more like the way to go .. i didnt expect to have to program anything rather configure oracle, a mysql driver, and transport mechanism. --- Gabriel C. Millerd | The ability to destory a planet is insignificant Script Monkey | next to the power of the force... I find your lack | of faith disturbing. -Lord Vader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd 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).
RE: dblink mysql to oracle
On Mon, 3 Jun 2002, Gogala, Mladen wrote: > I dunno about MySQL, but from oracle you can have external procedures > accessing MySQL and returning data into oracle. There is also a TNS API > which allows you to write your very own transparent gateway and select > data from MySQL. > is this the 'enabling net8 enhancements for programmers' stuff such as the tftp and finger examples? such as mentioned here: http://technet.oracle.com/doc/oracle8i_816/network.816/a76933/net8open.htm or am i missing something? --- Gabriel C. Millerd | Go not to the elves for counsel, for they will say Sith Admin | both yes and no. -- J.R.R. Tolkien | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd 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).
dblink mysql to oracle
i want to be able to select mysql data from oracle simular (in some way) to how i do via dblinks 'select * from table@otherdb' is there a way to do something like this? --- Gabriel C. Millerd | Eternal nothingness is fine if you happen to be Super Plumber | dressed for it. -- Woody Allen | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd 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).
Re: sysdate - 90 mins query
On Sat, 4 May 2002, Stephane Faroult wrote: > where tm_date >= to_number(to_char(sysdate - 0.0625, 'MMDD')) > and to_date(to_char(tm_date)||tm_time, 'MMDDHH24:MI') >= sysdate - > 0.0625 > has anyone written a dbms_ package for this? i am surprised something isnt included with oracle to cover these time issues. i find myself needed to convert to ctime() or gmtime() so often ... i am so embarrassed to have to whip out the three line sql statement to do it. --- Gabriel Millerd | "Be liberal in what you accept, and conservative Script Monkey | in what you send." | -- Jon Postel, Internet Pioneer RFC1122 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd 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).
dmoz/odp imports
does anyone have any scripts for importing dmoz/odp datafiles? anything i have tried to develop breaks on whats seems to be the deviation from the rdf they use. i have tried working with tje senga catalog's convert_dmoz ... but its pretty fast and loose with the results since its importing into mysql (so constraints matter little to it) thanks --- Gabriel Millerd | Every program attempts to expand until it can read mail. Plumber | Those programs which cannot so expand are replaced by | ones which can. -Law of Software Envelopment, -jwz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd 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).
Oracle9i on Debian
I am running a current Debian v2.3 on kernel v2.4.18 on a Compaq6400r. I cannot for the life of me get Oracle9i to install. This is a minimal install - just waiting for oracle I just must be missing something. I have it nearly automated and have tried many different solutions - v2.2 and v2.3 with different kernels mostly. I would like to run v2.3 and the newest stable kernel - but whatever is best. The documentation for the kernel changes from oracle are a little vauge to me. I am not big into altering the kernel - especially when the documentation isnt exacting. And since oracle doesnt have the filenames right and the define statments are in other files i am very leary. The users and space are fine. The space can be optimized once i get over thus hump of actually getting this to install. I have installed 815 and 817 before this is quite a different problem. This is the dreaded stumbling block. === cut here === ./Oracle9i/Disk1/runInstaller oracle@c6400:/usr/src/ORACLE$ Initializing Java Virtual Machine from /tmp/OraInstall/jre/bin/jre. Please wait... SIGSEGV 11* segmentation violation stackbase=0xb3ec, stackpointer=0xb2b4 Full thread dump: "Finalizer thread" (TID:0x42751210, sys_thread_t:0x4d0a3e0c, state:R) prio=1 "Async Garbage Collector" (TID:0x42751258, sys_thread_t:0x4d082e0c, state:R) prio=1 "Idle thread" (TID:0x427512a0, sys_thread_t:0x4d061e0c, state:R) prio=0 "Clock" (TID:0x42751088, sys_thread_t:0x4d040e0c, state:CW) prio=12 "main" (TID:0x427510b0, sys_thread_t:0x80d6f98, state:R) prio=5 *current thread* java.lang.System.initializeSystemClass(System.java) Monitor Cache Dump: Registered Monitor Dump: Thread queue lock: Name and type hash table lock: String intern lock: JNI pinning lock: JNI global reference lock: BinClass lock: Class loading lock: Java stack lock: Code rewrite lock: Heap lock: Has finalization queue lock: Finalize me queue lock: Dynamic loading lock: Monitor IO lock: Child death monitor: Event monitor: I/O monitor: Alarm monitor: Waiting to be notified: "Clock" (0x4d040e0c) Monitor registry: owner "main" (0x80d6f98, 1 entry) Thread Alarm Q: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd 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).
