This discussion is archived
2 Replies Latest reply: Nov 22, 2011 12:21 AM by Paul M. RSS

Error when running a bat file

894206 Newbie
Currently Being Moderated
Can someone tell me what this error means; "ORA-12560: TNS:protocol adapter error"

I had Oracle XE on my Windows XP Pro SP3, but I also install the EE of Oracle which I haven't setup yet. Originally when I run this .bat file by double clicking on it, "setup_distran_database.bat", everything worked fine. But now, I am getting tghe above error. Not sure if it was because I installed Oracle EE.
This is the .bat file:
*@ECHO off*
*:: Ayo Ojikutu*
*:: Using Murach's Oracle SQL and PL/SQL*
*:: and Mike Murach & Associates, Inc. example*
*:: Nov 11, 2011*
*::*
*:: Uses SQL*Plus utility to run the SQL scripts that create*
*:: and populate the tables in the AP, OM, and EX schemas.*
*:: If necessary, edit the username/password*
sqlplus system/passwordhere @setup_distran_database*
*:: Display a message about the log file*
ECHO.
ECHO For details, check the setup_distran_database.log file in the current directory.
ECHO.

*:: Display 'press any key to continue' message*
PAUSE

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points