Re: sqlplus does not connect

Do not use the 'connect' statement...

When SqlPlus prompts for user name just enter: internal/mypassword_at_mango.mcom

The 'connect' statement is needed in Svrngrl but not SqlPlus [ it can be used once you are connected to an instance to allow you to change your connection to some other instance ]

x3x3_at_my-deja.com wrote:

>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:19:08 CST