Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> sqlplus does not connect

sqlplus does not connect

From: <x3x3_at_my-deja.com>
Date: Fri, 19 Jan 2001 17:00:19 GMT
Message-ID: <949rqt$men$1@nnrp1.deja.com>

Hello,

After starting oracle service and tnslistener service I am able to use svrmgrl and connect internal but am not able to get through with sqlplus. could one guide?

C:\>svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production

SVRMGR> help
The following are SIMPLIFIED syntax descriptions. For complete syntax descriptions, please refer to the Oracle Server Manager User's Guide.

STARTUP      [DBA] [FORCE] [PFILE=filespec] [EXCLUSIVE | SHARED]
             [MOUNT dbname | OPEN dbname] [NOMOUNT]

SHUTDOWN     [NORMAL | IMMEDIATE | ABORT]

MONITOR      For graphical modes only, bring up a monitor

ARCHIVE LOG [START] [STOP] [LIST] [NEXT] [<n>] [ALL] ['destination']

RECOVER { [DATABASE [MANUAL] ] | [TABLESPACE ts-name [,tsname]] }

CONNECT [username [/password] ] [INTERNAL] ['@'instance-spec] DISCONNECT SET options: INSTANCE, ECHO, TERMOUT, TIMING, NUMWIDTH, CHARWIDTH
SHOW LONGWIDTH, DATEWIDTH, AUTOPRINT and for SHOW: ALL, SPOOL

EXIT
REM
             SQL statements can also be executed. SVRMGR> show

Instance                        local
Spool                           OFF
Timing                          OFF
Termout                         ON
Echo                            OFF
Stoponerror                     OFF
Autorecovery                    OFF
Logsource                       <default>
Maxdata                         20480
Numwidth                        10
Charwidth                       80
Longwidth                       80
Datewidth                       9
Labwidth                        32
Compatibility                   NATIVE
Retries                         infinite
Server Output                   OFF
Autoprint                       OFF
Fetchrows                       infinite
Appinfo                         OFF (USERTEXT : Oracle Server Manager)
SVRMGR> connect internal/mypassword
Connected.
SVRMGR> C:\>sqlplus

SQL*Plus: Release 8.1.6.0.0 - Production on Fri Jan 19 11:56:24 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter user-name: connect internal/mypassword_at_mango.mcom SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL] where <logon> ::= <username>[/<password>][@<connect_string>] | / Enter user-name: connect internal
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL] where <logon> ::= <username>[/<password>][@<connect_string>] | / Enter user-name: connect as internal
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL] where <logon> ::= <username>[/<password>][@<connect_string>] | / SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 19 2001 - 11:00:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US