Re: sqlplus does not connect

Probably...you can re-run the oradim with the auto parameter..see the docs or try oradim /?

x3x3_at_my-deja.com wrote:

>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:47:46 CST