OraFAQ Forum: General

Home » Other » General » SP2-0042

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SP2-0042 [message #229081]

Thu, 05 April 2007 05:20

greatshah9
Messages: 3
Registered: April 2007
Location: Pakistan

Junior Member

Hi

I'm currently using Oracle 10g Release-2 on window XP, and when i connect to database using user sys or any other i receive the following error

"Enter User-Name: sys
Enter Password: xxx

Connected to:
Oracle Database 10g Enterpirse Edition Release 10.2.0.1.0 - Production with the partitioning, OLAP and data Mining Option

SP2-0042: Unknown command " when a " rest of line ignored."

any help will be apriciated.

Report message to a moderator

Re: SP2-0042 [message #229084 is a reply to message #229081]

Thu, 05 April 2007 05:33

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

look into your login.sql or glogin.sql file.
May be there are some unwanted entries.

Report message to a moderator

Re: SP2-0042 [message #230304 is a reply to message #229081]

Wed, 11 April 2007 08:48

greatshah9
Messages: 3
Registered: April 2007
Location: Pakistan

Junior Member

Thanks Mahesh Rajendran

Your hint solved my problem.

Report message to a moderator

Re: SP2-0042 [message #566039 is a reply to message #230304]

Mon, 10 September 2012 20:07

pplsoft_Newbie
Messages: 5
Registered: September 2012

Junior Member

Hi all

I am suppose to do this.
You must create an init.ora with the naming convention of init<SID>.ora in the ORACLE_HOME\database
directory of the Oracle installation. The init.ora file is referenced in the following two places during the
database creation process:
• UsingtheORADIM command to create the Windows Service
• Executing the CREATEDB10.SQL script

However, I login to sqlplus and when they show
sql>oradim(this is what I typed)
and it gave me 'SP2-0042: unknown command "oradim" - rest of line ignored.'

Can someone please guide me. Thanks.

Newbie

Report message to a moderator