user_name :internal
not connect
<x3x3_at_my-deja.com> escribió en el mensaje de noticias
949rqt$men$1_at_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 Mon Jan 22 2001 - 12:32:56 CST
