Oracle

after entering all the info (Host/Port/DB SID/ Usr/ PWd) , i am entering query in query field. Then when i click on "Show Columns" button, i see : Parameters of connection are invalid. Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I'm trying to execute a DB Tool test. I get the following error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Scenario: * Set-Up Tests * Tear-Down Tests * Test 1: authorize * Test 2: DB Tool * Test 3: redeem My SQL: SELECT UPDATE_APP_NAME FROM CREDITACCOUNT.CREDIT_PROVIDER_REBATE WHERE…