You can check it even from the db host(via OracleNet)
sqlplus '/@<service_name> as sysdba'
Dimitre
-- -- Original Message -- -- From: Niall Litchfield To: BERNHARD Nora Cc: Bryan Thomas ; oracle-l@(protected) Sent: Thursday, July 14, 2005 3:14 PM Subject: Re: TAF
On 7/14/05, BERNHARD Nora <nora.bernhard@(protected)> wrote: Hi Bryan,
> 1) Are you connecting using the "virtual" instance or are you > connecting directly to the instance on the node or using "/ > as sysdba"? Run the query the previous poster sent and check > you connection parameters.
I tried with 'sqlplus / as sysdba' and 'sqlplus sys as sysdba' + pw.
you are not using net8 at all then. try it from a 'remote' connection.
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2900.2668" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>You can check it even from the db host(via OracleNet)</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV>sqlplus <A href="mailto:'/@<service_name">'/@<service_name</A>> as sysdba' </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT><BR>Dimitre </DIV> <DIV> </DIV> <DIV> </DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A title=niall.litchfield@(protected) href="mailto:niall.litchfield@(protected)">Niall Litchfield</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A title=nora.bernhard@(protected) href="mailto:nora.bernhard@(protected)">BERNHARD Nora</A> </DIV> <DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=bthomas@(protected) href="mailto:bthomas@(protected)">Bryan Thomas</A> ; <A title=oracle-l@(protected) href="mailto:oracle-l@(protected)">oracle-l@(protected)</A> </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, July 14, 2005 3:14 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> Re: TAF</DIV> <DIV><BR></DIV> <DIV><SPAN class=gmail_quote>On 7/14/05, <B class=gmail_sendername>BERNHARD Nora</B> <<A href="mailto:nora.bernhard@(protected)">nora.bernhard@(protected)< /A>> wrote:</SPAN> <BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi Bryan,<BR><BR>> 1) Are you connecting using the "virtual" instance or are you<BR>> connecting directly to the instance on the node or using "/ <BR>> as sysdba"? Run the query the previous poster sent and check<BR>> you connection parameters.<BR><BR>I tried with 'sqlplus / as sysdba' and 'sqlplus sys as sysdba' + pw.</BLOCKQUOTE> <DIV> </DIV> <DIV> </DIV> <DIV>you are not using net8 at all then. try it from a 'remote' connection. <BR><BR><BR>-- <BR>Niall Litchfield<BR>Oracle DBA<BR><A href="http://www.niall.litchfield.dial.pipex.com ">http://www.niall .litchfield.dial.pipex.com </A></DIV></DIV></BLOCKQUOTE></BODY></HTML>
