Monday, September 14, 2009

Blackboard - Testing SQL Connection from application node to database

sqlplus “sys/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=databasehostname)(PORT=1521))(CONNECT_DATA=(SID=$ORACLE_SID))) AS SYSDBA”

sqlplus “system/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=databasehostname)(PORT=1521))(CONNECT_DATA=(SID=$ORACLE_SID))) AS SYSOPER”

No comments:

Post a Comment