Server Administration :: Startup Open After Shutdown Throws ORA-12514 Error?

Jan 12, 2011

I searched the knowledge base here and in other forums and haven't found the answer. There was a similar condition presented earlier, but it turned out the resolution was to run the >shutdown/>startup on the server rather than from a client. Not applicable in my case!

Shutdown and startup called used to work with 9i, now startup fails in 10g. ORACLE_HOME and ORACLE_SID are set and report correct values. What is different in 10g that the script (shown below) now throws a TNS listener error after shutdown?

I successfully upgraded from 9i to 10g (10.2.0.5.0) on Windows Server 2003, 32-bit last weekend. Now our backup_script.bat and oracle_stop_start.sql throw "ORA-12514: TNS:listener does not currently know of service requested in the connect descriptor"

This batch file and sql script predate me and worked with 9i for years. Now the startup command in the oracle_stop_start throws this error after executing shutdown. The backup batch file calls:

sqlplus "system/manager@wind as sysdba" @D:ptcwindchillackupsoracle_stop_start

The entire oracle_stop_start.sql is as follows:

shutdown immediate;
startup open;
quit

What is different in 10g that this now doesn't work? Shutdown works, but it will not startup due to the listener error. I have made the backups work by commenting out the call to sqlplus and I'm getting good backup dumps.

In my virtual image of the server I have found that I can duplicate the error after >shutdown. I have found that if I exit sql*plus and go back in as follows I can get the database instance to restart from the command line:

c:>sqlplus /nolog
sql>connect sys/* as sysdba
sql>startup open wind;

That does start, mount and open the database instance.

Is there a better way to be making sure that everything is stopped before executing the >exp command to create a backup dump? I will look into and test datapump export/import and RMAN for creating the backups, after I get this working again.

why this worked in sql*plus in 9i but not in 10g? Can I make TNS Listener smarter? Change or add variables to the startup command?

View 2 Replies


ADVERTISEMENT

Server Administration :: Error In Startup Mount After Shutdown Immediate?

Apr 1, 2009

I want to shutdown the database using shutdown immediate and startup the database using startup mount.

1.)My system is client system if I connect start--> program -->Accessories --> communication --> Remote Desktop connection (connect server system) , open Run type cmd after

Shutdown immediate (database is shutdown)

Startup mount (database is mounted no problem it's working fine)

2.) But if I, open Run type cmd in client system If I run same command, I'm getting below error (ORA-12560: TNS:protocol adapter error).

C:>set oracle_sid=dbadb
C:>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on ╘± ╠ß± 31 18:09:27 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error

[code].....

3. If I run same command in Sql Plus I'm getting below error(ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).

SQL*Plus: Release 10.1.0.2.0 - Production on Ôñ Ìáñ 31 18:23:13 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

[code].....

View 14 Replies View Related

Server Administration :: Oracle 10g - Database Server Startup / Shutdown

Jun 29, 2011

I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.

View 5 Replies View Related

Server Administration :: SHUTDOWN And STARTUP DB Server From Client Machine?

Sep 21, 2010

I have installed oracle 11g Release 11.1.0.1 on windows server 2008.I access this server from a client machine running on winXP through SQL PLUS. I wanted to shutdown and start DB server from this client machine. Accordingly i issued shutdown immediate command from SQLPLUS.

Now when i tried to start the DB with "STARTUP NOMOUNT" command i received error 12514. I understand this error means that the listener received a request to establish connections to a database but since DB services are not up and running, hence the error. So my first question is how do I resolve this error.

Continuing further, i tried to re-connect to the database as sys, and i received another error ORA-01041. So, my second question is why did i receive this error and again how can i resolve it

may be you can point me to relevant reference in Oracle documentation) how can i start and stop oracle from a client machine using SQL interface in CLI mode and windows environment and avoid this error.

View 12 Replies View Related

Server Administration :: Script To Automate Startup / Shutdown Of Multiple Instance In One Database

Jun 24, 2010

Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.

View 1 Replies View Related

Server Administration :: ORA-12514 Error On Database Link

Jan 27, 2011

One of colleague (who has left) created a database link using the statement:

CREATE PUBLIC DATABASE LINK CIVCLMANLINK USING ''CIVCLMAN''

When I try to use this link like:

SELECT * FROM CLIENTMANAGEMENT.ADDRESS@CIVCLMANLINK;

I get the following error:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I can connect to the CIVCLMAN using the Oracle Enterprise Manager / SQL Plus, I can tnsping as well

View 25 Replies View Related

Server Administration :: ORA-1033 Error Initialization Or Shutdown In Progress

May 16, 2012

I have oracle 10g as well as oracle 8i on my server. currently we are using oracle 10g. now we get the following error when we try to connect to oracl 10g database.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:Documents and Settingsomni>cd
C:>sqlplus
olog
The system cannot find the path specified.
C:>sqlplus/nolog
SQL*Plus: Release 8.1.5.0.0 - Production on Tue May 15 16:39:13 2012
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> connect sys/admin as sysdba
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
LRM-00109: could not open parameter file 'D:oro8iDATABASEINIT.ORA'
ORA-01078: failure in processing system parameters

The location of pfile of oracle 10g database is c:/oracle/product/10.0.0.1/admin/pfile.

View 5 Replies View Related

RAC ASM Complete Shutdown And Startup

Jul 7, 2011

I need to take the certain logs on my 3-Node, 10gR2 RAC with ASM on Solaris 10.I have been asked to shutdown the database, nodeapps, listener, asm and crs and then restart crs. Below are t steps that I have prepared.

CODE
====Enable trace=========
ENABLE LEVEL 5 tracing-
./crsctl debug log crs allcomp:5
====Stop database, asm, listener, nodeapps finally crs===
1. STOP DATABASE
srvctl stop database -d DB_NAME
[code]....

View 2 Replies View Related

Automating Database Startup And Shutdown?

Jan 5, 2012

We are having a problem trying to automate our 11g database startup on a Linux Platform (Redhat). This is the procedure we followed.

1. Logged in as the root user.

2. Edited the oratab file for the platform.

vi /etc/oratab
db:/u01/app/oracle/product/11.2.0/dbhome_1:Y

3. Create a file called dbora in /etc/init.d directory

4. Entered the following in dbora:

#! /bin/sh -x
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

[Code] .....

4. Changed permissions of dbora

chgrp dba dbora
chmod 750 dbora

5. Created symbolic links to the dbora script in the appropriate run-level script directories:

# ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora

Have I covered everything needed? At system restart the listener and database fail to startup as expected.

View 4 Replies View Related

SQL & PL/SQL :: Database Startup And Shutdown Event?

May 7, 2013

Any example of database startup event and database shutdown event?

View 2 Replies View Related

RAC & Failsafe :: Advisable To Use Shutdown Immediate And Startup Command

Feb 15, 2013

I want to set the following parameter in one node and restart the machine.

ALTER SYSTEM SET MEMORY_MAX_TARGET=4G SCOPE=SPFILE sid='*'

I know we could use srvctl command to restart DB.My question is..to restart DB is it advisable to use shutdown immediate and startup command ?

View 6 Replies View Related

Client Tools :: Connect With Database Through Toad - It Throws Error?

Apr 23, 2012

there is a problem , related to toad. when i try to connect with my database through toad then it throws an error-"Can't initialize OCI. Error -1", how to sort out of this problem. and i am using toad 9.2.7.1 on widows server2008.

View 9 Replies View Related

Server Administration :: Database Startup?

Apr 27, 2010

MY oracle database is not starting ,at startup its giving me following error message .

ORA-00600: internal error code, arguments: [kccext_info_4], [], [], [], [], [],[], []

Alert Log file showing following message ,

Tue Apr 27 14:22:26 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Apr 27 14:22:26 2010
ARC1: Becoming the heartbeat ARCH
Tue Apr 27 14:22:26 2010
db_recovery_file_dest_size of 2048 MB is 36.88% used.

This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Tue Apr 27 14:22:27 2010Errors in file h:oracleproduct10.2.0adminorcl4udumporcl4_ora_3704.trc:ORA-00600: internal error code, arguments: [kccext_info_4], [], [],

[code]...

If i connect with scott user ,following message occurs ,

ORA-01033: ORACLE initialization or shutdown in progress

View 2 Replies View Related

Server Administration :: Unable To Startup Database

Jun 20, 2011

im new to DBA.i installed oracle on my pc but im not able to startup database...im manually creating database ..CRD files r still not created as im unable to startup nomount..im getting this error.

SQL> startup nomount
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

i almost worked on this for 10 days but im getting the same error...

View 39 Replies View Related

Server Administration :: Database Shutdown Failed

Dec 16, 2012

I issued a SHUTDOWN IMMEDIATE command on my database and for over 2 hours and got no response. I did this because I wanted to restart the database due to many hanging sessions which had led to high CPU usage on the server by oracle process.

Oracle Service<dbname> instance using the Windows Services screen which failed with an error 1053 message. At the same time I got an ORA-01013 message saying user requested cancel of operation. See below:

SQL> SHUTDOWN IMMEDIATE
ORA-01013: user requested cancel of current operation
SQL> SHUTDOWN IMMEDIATE
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> SHUTDOWN ABORT
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

What I want to know is how do I proceed? Also how do I check to see the status of the Shutdown operation?

View 1 Replies View Related

Server Administration :: Database Shutdown Is Required Or Not

Apr 24, 2011

We have 2 Unix SunOS server, named as SUNOS01 and SUNOS02, there is some space need to add in SUNOS02 and for that I have to bring Database down on SUNOS02. When I checked I found that the DB is pointing to SUNOS01, i.e. there is no DB on SUNOS02, So, Do I required to shutdown the DB on SUNOS01 or it is not required to do anything from Database side. I mean to say should I ask Unix team to bring down the unix server and add the space.Also, if DB shutdown is not required then what I have to do afetr they have added space and bring the server up from DB side.

View 4 Replies View Related

Server Administration :: Preventing Database Shutdown By A Trigger?

Jan 15, 2013

i mean can i write a trigger to prevent shutdown in certain time.

create or replace trigger trig1 before shutdown on database begin if to_char(sysdate,'hh24') <16 then 'what is the right thing to do here?'

View 3 Replies View Related

Server Administration :: Oracle Not Recognizing Shutdown Command

Aug 18, 2008

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.

View 24 Replies View Related

Server Administration :: Listener Shutdown For Individual Instances

May 17, 2013

I am upgrading a DB using catupgrd.sql, and one of the prerequisites is to shut down the listener. Now, I have multiple database instances registered with this listener, and I don't want the other ones to become unavailable while I do the upgrade. Is there any way to do this for a particular instance only?

View 9 Replies View Related

Server Administration :: DBMS_JOB Restarting / Database Shutdown

Aug 8, 2010

I was monitoring a database job to collect statistics, it was scheduled using DBMS_JOBS..I found that it was running during business hours so i got the session ID of the job using;

select sid from dba_jobs_running where job=11;

I then i killed the job using;

select serial# from v$session where sid =232;
alter system kill session '232, 10852';
select sid from dba_jobs_running where job=11;

no rows selected...After some time i again fired the same command

select sid from dba_jobs_running where job=11;

SID
----------
232

and found that the same job is again running..This behavior was repeated again N again. i have attached the spool file for the same...

what could be the reason that the job is starting all over again even after killing the session and what should be done to stop it..I understand that once the database shuts down and if the job is still running then it will restart once the database is up..In this case, Should i remove the job and re submit it again..

View 8 Replies View Related

Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)

Sep 13, 2013

we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?

View 3 Replies View Related

Server Administration :: ORA-01033 / Oracle Initialization Or Shutdown In Progress

Oct 14, 2010

When I am trying to connect to sql from scott or any other user i am getting this error message ,

ORA-01033: ORACLE initialization or shutdown in progress

I have been getting this error message for 4 four days . Butt when i am trying to connect from SYS user it connects successfully ,but when i do query it gives me following error message .

ORA-01219: database not open: queries allowed on fixed tables/views only

I shutdown Database from SYS user ,and start it again .But at startup it gives me following error message .

ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file: 'D:ORACLEPRODUCT10.2.0ORADATAORCLCONTROL03.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).

View 9 Replies View Related

Server Administration :: PMON (failed To Acquire Latch) During Shutdown

Aug 29, 2010

I found in alert log that PMON "failed to acquire latch" during shutdown.What it means and how to rectify the same.

View 2 Replies View Related

Server Administration :: ORA-01033 Oracle Initialization Or Shutdown In Progress

Jul 1, 2010

when i am using sql prompt and enter username and password scott and tiger it is giving error ORA-01033 oracle initialization or shutdown in progress.

View 9 Replies View Related

Server Administration :: Unable To Drop User Without Database Shutdown

Apr 19, 2013

We are unable to drop user due to below error, how to drop the below user without shutdown the database.

SQL> drop user mvm_2010 cascade;
drop user mvm_2010 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already in use

No session was available for particular user.

View 19 Replies View Related

Server Administration :: Oracle Server Shutdown

Apr 1, 2012

We have changed the SYSDATE to 03-FEB-1994 in our AIX machine where oracle11g database is running. Once the sysdate is changed db and listner are getting down immediately and its generating the core in $ORACLE_HOME/dbs

This AIX machine is for PT test and as per one requirement we are changing the sysdate. Moreover, we found that database is getting down if we change the sysdate till 1999. If we change the sysdate to 2000, then we are not seeing any issue.

Below point is for additional info. After changing the sysdate and trying to connect to the db user, we are getting the below issue.

$ sqlplus '/as sysdba'
Segmentation issue (Core dump)

View 3 Replies View Related

Server Administration :: Unable To Login - ORACLE Initialization Or Shutdown In Progress

Aug 20, 2010

My database was working fine and now I am not able to login and getting the error:-

"ORA-01033: ORACLE initialization or shutdown in progress"

I have done the below steps:

SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORA-32004: obsolete and/or deprecated parameter(s) specified

[code]....

View 10 Replies View Related

Server Administration :: Database To Startup With PFile - Failure In Processing System Parameters

Feb 8, 2011

I successfully created a DB manually with PFILE.

I want the DB to startup with SPFILE at next login.So i fired the below command.

CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.

But it shows the error as below:

ORA-01078: failure in processing system parameters
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.

View 20 Replies View Related

Backup & Recovery :: Backup Full Database Throws Error?

May 13, 2012

SQL> SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

after i backup my database,i check the alert log ,i found the following errror:

Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:

[code]....

the trace number 26967 :

[oracle@shenzhengair archivelog]$ cat /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc
/u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1

[code]....

what does the error mean?

View 6 Replies View Related

Server Administration :: Not Able To Open Database

Mar 8, 2013

I am using oracle 10gXE just for basic practice but its showing following Errors

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 8 11:46:34 2
Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down fir
SQL>
SQL>
SQL>
SQL> select * from dept;
select * from dept
[code]....

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved