OraFAQ Forum: Server Administration » Oracle not reconising shutdown command

Home » RDBMS Server » Server Administration » Oracle not reconising shutdown command (Database 9.2.0.7 O.S linux)

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

Oracle not reconising shutdown command [message #341335]

Mon, 18 August 2008 07:12

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

When i am trying to shutdown the database it is not recognising it.It is giving error.

SQL>shutdown immediate
unknown command beginning "shutdown i..." - rest of line ignored.

I am passing this command on Sql prompt.So i don't think problem in setting ORACLE_BASE,ORACLE_SID.

Please provide so,lution to this problem.

Thanks in advance.
Ran vijai

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341338 is a reply to message #341335]

Mon, 18 August 2008 07:27

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

can you post exact "sqlplus" session output?

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341467 is a reply to message #341335]

Mon, 18 August 2008 23:45

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

Oracle Version:9.2.0.7
O.S: Linux 4
Application:Retail12 apps 9.2

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341481 is a reply to message #341338]

Tue, 19 August 2008 00:51

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

The exact output is

[oracle@ssipl-srvr-030 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 19 11:16:27 2008

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

unknown SET option beginning "SQLPLUSCOM..."

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341482 is a reply to message #341467]

Tue, 19 August 2008 00:53

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

I am also unable to shutdown the database and getting error:

SQL> shutdown
unknown command "shutdown" - rest of line ignored.
SQL>

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341483 is a reply to message #341481]

Tue, 19 August 2008 00:54

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You should at least post the COMPLETE session including the erroneous statement and until exit, don't you think?
Why are you so reluctant to post full information?

In addition, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.

Check your glogin.sql and login.sql files.

Regards
Michel

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341528 is a reply to message #341483]

Tue, 19 August 2008 04:02

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

This is complete command and output from connecting to database upto getting error

[oracle@ssipl-srvr-030 ~]$ . .bash_db_profile
[oracle@ssipl-srvr-030 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 19 14:26:54 2008

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

unknown SET option beginning "SQLPLUSCOM..."
SQL> shutdown
unknown command "shutdown" - rest of line ignored.
SQL>

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341543 is a reply to message #341528]

Tue, 19 August 2008 04:42

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Check your glogin.sql and login.sql files.

Quote:

In addition, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341547 is a reply to message #341543]

Tue, 19 August 2008 04:59

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

I don't know what think i have to check.Please tell me

This is the content glogin.sql

[oracle@ssipl-srvr-030 admin]$ more glogin.sql
--
-- Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved.
--
-- NAME
-- glogin.sql
--
-- DESCRIPTION
-- SQL*Plus global login startup file.
--
-- Add any sqlplus commands here that are to be executed when a user
-- starts SQL*Plus on your system
--
-- USAGE
-- This script is automatically run when SQL*Plus starts
--

-- For backward compatibility
SET PAGESIZE 14
SET SQLPLUSCOMPATIBILITY 8.1.7

-- Used by Trusted Oracle
COLUMN ROWLABEL FORMAT A15

-- Used for the SHOW ERRORS command
COLUMN LINE/COL FORMAT A8
COLUMN ERROR FORMAT A65 WORD_WRAPPED

-- Used for the SHOW SGA command
COLUMN name_col_plus_show_sga FORMAT a24

-- Defaults for SHOW PARAMETERS
COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME
COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE

-- Defaults for SET AUTOTRACE EXPLAIN report
COLUMN id_plus_exp FORMAT 990 HEADING i
COLUMN parent_id_plus_exp FORMAT 990 HEADING p
COLUMN plan_plus_exp FORMAT a60
COLUMN object_node_plus_exp FORMAT a8
COLUMN other_tag_plus_exp FORMAT a29
COLUMN other_plus_exp FORMAT a44

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341563 is a reply to message #341547]

Tue, 19 August 2008 06:14

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

SQL*Plus: Release 8.0.6.0.0 -

Quote:

SET SQLPLUSCOMPATIBILITY 8.1.7

Seems inconsistent, doesn't it?

Regards
Michel

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341566 is a reply to message #341563]

Tue, 19 August 2008 06:25

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

ya there is inconsistency.when i commented this line

--SET SQLPLUSCOMPATIBILITY 9.2.0

I am getting this output

[oracle@ssipl-srvr-030 admin]$ sqlplus "/ as sysdba"

SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 19 16:44:20 2008

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

SQL>

Error has gone but still i am not able to shutdown the database.

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341567 is a reply to message #341335]

Tue, 19 August 2008 06:28

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

This is the error i am getting

[oracle@ssipl-srvr-030 admin]$ sqlplus "/ as sysdba"

SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 19 16:53:23 2008

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

SQL> shutdown
unknown command "shutdown" - rest of line ignored.
SQL>

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341575 is a reply to message #341567]

Tue, 19 August 2008 06:42

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes because sqlplus 8.0 does not know "shutdown", you must have at least sqlplus 8.1 or use sqldba.

Regards
Michel

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341577 is a reply to message #341567]

Tue, 19 August 2008 06:46

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

1. Did you checked your alert_SID.log file? Any error message?

2. Please try to set ORACLE_HOME (Use SQLPlus 9.2.0.7 from the Database server's Oracle_Home)

Babu

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341580 is a reply to message #341335]

Tue, 19 August 2008 07:13

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

Ya i am getting this error:

Tue Aug 19 02:53:35 2008
Errors in file /home/oracle/RWMSLDB/admin/udump/rwmsldb_ora_21254.trc:
ORA-00600: internal error code, arguments: [ttclxx1], [29696], [2], [], [], [], [], []

Is it this error producing the above problem

And i know that this internal error only solve by Oracle support.Is There is other way to solve this problem ?.

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341581 is a reply to message #341580]

Tue, 19 August 2008 07:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

1. ORA-00600 is a bug will only solved by latest patchset or patch.

2. as above suggest go to machine where oracle server is installed then oraclehome & path variable to point oracle 9i. then connect to db and shutdown.

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341583 is a reply to message #341581]

Tue, 19 August 2008 07:29

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

I have checked the ORACLE_HOME AND PATH VARIABLE.which is

ORACLE_SID=RWMSLDB
ORACLE_BASE=/u01/app/oracle
FORMS60_TERMINAL=/home/oracle/RWMS12/appserverunix/forms/bin
RDM_SRC=/home/oracle/RWMS12/appserverunix/forms/src
TNS_ADMIN=/home/oracle/app/ora9iAS/6iserver/network/admin
MAIL=/var/spool/mail/oracle
PATH=/home/oracle/app/ora9iAS/6iserver/bin:/home/oracle/app/ora9iAS/bin:/usr/java/jdk1.3.1_20/bin:/home/oracle/bin:/home/oracle/RWMS1 2/appserverunix/forms6i_scripts:.:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:.:/home/oracle/bin:/ u01/app/oracle/product/9.2.0/bin:.
ORACLE_HOME=/u01/app/oracle/product/9.2.0

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341595 is a reply to message #341583]

Tue, 19 August 2008 08:08

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I bet for an installation of several versions in the same home.
How could you have a sqlplus version 8.0.6 when your home seems to indicate a 9.2 version?

Regards
Michel

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341598 is a reply to message #341595]

Tue, 19 August 2008 08:25

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

Sorry i don't know answer of this question.How it is possible that one componenet is of different version.

when i check version of the database it will show 9.2.0.7

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for Linux: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341606 is a reply to message #341598]

Tue, 19 August 2008 09:02

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

How it is possible that one componenet is of different version.

Quote:

I bet for an installation of several versions in the same home.

And maybe an aborted installation.

Regards
Michel

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341682 is a reply to message #341606]

Tue, 19 August 2008 23:26

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

How we can found that it is aborted installation or successful installation.because it is installed by different DBA.

Report message to a moderator

Re: Oracle not reconising shutdown command [message #341684 is a reply to message #341682]

Tue, 19 August 2008 23:41

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Deinstall Oracle and cleanly reinstall it.

Regards
Michel

Report message to a moderator

Re: Oracle not reconising shutdown command [message #502881 is a reply to message #341335]

Mon, 11 April 2011 04:44

ankit3010
Messages: 17
Registered: November 2010
Location: Indore

Junior Member

I think you have to export ORACLE_SID...like
export ORACLE_SID=Instance_name

Report message to a moderator

Re: Oracle not reconising shutdown command [message #502884 is a reply to message #502881]

Mon, 11 April 2011 05:11

cookiemonster
Messages: 13973
Registered: September 2008
Location: Rainy Manchester

Senior Member

You do realise this is a three year old question right?
I'd like to hope ranvijaidba has solved his problem by now.

Report message to a moderator

Re: Oracle not reconising shutdown command [message #502979 is a reply to message #502884]

Tue, 12 April 2011 01:08

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

I understand this is a very old quostion still not resolved on forum. Might be the user would have resolved it definitely.

Quote:

ORACLE_SID=RWMSLDB
ORACLE_BASE=/u01/app/oracle
FORMS60_TERMINAL=/home/oracle/RWMS12/appserverunix/forms/bin
RDM_SRC=/home/oracle/RWMS12/appserverunix/forms/src
TNS_ADMIN=/home/oracle/app/ora9iAS/6iserver/network/admin
MAIL=/var/spool/mail/oracle
PATH=/home/oracle/app/ora9iAS/6iserver/bin:/home/oracle/app/ora9iAS/bin:/usr/java/jdk1.3.1_20/bin:/home/oracle/bin:/home/oracle/RWMS1 2/appserverunix/forms6i_scripts:.:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:.:/home/oracle/bin:/ u01/app/oracle/product/9.2.0/bin:.
ORACLE_HOME=/u01/app/oracle/product/9.2.0

I think the sqlplus is picked from path "/home/oracle/app/ora9iAS/6iserver/bin" which is 8i oracle home.
Can be verified with "which sqlplus" command.

Ridhi

Report message to a moderator

Previous Topic:	Error in startup mount after shutdown immediate
Next Topic:	Unable to delete archive files thro ASMCMD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 09 01:34:53 CST 2025