| 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
|
|
|
|
|
|
|
|
| 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..."
|
|
|
|
|
|
|
|
| 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>
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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.
|
|
|
|
| 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>
|
|
|
|
|
|
|
|
| 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 ?.
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
