Sqlplus error

[Former Member]

Hi Gurus,

i have installed IDES 5.0 and solution manager on the same system.

But ides 5 have oracle 9i and for solution manager i have installed 10G

When i try to connect oracle from sqlplus /nolog; its given an following error

C:\Documents and Settings\Administrator>sqlplus /nolog;

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Dec 19 10:38:23 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL*Plus: Release 10.2.0.2.0 - Production

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Usage 1: sqlplus -H | -V

-H Displays the SQL*Plus version and the

usage help.

-V Displays the SQL*Plus version.

Usage 2: sqlplus [ [<option>] [<logon>] [<start>] ]

<option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]

-C <version> Sets the compatibility of affected commands to the

version specified by <version>. The version has

the form "x.y[.z]". For example, -C 10.2.0

-L Attempts to log on just once, instead of

reprompting on error.

-M "<options>" Sets automatic HTML markup of output. The options

have the form:

HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]

[ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]

-R <level> Sets restricted mode to disable SQL*Plus commands

that interact with the file system. The level can

be 1, 2 or 3. The most restrictive is -R 3 which

disables all user commands interacting with the

file system.

-S Sets silent mode which suppresses the display of

the SQL*Plus banner, prompts, and echoing of

commands.

<logon> is: (<username>[/<password>][@<connect_identifier>] | /)

[AS SYSDBA | AS SYSOPER] | /NOLOG

Specifies the database account username, password and connect

identifier for the database connection. Without a connect

identifier, SQL*Plus connects to the default database.

The AS SYSDBA and AS SYSOPER options are database administration

privileges.

The /NOLOG option starts SQL*Plus without connecting to a

database.

<start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]

Runs the specified SQL*Plus script from a web server (URL) or the

local file system (filename.ext) with specified parameters that

will be assigned to substitution variables in the script.

When SQL*Plus starts, and after CONNECT commands, the site profile

(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile

(e.g. login.sql in the working directory) are run. The files may

contain SQL*Plus commands.

Refer to the SQL*Plus User's Guide and Reference for more information.

Regards

Hemant Gade

Basis Consultant

[Former Member]

This is pending from last 5 months so i have close this thread.

Regards

Hemant

Edited by: hemantg on May 5, 2011 10:27 AM

[Former Member]

hi,

you can try;

$ORACLE_HOMES/bin/sqlplus / as sysdba

ferhan

[volker_borowski2]

> C:\Documents and Settings\Administrator>sqlplus /nolog;

Hi,

- no ";" for sqlplus upon call (in WIndows)

- User "Administrator" has obviously no or wrong environment. Use corresponding "sidadm" to have correct environment.

- Did you follow instructions "install mutiple ORACLE_HOMEs on single Host" from the Installation guide? There is a section that describes how to remove Oracle PATH settings from the system environment.

Best regards

Volker

[Former Member]

Yes Volkar,

thanks for reply.

I have different oracle for IDES 5.0 and solution manager.

I have also tried from <SID>adm.

but its didn't work.

Regards

Hemant Gade

Basis Consultant

[Former Member]

You need to make sure that the <SID>adm is member of following groups

ORA_<DBSID>_dba

ORA_<DBSID>_oper

[volker_borowski2]

> I have different oracle for IDES 5.0 and solution manager.
> I have also tried from <SID>adm.
> but its didn't work.

Well,

your "Administrator" can call SQLPLUS without a full qualified path.

With two Oracle Homes, this clearly indicates a faulty setup, because no part of any ORACLE_HOME

should be part of the system PATH environment in this case.

Again: Check the installation guide for the section to install multiple ORACLE_HOMEs.

Open a CMD.exe for BOTH sidadm-users and post output of the following commands:

PATH

set ORA

(which should deliver at least ORACLE_HOME / ORACLE_SID / ORA_NLS33)

set TNS

Best regards

Volker

[Former Member]

Thanks Volker,

Can you please explain me the procedure how to set Multiple oracle home.

Regards

Hemant

[Former Member]

Hi,

Now i have got the following error while connecting to oracle

*C:\Documents and Settings\Administrator>sqlplus /nolog;*

*SQLPlus: Release 9.2.0.4.0 - Production on Mon Dec 27 20:55:31 2010**

*Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.*

*SP2-0306: Invalid option.*

*Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]*

*where <logon> ::= <username>[/<password>][@<connect_string>] | /*

*Enter user-name:*

Please help me on this.

Regards

Hemant

[Former Member]

>>*C:\Documents and Settings\Administrator>sqlplus /nolog;*

You are getting error *SP2-0306: Invalid option.*

why you are using ** just use below command

sqlplus /nolog

connect /

[Former Member]

Hi sunil,

it was used for bold letter but wrongly i have entered this twice.(**)

Sorry for that.

I think this is due to non set the oracle home.

i have also set the oracle home but still i got the same message.

I am not able to connect oracle from sqlplus /nolog;.

Regards

Hemant

Edited by: hemantg on Dec 29, 2010 11:12 AM