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 -> Re: sqlplus does not connect

Re: sqlplus does not connect

From: <x3x3_at_my-deja.com>
Date: Fri, 19 Jan 2001 18:11:48 GMT
Message-ID: <94a00q$qpa$1@nnrp1.deja.com>

Hello,

That worked. Thanks.

Another one is I created instance of oracel service using oradim command and what happens is it makes idle instance started and not like earlier that it would also start database. I had not used auto option with oradim command. is that why?

In article <ogtg6tkcqlm809au3fent52ub271jglbpk_at_4ax.com>,   See Message body for real address wrote:
>
> 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/
>
>

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

Original text of this message

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