Home » RDBMS Server » Server Administration » Oracle not reconising shutdown command (Database 9.2.0.7 O.S linux)
Oracle not reconising shutdown command [message #341335] Mon, 18 August 2008 07:12 Go to next message
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

Re: Oracle not reconising shutdown command [message #341338 is a reply to message #341335] Mon, 18 August 2008 07:27 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

can you post exact "sqlplus" session output?
Re: Oracle not reconising shutdown command [message #341467 is a reply to message #341335] Mon, 18 August 2008 23:45 Go to previous messageGo to next message
ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore
Member
Oracle Version:9.2.0.7
O.S: Linux 4
Application:Retail12 apps 9.2
Re: Oracle not reconising shutdown command [message #341481 is a reply to message #341338] Tue, 19 August 2008 00:51 Go to previous messageGo to next message
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..."
Re: Oracle not reconising shutdown command [message #341482 is a reply to message #341467] Tue, 19 August 2008 00:53 Go to previous messageGo to next message
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>

Re: Oracle not reconising shutdown command [message #341483 is a reply to message #341481] Tue, 19 August 2008 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle not reconising shutdown command [message #341528 is a reply to message #341483] Tue, 19 August 2008 04:02 Go to previous messageGo to next message
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>


Re: Oracle not reconising shutdown command [message #341543 is a reply to message #341528] Tue, 19 August 2008 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Oracle not reconising shutdown command [message #341547 is a reply to message #341543] Tue, 19 August 2008 04:59 Go to previous messageGo to next message
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
Re: Oracle not reconising shutdown command [message #341563 is a reply to message #341547] Tue, 19 August 2008 06:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle not reconising shutdown command [message #341566 is a reply to message #341563] Tue, 19 August 2008 06:25 Go to previous messageGo to next message
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.
Re: Oracle not reconising shutdown command [message #341567 is a reply to message #341335] Tue, 19 August 2008 06:28 Go to previous messageGo to next message
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>


Re: Oracle not reconising shutdown command [message #341575 is a reply to message #341567] Tue, 19 August 2008 06:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle not reconising shutdown command [message #341577 is a reply to message #341567] Tue, 19 August 2008 06:46 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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
Re: Oracle not reconising shutdown command [message #341580 is a reply to message #341335] Tue, 19 August 2008 07:13 Go to previous messageGo to next message
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 ?.
Re: Oracle not reconising shutdown command [message #341581 is a reply to message #341580] Tue, 19 August 2008 07:22 Go to previous messageGo to next message
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.

Re: Oracle not reconising shutdown command [message #341583 is a reply to message #341581] Tue, 19 August 2008 07:29 Go to previous messageGo to next message
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

Re: Oracle not reconising shutdown command [message #341595 is a reply to message #341583] Tue, 19 August 2008 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle not reconising shutdown command [message #341598 is a reply to message #341595] Tue, 19 August 2008 08:25 Go to previous messageGo to next message
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


Re: Oracle not reconising shutdown command [message #341606 is a reply to message #341598] Tue, 19 August 2008 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle not reconising shutdown command [message #341682 is a reply to message #341606] Tue, 19 August 2008 23:26 Go to previous messageGo to next message
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.
Re: Oracle not reconising shutdown command [message #341684 is a reply to message #341682] Tue, 19 August 2008 23:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Deinstall Oracle and cleanly reinstall it.

Regards
Michel
Re: Oracle not reconising shutdown command [message #502881 is a reply to message #341335] Mon, 11 April 2011 04:44 Go to previous messageGo to next message
ankit3010
Messages: 17
Registered: November 2010
Location: Indore
Junior Member
I think you have to export ORACLE_SID...like
export ORACLE_SID=Instance_name
Re: Oracle not reconising shutdown command [message #502884 is a reply to message #502881] Mon, 11 April 2011 05:11 Go to previous messageGo to next message
cookiemonster
Messages: 12403
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.
Re: Oracle not reconising shutdown command [message #502979 is a reply to message #502884] Tue, 12 April 2011 01:08 Go to previous message
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
Previous Topic: Error in startup mount after shutdown immediate
Next Topic: Unable to delete archive files thro ASMCMD
Goto Forum:
  


Current Time: Sat Dec 03 01:09:58 CST 2016

Total time taken to generate the page: 0.06253 seconds