PHP and oracle help PLZ....
10 March 2006, 02:19 PM
#1
Scooby Newbie
Thread Starter
Join Date: Sep 2004
Posts: 10
Likes: 0
Received 0 Likes
on
0 Posts
PHP and oracle help PLZ....
Im looking to connect to oracle 9i and view background and user trace files
PHP and apache have been configured and do connect
Im getting this error :
What do I need to specify ?
Any suggestions would be great !
Warning: ocilogon() [function.ocilogon]: ORA-12533: TNS:illegal ADDRESS parameters in C:\oracle\ora92\Apache\Apache\htdocs\listFiles.php on line 22
PHP............................................... ...........
;<?php
session_start();
echo "<html><head><title>Trace File Manager</title></head><body>";
echo"<link rel=\"stylesheet\" href=\"../css/tfd.css\" type=\"text/css\">";
$mode = $_REQUEST['mode'];
if ( $mode == 'START')
{
$_SESSION['targetSID'] = $_REQUEST['targetSID'];
$_SESSION['targetSERVER'] = $_REQUEST['targetSERVER'];
$_SESSION['targetPORT'] = $_REQUEST['targetPORT'];
}
$db = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP )(HOST = " . $_SESSION[D2Y8732J] .
")(PORT=" . $_SESSION[1521] .
"))) (CONNECT_DATA=(SID = " . $_SESSION[its3] .
")))";
$db_conn = OCILogon($_SESSION['userName'], $_SESSION['userPWD'], $db);
$_SESSION['its3'] = $db;
if ( $mode == 'TKP')
{
$cmdstr = "begin pack_trace_file_manager.pc_generate_prf ("
. "'" . $_REQUEST['traceFileName'] . "',"
. "'" . $_REQUEST['sysRecursive'] . "',"
. "'" . $_REQUEST['expDefault'] . "',"
. "'" . $_REQUEST['Username'] . "',"
. "'" . $_REQUEST['Password'] . "',"
. "'" . $_SESSION['userName'] . "',"
. "'" . $_SESSION['userPWD'] . "',"
. "'" . $_REQUEST['sort'] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
}
if
( $_REQUEST['deleteRequest'] == 'TRUE')
{
if
( $_REQUEST['dest'] == 'BACKGROUND')
{
for ($i = 0; $i < sizeof($_SESSION['backgroundFiles2delete']); $i++ )
{
$cmdstr = "begin pack_trace_file_manager.pc_delete_files('" . $_REQUEST['dest'] . "','" . $_SESSION['backgroundFiles2delete'][$i] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
}
}
else
{
for ($i = 0; $i < sizeof($_SESSION['userTraceFiles2delete']); $i++ )
{
$cmdstr = "begin pack_trace_file_manager.pc_delete_files('" . $_REQUEST['dest'] . "','" . $_SESSION['userTraceFiles2delete'][$i] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
}
for ($i = 0; $i < sizeof($_SESSION['userPrfFiles2delete']); $i++ )
{
$cmdstr = "begin pack_trace_file_manager.pc_delete_files('" . $_REQUEST['dest'] . "','" . $_SESSION['userPrfFiles2delete'][$i] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
}
}
}
$cmdstr = "begin pack_trace_file_manager.pc_generate_file_list('" . $_REQUEST['dest'] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
if
( $_REQUEST['dest'] == 'USER')
{
echo "<form action=\"deleteFilesConfirmation.php\" method=\"post\">";
$cmdstr = "select trc_file_name,trc_file_tstamp,prf_file_name,prf_fi le_tstamp from vw_tfm_filelist";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);
echo "<center><table class='noBorders' width='80%'>\n<tr>\n";
echo "<tr>\n";
echo "<td class='noBorders'><h2>Available User Trace Files for > " . $_SESSION['targetSID'] . " < </h2></td><br>";
echo "<td class='noBorders'><h2><div style=\"text-align:right\"><a href=\"listTargets.php\">Back to the List of Target Databases</a></div></h2></td><br>";
echo "</tr></table>";
echo "<br><br>";
echo "<center><table width='80%'><center>\n<tr>\n";
echo "<td><b>Raw Trace File Name</b></td>\n<td><b>Raw Trace File Timestamp</b></td>\n<td><b>SRT</td>\n<td><b>TKP</td>\n<td><b>Formatted Trace File Name</b></td>\n<td><b>Formatted Trace File Timestamp</b></td>\n<td><b>SFT</td>\n<td align=center>Delete</td>\n</tr>\n";
$_SESSION['allDisplayedUserTraceFiles'] = $results["TRC_FILE_NAME"];
$_SESSION['allDisplayedUserPrfFiles'] = $results["PRF_FILE_NAME"];
for ($i = 0; $i < $nrows; $i++ )
{
echo "<tr>\n";
echo "<td>" . $results["TRC_FILE_NAME"][$i] . "</td>";
echo "<td>" . $results["TRC_FILE_TSTAMP"][$i] . "</td>";
echo "<td><a href=\"retrieveTraceFile.php?mode=TRACE&dest=USER& trcFileName=" . $results["TRC_FILE_NAME"][$i] .
"\"> SRT </a></td>";
echo "<td><a href=\"tkprofDialog.php?traceFileName=" . $results["TRC_FILE_NAME"][$i] .
"\"> TKP </a></td>";
if ( $results["PRF_FILE_NAME"][$i] == '')
{
echo "<td>.</td>";
echo "<td>.</td>";
echo "<td>.</td>";
}
else
{
echo "<td>" . $results["PRF_FILE_NAME"][$i] . "</td>";
echo "<td>" . $results["PRF_FILE_TSTAMP"][$i] . "</td>";
echo "<td><a href=\"retrieveTraceFile.php?mode=TRACE&dest=USER& trcFileName=" . $results["PRF_FILE_NAME"][$i] .
"\"> SFT </a></td>";
}
echo "<td align=center><input type=checkbox name=fileDelete" . $i . " value=YES></td>";
echo "</tr>\n";
}
echo "<input type=\"hidden\" name=\"dest\" value=\"USER\">";
echo "<tr><td colspan='6'> Number of Files : $nrows</td><td align=center>Delete All</td><td align=center><input type=checkbox name=deleteAll value=YES></td></tr>";
echo "<tr><td colspan='7'></td><td align=center> <input type=\"submit\" value=\"Delete\"> </td></tr>";
echo "</table>";
}
else
{
echo "<form action=\"deleteFilesConfirmation.php\" method=\"post\">";
$cmdstr = "select file_name trc_file_name,file_tstamp trc_file_tstamp from tfm_filelist";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);
echo "<center><table class='noBorders' width='80%'>\n<tr>\n";
echo "<tr>\n";
echo "<td class='noBorders'><h2>Available Background Trace Files for > " . $_SESSION['targetSID'] . " < </h2></td><br>";
echo "<td class='noBorders'><h2><div style=\"text-align:right\"><a href=\"listTargets.php\">Back to the List of Target Databases</a></div></h2></td><br>";
echo "</tr></table>";
echo "<br><br>";
echo "<center><table width='80%'><center>\n<tr>\n";
echo "<td><b>Trace File Name</b></td>\n<td><b>Trace File Timestamp</b></td>\n<td></td><td align=center>Delete</td>\n</tr>\n";
$_SESSION['allDisplayedBackgroundFiles'] = $results["TRC_FILE_NAME"];
for ($i = 0; $i < $nrows; $i++ )
{
echo "<tr>\n";
echo "<td>" . $results["TRC_FILE_NAME"][$i] . "</td>";
echo "<td>" . $results["TRC_FILE_TSTAMP"][$i] . "</td>";
echo "<td align=center><a href=\"retrieveTraceFile.php?mode=TRACE&dest=BACKG ROUND&trcFileName=" . $results["TRC_FILE_NAME"][$i] .
"\"> SRT </a></td>";
echo "<td align=center><input type=checkbox name=fileDelete" . $i . " value=YES></td>";
}
echo "<br><br>";
echo "<input type=\"hidden\" name=\"dest\" value=\"BACKGROUND\">";
echo "<tr><td colspan='2'> Number of Files : $nrows</td><td align=center>Delete All</td><td align=center><input type=checkbox name=deleteAll value=YES></td></tr>";
echo "<tr><td colspan='3'></td><td align=center> <input type=\"submit\" value=\"Delete\"> </td></tr>";
echo "</table>";
}
?>;
PHP and apache have been configured and do connect
Im getting this error :
What do I need to specify ?
Any suggestions would be great !
Warning: ocilogon() [function.ocilogon]: ORA-12533: TNS:illegal ADDRESS parameters in C:\oracle\ora92\Apache\Apache\htdocs\listFiles.php on line 22
PHP............................................... ...........
;<?php
session_start();
echo "<html><head><title>Trace File Manager</title></head><body>";
echo"<link rel=\"stylesheet\" href=\"../css/tfd.css\" type=\"text/css\">";
$mode = $_REQUEST['mode'];
if ( $mode == 'START')
{
$_SESSION['targetSID'] = $_REQUEST['targetSID'];
$_SESSION['targetSERVER'] = $_REQUEST['targetSERVER'];
$_SESSION['targetPORT'] = $_REQUEST['targetPORT'];
}
$db = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP )(HOST = " . $_SESSION[D2Y8732J] .
")(PORT=" . $_SESSION[1521] .
"))) (CONNECT_DATA=(SID = " . $_SESSION[its3] .
")))";
$db_conn = OCILogon($_SESSION['userName'], $_SESSION['userPWD'], $db);
$_SESSION['its3'] = $db;
if ( $mode == 'TKP')
{
$cmdstr = "begin pack_trace_file_manager.pc_generate_prf ("
. "'" . $_REQUEST['traceFileName'] . "',"
. "'" . $_REQUEST['sysRecursive'] . "',"
. "'" . $_REQUEST['expDefault'] . "',"
. "'" . $_REQUEST['Username'] . "',"
. "'" . $_REQUEST['Password'] . "',"
. "'" . $_SESSION['userName'] . "',"
. "'" . $_SESSION['userPWD'] . "',"
. "'" . $_REQUEST['sort'] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
}
if
( $_REQUEST['deleteRequest'] == 'TRUE')
{
if
( $_REQUEST['dest'] == 'BACKGROUND')
{
for ($i = 0; $i < sizeof($_SESSION['backgroundFiles2delete']); $i++ )
{
$cmdstr = "begin pack_trace_file_manager.pc_delete_files('" . $_REQUEST['dest'] . "','" . $_SESSION['backgroundFiles2delete'][$i] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
}
}
else
{
for ($i = 0; $i < sizeof($_SESSION['userTraceFiles2delete']); $i++ )
{
$cmdstr = "begin pack_trace_file_manager.pc_delete_files('" . $_REQUEST['dest'] . "','" . $_SESSION['userTraceFiles2delete'][$i] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
}
for ($i = 0; $i < sizeof($_SESSION['userPrfFiles2delete']); $i++ )
{
$cmdstr = "begin pack_trace_file_manager.pc_delete_files('" . $_REQUEST['dest'] . "','" . $_SESSION['userPrfFiles2delete'][$i] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
}
}
}
$cmdstr = "begin pack_trace_file_manager.pc_generate_file_list('" . $_REQUEST['dest'] . "'); end;";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
if
( $_REQUEST['dest'] == 'USER')
{
echo "<form action=\"deleteFilesConfirmation.php\" method=\"post\">";
$cmdstr = "select trc_file_name,trc_file_tstamp,prf_file_name,prf_fi le_tstamp from vw_tfm_filelist";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);
echo "<center><table class='noBorders' width='80%'>\n<tr>\n";
echo "<tr>\n";
echo "<td class='noBorders'><h2>Available User Trace Files for > " . $_SESSION['targetSID'] . " < </h2></td><br>";
echo "<td class='noBorders'><h2><div style=\"text-align:right\"><a href=\"listTargets.php\">Back to the List of Target Databases</a></div></h2></td><br>";
echo "</tr></table>";
echo "<br><br>";
echo "<center><table width='80%'><center>\n<tr>\n";
echo "<td><b>Raw Trace File Name</b></td>\n<td><b>Raw Trace File Timestamp</b></td>\n<td><b>SRT</td>\n<td><b>TKP</td>\n<td><b>Formatted Trace File Name</b></td>\n<td><b>Formatted Trace File Timestamp</b></td>\n<td><b>SFT</td>\n<td align=center>Delete</td>\n</tr>\n";
$_SESSION['allDisplayedUserTraceFiles'] = $results["TRC_FILE_NAME"];
$_SESSION['allDisplayedUserPrfFiles'] = $results["PRF_FILE_NAME"];
for ($i = 0; $i < $nrows; $i++ )
{
echo "<tr>\n";
echo "<td>" . $results["TRC_FILE_NAME"][$i] . "</td>";
echo "<td>" . $results["TRC_FILE_TSTAMP"][$i] . "</td>";
echo "<td><a href=\"retrieveTraceFile.php?mode=TRACE&dest=USER& trcFileName=" . $results["TRC_FILE_NAME"][$i] .
"\"> SRT </a></td>";
echo "<td><a href=\"tkprofDialog.php?traceFileName=" . $results["TRC_FILE_NAME"][$i] .
"\"> TKP </a></td>";
if ( $results["PRF_FILE_NAME"][$i] == '')
{
echo "<td>.</td>";
echo "<td>.</td>";
echo "<td>.</td>";
}
else
{
echo "<td>" . $results["PRF_FILE_NAME"][$i] . "</td>";
echo "<td>" . $results["PRF_FILE_TSTAMP"][$i] . "</td>";
echo "<td><a href=\"retrieveTraceFile.php?mode=TRACE&dest=USER& trcFileName=" . $results["PRF_FILE_NAME"][$i] .
"\"> SFT </a></td>";
}
echo "<td align=center><input type=checkbox name=fileDelete" . $i . " value=YES></td>";
echo "</tr>\n";
}
echo "<input type=\"hidden\" name=\"dest\" value=\"USER\">";
echo "<tr><td colspan='6'> Number of Files : $nrows</td><td align=center>Delete All</td><td align=center><input type=checkbox name=deleteAll value=YES></td></tr>";
echo "<tr><td colspan='7'></td><td align=center> <input type=\"submit\" value=\"Delete\"> </td></tr>";
echo "</table>";
}
else
{
echo "<form action=\"deleteFilesConfirmation.php\" method=\"post\">";
$cmdstr = "select file_name trc_file_name,file_tstamp trc_file_tstamp from tfm_filelist";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);
echo "<center><table class='noBorders' width='80%'>\n<tr>\n";
echo "<tr>\n";
echo "<td class='noBorders'><h2>Available Background Trace Files for > " . $_SESSION['targetSID'] . " < </h2></td><br>";
echo "<td class='noBorders'><h2><div style=\"text-align:right\"><a href=\"listTargets.php\">Back to the List of Target Databases</a></div></h2></td><br>";
echo "</tr></table>";
echo "<br><br>";
echo "<center><table width='80%'><center>\n<tr>\n";
echo "<td><b>Trace File Name</b></td>\n<td><b>Trace File Timestamp</b></td>\n<td></td><td align=center>Delete</td>\n</tr>\n";
$_SESSION['allDisplayedBackgroundFiles'] = $results["TRC_FILE_NAME"];
for ($i = 0; $i < $nrows; $i++ )
{
echo "<tr>\n";
echo "<td>" . $results["TRC_FILE_NAME"][$i] . "</td>";
echo "<td>" . $results["TRC_FILE_TSTAMP"][$i] . "</td>";
echo "<td align=center><a href=\"retrieveTraceFile.php?mode=TRACE&dest=BACKG ROUND&trcFileName=" . $results["TRC_FILE_NAME"][$i] .
"\"> SRT </a></td>";
echo "<td align=center><input type=checkbox name=fileDelete" . $i . " value=YES></td>";
}
echo "<br><br>";
echo "<input type=\"hidden\" name=\"dest\" value=\"BACKGROUND\">";
echo "<tr><td colspan='2'> Number of Files : $nrows</td><td align=center>Delete All</td><td align=center><input type=checkbox name=deleteAll value=YES></td></tr>";
echo "<tr><td colspan='3'></td><td align=center> <input type=\"submit\" value=\"Delete\"> </td></tr>";
echo "</table>";
}
?>;
