Recent content by olemma

Anyone???? I add more info: In case of switchover or failover, we definitely want it to be as transperent as possible to the apps. Most of our apps are using jdbc connections, a few the OCI api. I guess the best solution will be the the first: connect time failover in the tnsnames.ora...

Hello Gurus, Can someone please explain to me if anything needs to be done on the app servers (client side) connecting to the DB when a swithover/failover takes place? what needs to be configured? I still quite don't get that part from what i've read.

Thanks hoinz. Yes, that's what I meant by my question.

Hi Oracle Gurus, My net admin needs to change the IP address on our production Oracle 9i DB running on RedHat Enterprise Linux 2.1/Kernel 2.4.9-e.59 enterprise. What would be the appropiate steps to acomplish this?

Hello Gurus, I need a complete security survey for an Oracle 9i DB running on a RedHat Enterprise Linux 2.1/Kernel 2.4.9-e.59 enterprise server. I am looking for recommendations on securing this server as much as possible. Anyone know where I can find useful documention regarding security? Any...

Has anyone upgraded from 9.2 to 10g? Does anyone have a documented process? Is it straight-forward? Do you recommend it? Any comment would be helpful. Tnx, olemma

Hi, I have set up a OMS in win2000 that will monitor 3 oracle dbs in 3 diffrent linux boxes. When I try to start the Oracle Intelligent Agent in the linux servers, the OMS still cannot discover the oracle instances. In the \network\log directory I found a few logs that seem to point to an...

isn't that only for BLOBs/CLOBs?

Whenever I try to insert a long string into a LONG field (in sqlplus or OEM), I am getting this error: ORA-01704: string literal too long The string is problaby > 2000 char (I don't have the same problem if I truncate the text). I even tried other field types,like LONG RAW or BLOB, but I get...

Hi All, Is there a setting so that I can leave Enterprise Manager and SQLPlus worksheet open and have them stay active for longer than half an hour, even without using them? I've had to launch SQLPlus Worksheet 5 times today and over 10 yesterday, and it's getting annoying and slowing me down...

cricketer1, I just did this twice during the last month. Just rename the server name (change ip, any dns entry, etc. if necessary), and reboot your server. The sql server service should come back up with the new server name. BTW, you will need to run change the server name in msdb.sysjobs so...

Ty! much better!

Thanks. I wrote this funtion that seems to work, but now how do i call it from select statement? I want return a duration field which is in seconds in minutes. CREATE function f_sec2min (@p_seconds as numeric) returns char(20) as begin declare @min char(20) set @min=case len(cast(...

Is there any sql funtions that converts seconds to minutes? I need someting like 245 seconds = 04:05 minutes. I can probably write a funtion to do this but I was wondering if some existed already. Thanks!

Thank you so so so much!!! I probably skipped that thread before. Just what I needed.