Oracle Initialisation Or Shutdown In Progress

Jun 30, 2010

When i tried to connect oracle "oracle initialisation or shutdown in progress" was the error. then i tried the following steps and the results are as detailed below.

C:\>sqlplus/nolog
SQL*Plus: Release 9.0.1.0.1 - Production on Wed Jun 30 12:30:40 2010
© Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect sys/manager as sysdba
Connected.
SQL> exp
SP2-0042: unknown command "exp" - rest of line ignored.
SQL> export
SP2-0042: unknown command "export" - rest of line ignored.
SQL> shutdown
ORA-01109: database not open
[code]....

View 2 Replies


ADVERTISEMENT

SQL & PL/SQL :: ORACLE Initialization Or Shutdown In Progress

Oct 11, 2011

I try to login to my server but got "Login Error: SQL Error State 08004 , Native Error Code : 409 , ODBC Error , [Oracle][ODBC][Ora] ORA-01033 : ORACLE initialization or shutdown in progress".

View 3 Replies View Related

ORA-01033 / ORACLE Initialization Or Shutdown In Progress

Feb 16, 2011

i have a Problem when i try to connect to my Database Oracle 10.2.

every time i tried to connect to my database the Message: ORA-01033: ORACLE initialization or shutdown in progress appear.

In the alert.log there is the last writen part:

Wed Feb 16 21:55:54 2011
Errors in file d:\oracle\admin\v8\bdump\v8_arc0_5220.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 102385664 bytes disk space from 21474836480 limit

[code].....

In the morning i still work with my database then it freez and after restart the System i get everytime the same error Message.Start and stop the Oracle Service does not work.My system is Windows XP SP 3 if this is importend.

View 4 Replies View Related

ORA-01033 / ORACLE Initialization Or Shutdown In Progress In 10g

Sep 22, 2011

I am facing with the following error where I can not log into the iSQL*Plus 10.2.0.3.0.

ERROR - ORA-01033: ORACLE initialization or shutdown in progress in oracle 10g.

View 1 Replies View Related

ORA-01033 Oracle Initialization Or Shutdown In Progress Error

Nov 11, 2013

I am using windows 7 on my 64-bit machine, and I installed oracle database 12c. Everything was installed fine, and i was able to connect to the HR schema. However, the next day when I wanted to connect, I got the ORA-01033 Oracle initialization or shutdown in progress error.

View 10 Replies View Related

ORA-01033 - Oracle Initialization Or Shutdown In Progress Not Working?

Oct 11, 2012

C:>sqlplus
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Oct 11 09:56:23 2012
Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
SQL> startup nomount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01109: database not open

[code]...

ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL>

View 8 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 :: 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

Networking And Gateways :: Ora-01033 - Oracle Initialization Or Shutdown In Progress

Feb 24, 2010

I am getting the error 'ora-01033: Oracle initialization or shutdown in progress' when I try to login into oracle. It was working fine some days ago.I tried the below steps :-

C:Documents and Settingssk32740>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 24 14:31:08 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
[code]....

View 2 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 :: 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

Forms :: Progress Bar In Oracle 10g?

Feb 10, 2011

currently i m making a report , on this i want to insert progress bar ....

View 5 Replies View Related

Installation :: Oracle 10g Client - Progress Bar Stops At 80 Percent

Jul 18, 2012

I was installing Oracle 10g Client on my PC. But after Specifying Home Details, I was unable to proceed. The installation hangs in the Loading Product Information form.

The Progress bar stops at 80%.

View 3 Replies View Related

Database Auto Start With Machine On And Shutdown With Machine Shutdown

Sep 2, 2012

i install oracle 10g on linux on perform the following step but my database is not auto start with the machine

Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.

The scripts are,
$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbshut

Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.

-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.

In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.

If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.

Automate Startup/Shutdown of Oracle Database on Linux

Step 01: Be sure that oratab file is correct and complete.

Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.

Database entries in the oratab file have the following format:

$ORACLE_SID:$ORACLE_HOME:Y
Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.

If in my database there is two database named arju and arjudup then my oratab file will contain the entry like,
arju:/var/opt/oracle/product/10.2.0/db_1:Y
arjudup:/var/opt/oracle/product/10.2.0/db_1:Y
where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.

Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.

a) Login as root.
b) Change directories to /etc/init.d
c) Create a file called dbora and chmod it to 750.

# touch dbora
# chmod 750 dbora
d)Edit the dbora file and make the contents of it like below.

[Code].....

View 1 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

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 :: 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 :: 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

Forms :: Progress Bar Not Working

Dec 11, 2011

i have this procedure in my form to make some checks on employee data:

Procedure Pu_Check_Emp_Positions_Prc Is
Cursor vc_get_users_data_case1 Is
Select A.User_No, A.User_Responsility, A.User_Position, B.User_Status
From Import_Emp_Positions_Dtl A,
Shows_Users B
Where A.User_No = B.User_No
And (Substr(A.User_Position, 1, 1) = 'R' Or Substr(A.User_Position, 1, 1) = 'r')
And A.User_Responsility Is Not Null
And B.User_Status In (2, 3, 4, 7, 8);
--And A.User_No = 'XSER0001';
[code]....

i need to run this progress bar and finished when the procedure finish.

View 7 Replies View Related

Forms :: How To Include Progress Bar

Jun 4, 2010

How can we include a progress bar in forms?

View 1 Replies View Related

Forms :: Progress Bar In Webutil

Mar 13, 2010

I have challenge to do progress bar

i have simple form has one database block tabular used to upload files by webutil procedures

my question is there build_in progress bar that special for uploading could be used by webutil ?

View 1 Replies View Related

Forms :: Progress Bar On New Form Instance?

Jun 18, 2010

Urgently need a code for displaying progressbar on spalsh screen on new form instance without button click

View 1 Replies View Related

SQL & PL/SQL :: DELETE Fails When INSERT In Progress?

Jan 20, 2012

I have a large 10G database, with records being inserted almost constantly. In order to "UPDATE" records, I need to be able to DELETE the old record and INSERT the new record (even while records are being inserted into the table). It appears that DELETES won't work while records are being inserted (1.5 million records per day). Is there a way around this (which I'm assuming at this point is a contention issue)? The INSERT uses the NOPARALLEL hint; no hints on the DELETE.

View 7 Replies View Related

PL/SQL :: Perform DML Or DDL When Select Query Is In Progress?

Aug 27, 2012

Is it possible to perform a DML or DDL when a select query is in progress?

View 8 Replies View Related

How Much Data Written On Tape On In-progress RMAN Backup

Oct 6, 2011

db environment: 11g
recovery catalog: 10g

I am trying to find if there is a way to know how much data has been written on tape on a 'in progress' rman backup. rman session is also connected with recovery catalog.

is there a way to find-out how much data is transferred per rman channel onto tape? what is backup speed we are getting?

View 1 Replies View Related

Application Express :: Progress Bar While Loading Slow Page

Jul 24, 2012

I am still having issues with my progress bar while loading a heavy popup page(not modal). I got this to work but i came to realize for very fast internet/network environment you cant see the icon at all, the page stays blank for 30secs then loads the data but no icon/progress-bar appears but at least i can see icon very short interval whenever i use wifi / slower connection.

How can i make this progress bar starts immediately i click button to popup the called page? I also tried this plugins 1

[URL].......

but doesn't seem to work,
2)this seems to work for very short interval in slower internet/network connection only==>
templ df header:

<div id="loading" style="display:block;position:fixed;top:0px;left:0;z-index:1999;width:100%;height:100%;background-color:#fff;text-align:center;">
<div style="position:relative;top:130px;">Wait..loading..</div><img src="#WORKSPACE_IMAGES#AnimatedProgressBar.gif" style="position:relative;top:150px;"/></div>
footer:
<script>$(document).ready(function(){ $('#loading').hide()});</script>

in apex 4.1.0x/oracle 11g Enterp.

View 2 Replies View Related

Application Express :: Show Progress Bar While Only On Page Load?

Nov 13, 2012

I want to show progress bar every time when page loads.

Progress bar is coming on the page. but it is not going off after page is loaded.Below is the code which i added for the Progress bar.

//written on Header Text of Page
<script type="text/javascript">
<!--
function html_Submit_Progress(pThis){
$x_Show('AjaxLoading');
window.setTimeout('$s("AjaxLoading",$x("AjaxLoading").innerHTML)', 100);
}

[code]...

I want only to show only page loads.

Apex Version : Apex 4.1
DB Version : 10g

View 2 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

How To Know Database Shutdown Without Monitoring

Nov 23, 2010

The Database is Shutdown, no user is complaining about it and also you are not monitoring it through alert log file, then how will you, as a DBA, come to know about it?

View 2 Replies View Related

Forms :: 10g Abnormal Shutdown

Nov 8, 2010

I am having a problem with Oracle forms 10g Version 9.0.4.0.19. Whenever I am trying to generate a from it is giving the following windows error message 'Oracle Forms Designer has encountered a problem and needs to close. We are sorry for the inconvenience'. What could be the possible reasons for this?

This is happening for a particular form. I tried it in other machines, but getting the same error. I am able to generate other forms in my machine without any problem. I am using windows XP Service Pack 3 and have a memory of 2GB. I am connecting to database Oracle9i (9.2.0.1.0)

View 6 Replies View Related







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