Home » Other » General » SP2-0042
icon11.gif  SP2-0042 [message #229081] Thu, 05 April 2007 05:20 Go to next message
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.
Re: SP2-0042 [message #229084 is a reply to message #229081] Thu, 05 April 2007 05:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
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.
Re: SP2-0042 [message #230304 is a reply to message #229081] Wed, 11 April 2007 08:48 Go to previous messageGo to next message
greatshah9
Messages: 3
Registered: April 2007
Location: Pakistan
Junior Member

Thanks Mahesh Rajendran

Your hint solved my problem.
Re: SP2-0042 [message #566039 is a reply to message #230304] Mon, 10 September 2012 20:07 Go to previous messageGo to next message
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
Re: SP2-0042 [message #566040 is a reply to message #566039] Mon, 10 September 2012 21:18 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
db_name='DB10'

above is the only required line in initDB10.ora file
Re: SP2-0042 [message #566048 is a reply to message #566039] Tue, 11 September 2012 01:33 Go to previous message
Michel Cadot
Messages: 59145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
oradim is NOT a SQL*Plus command, it is an OS level one.

Regards
Michel
Previous Topic: using mysql (merged 5)
Next Topic: Sending SMS from Oracle database
Goto Forum:
  


Current Time: Sat Sep 20 09:11:13 CDT 2014

Total time taken to generate the page: 0.05221 seconds