Disable SQL*Plus Connected to/ Disconnected message... 1

[goyalpdm]

Hi,

I am executing lot of SQL scripts one after the other and each of them makes connection to database using SQL*Plus (and then disconnects).

Output of these SQL scripts gets written to log file and obviously contains lot of connection/ disconnect messages. Is there a way to hide these messages?

Cheers,
Sachin
---------------------
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 6 13:29:53 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
JServer Release 9.2.0.4.0 - Production

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
JServer Release 9.2.0.4.0 - Production

 

[SantaMufasa]

Goyalpdm,

I'm not trying to evade your question, but I have a few questions to try to help resolve your need:

1) Are each of your scripts connecting to different Oracle users? (i.e., what is the benefit/reason that each script is reconnecting/disconnecting?)

2) By what method/command are your scripts outputting to your log file(s)? Are you open to alternate methods of logging?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 05:26 (06Jan05) UTC (aka "GMT" and "Zulu"),
@ 22:26 (05Jan05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.

 

[goyalpdm]

Hi Mufasa,

1. These are standard scripts in the product and must work individually as well. So, I can't really remove "exit" from the end of these scripts...

2. Way it works is, I have a CSH script that executes these SQL scripts one by one...

What do you suuggest?

Cheers,
Sachin

 

[SantaMufasa]

Sachin,

Given:

1) You must leave the scripts alone.
2) You don't want the "Connected..."/"Disconnected..." messages in your logs.
3) Oracle doesn't offer a method to turn the above message off.

Resolution:
1) Post-process the log files, getting rid of the unwanted messages.

Sorry I haven't better news.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 06:32 (06Jan05) UTC (aka "GMT" and "Zulu"),
@ 23:32 (05Jan05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.

 

[sem]

How about calling sql*plus with -s key?

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

See, Sachin, just when I think all is lost, Dima comes along and saves the day. Good job, Dima. Have a star !

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 08:01 (06Jan05) UTC (aka "GMT" and "Zulu"),
@ 01:01 (06Jan05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.

 

[goyalpdm]

Thanks Guys. It works great!

Cheers,
Sachin