Jump to content
Sign in to follow this  
Galene

VBScript Connection oracle in sys

Recommended Posts

hello

I need to connect in sysdba on Oracle from Vbs. For retrieve the state of the database (Open mount ...) because the user system can not connect when the database is on mount.

I use this command to connect on my database when she is open

Set env = WshShell.Environment("PROCESS" ) computername = env("COMPUTERNAME" )  set cn = CreateObject("ADODB.Connection")set rs = CreateObject("ADODB.Recordset")								ConnectionString ="Provider=OraOLEDB.Oracle; Data Source=" & _"(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST="&computername&")(PORT=1521)))(CONNECT_DATA=(SID="&SERVICE &")(SERVER=DEDICATED)));" & _"User Id=system;Password="&PASSWORD &";"cn.Open connectionString

can you help me please ?

 

thanks

 

Galene

Edited by Galene

Share this post


Link to post
Share on other sites

What happens if the database is mounted? Do you get an error when connecting?

Share this post


Link to post
Share on other sites

When my database is mount and I run my script I have a connection error err.number 3704, because you can log in sysdba when in state mount.

Share this post


Link to post
Share on other sites

VBScript doesn't have very good error handling, it looks like the best you can do is tell it to continue on fatal errors, but then you need to check yourself to see if an error happened. That might be your only option. I doubt you will be able to tell the status of the database without connecting to the server, and if you get an error on connection then you'll need to handle that yourself.http://stackoverflow.com/questions/157747/vbscript-using-error-handling

Share this post


Link to post
Share on other sites

in fact I created a nagios probe for check the status of my databse that's why I need to connect in sysdba with my script but nothing works...

Share this post


Link to post
Share on other sites

yes we can check the state before connecting, I have a probe that allows Linux to do, you just connect with the privilege " as sysdba" and I have to do the same but in vbscript.

Share this post


Link to post
Share on other sites

it's work! with this method

Set cmd = sh.Exec("cmd /c "& ORACLE_HOME & "BINsqlplus.exe -s /@"&SERVICE &" as sysdba @Z:PartageSondeessaitest_recordsetrequetesql.sql")
@Z:PartageSondeessaitest_recordsetrequetesql.sql

it's a file where we go to execute queries

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×