Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> sqlplus does not connect
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
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