Search results for query: *

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.

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...

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...

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!

Hi all, Is there a way to output the result of a query directly to a text file without using the export wizard or a dts packtage. I need something that can do that in plain sql in a sp. Is this possible? Thanks for any help!

Hello ALL! Whenever I try to view the Properties of a Workflow step on some DTS packages, EM crashes. I found this error on Event Viewer: App: E 'Tue Jan 07 15:21:54 2003': SQLSERVERAGENT - " Unable to read local eventlog (reason: The data area passed to a system call is too small). &quot...

I have several jobs running in a SQL Server 2000 Server, Enterprise edition. For last couple or days, every new job that I create, when I run it or when SQLAgent runs it, it gives me this error: "Executed as user: xxxx\yyyy. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE...

when I execute something like: EXEC master.dbo.xp_sendmail @recipients = 'xyz@abc.com', @subject = 'Daily report', @message = 'New Customers through midnight yesterday' it just runs and runs and runs...untill I have to cancel it. I tried using xp_stopmail and xp_startmail and...

Is there a way to run a SELECT query on a table ona remote server with something a NOLOCK? I need something to make sure the query doesn't lock the table.

Whenever I run a query similar to this one trying to update a table in another server: update serverxyx.dbxyz.dbo.tablexyz set field2xyz=1 where field2xyz=abc I get this error: Server: Msg 7346, Level 16, State 2, Line 1 Could not get the data of the row from the OLE DB provider 'SQLOLEDB'...

We are getting this error while restoring one of our production databases. We get this error only on one of our databases in one server. Any ideas on this error???. Plz let me know if there is any KB articles refers to this particular problem in SQL Server 2000 (SP2). The DBCC runs for a long...

Is it possible to construct a sql statement using multiple ODBC connections? Let's say, in C++, how could this be accomplish?

Does anyone know why a sp would disappear after loging out & in of the Enterprise Manager in SQL Server 2000? When I execute the sp from the Query Analizer it seems to loop but it is still there after I cancel it. If I run just the code in the Query Anaylizer, it runs fine. Due that it involves...

I wrote a sp that executes another sp in it. When I test the "main" sp, the result that I get is "A domain error ocurred". I tested the "inner" sp seperately and it works fine (sending fixed valued or variables). If within the "main" sp I call the...

I wrote a sp that executes another sp in it. When I test the "main" sp, the result that I get is "A domain error ocurred". I tested the "inner" sp seperately and it works fine (sending fixed valued or variables). If within the "main" sp I call the...

I wrote a sp in that executes another sp in it (in SQL 2000) . When I test the "main" sp, the result that I get is "A domain error ocurred". I tested the "inner" sp seperately and it works fine (sending fixed valued or variables). If within the "main" sp I...