RE: strtSID.cmd security hole??

Where is the strtSID.cmd file? I don;t see it anywhere under $ORACLE_HOME. -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Subject: strtSID.cmd security hole?? I inherited

Listener freezes up

AIX: 4.3.2.0 RDBMS 8.1.6.3 We have two instances on two different servers. There is replication from serverA to serverB. Periodically SID_A starts filling its alertlog with ORA-00020 Max sessions errors. It is reporting a failure of the replication into SID_B. It is SID_B that has the max

RE: Nothing to do with Oracle : But is is very important : Yo

I agree that the link is off topic. I also like the link and intend to send it to many of my American friends. I'd like to see less off-topic discussion here. Funny though - most list members seem to enjoy off-topic discussion - except for this one. ..tom -Original Message- From:

join across database link

A query that has run for a long time has suddenly started hanging. The query joins 3 tables - 2 of them across a link. The query runs on an RDBMS 8.0.5 NT. The tables across the link are on AIX RDBMS 7.3.2.3. All indexes are VALID. When I connect to the NT and run the query by hand it also

RE: multiple archive destinations

I read the tips. They are helpful. Thank you. ..tom -Original Message- From: Steve Adams [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 8:36 AM To: [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L Subject: RE: multiple archive destinations Hi Tom, You

multiple archive destinations

RDBMS: 8.1.6.2 OS: AIX 4.3.3 Our large (600G) insert-intensive (17Meg / min) database has 24 on-line redo logs (8 each on 3 disks used in round-robin fashion) and occasionally has problems with the archiver being unable to keep up with the data fill rate. When this happens on-line redo logs

RE: Listener.log

Don't worry. Everything will be all right. The listener.log is still cached in memory. The next time you bounce (cleanly) Oracle it will start a new one listener.log. ..tom -Original Message- From: Nguyen Thanh-truc [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 11:47 AM

RE: Awfully annoying SQLLDR problem

It is not my purpose here to discuss issues not related to Oracle. The 7.3.2.3 database is inside a firewall - not so the 8.1.5 database. Our corporate standard for server file exchange is MQSeries though I could probably get an exemption to use rsh. In my TAR I wrote :One Oracle workaround

Awfully annoying SQLLDR problem

I am executing a SQLLDR shell file from a server :: sourceserv; RDBMS 7.3.2.3 AIX 4.3.2 into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3 using a SQL*Net connect string destserv_destSID. This connect string is defined in the local tnsnames.ora and works. I confirmed this by doing

RE: Awfully annoying SQLLDR problem

No you are reading correctly. I have the data on a server with a 7.3.2.3 database and am using that databases' binary sqlldr to load into the 8.1.5 database. The problem is a timing issue. I need to execute the load from the 7.3.2.3 server as part of a larger script. I cannot ensure that the

db link hangs

AIX 4.3 RDBMS 8.1.6.x We have a problem using a db link. The listener-side server port (1521) is hanging. This happens about once a week - and ends up crashing the far database because queries through the link just hang and don't return - then we die with a max processes error. Has anyone

Weird link problem

AIX 4.3 RDBMS 8.1.6.2 When I select through a database link I have having a strange problem. If I select a field or fields it works. If I select a count it hangs. Any ideas? select count(*) from tab1.table; **hangs** select name, address from tab1.table; **works fine** Help!!! ..tom

RE: Weird link problem

Good question. I just tried it and it retuns 782 instantly - which is correct. So what is the problem with the star (*) ??? ..tom -Original Message- From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 10:40 AM To: Multiple recipients of list ORACLE-L

Set transaction does not work

RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created

RE: 8.1.6.0 install problem - SOLVED! (maybe) - Follow-on

Follow-on question :: The libm module is used during the make command. Our security wonk wants to know if we only need this during install so he can delete it from the run-time system. My guess is yes we only need it for install - e.g. this is not dynamically linked at startup of either the

8.1.6.0 install problem

I'm trying to install Oracle Enterprise server 8.1.6.0 onto our AIX 4.3.3 64-bit IBM server. I'm getting a problem during the link phase. I make sure we have 2x the swap space as main memory. The Oracle techrep told me to run $ORACLE_HOME/bin/genclntsh64. I did this but still get the same

RE: 8.1.6.0 install problem - SOLVED! (maybe)

Thanks for the help everyone. The Oracle techrep solved the problem. He asked me to do lslpp -l all |grep libm after this he saw that we did not have the math library installed. thanks all, ..tom -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday,