Galene

Members
  • Content count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Galene

  • Rank
    Newbie

Profile Information

  • Gender
  1. 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
  2. I have watched this site and tried different connectionstringBut unable to connect with sysdba privilege
  3. 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.
  4. two weeks of research and no solution I need help please
  5. 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...
  6. 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.
  7. 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