Shutting Down Database Getting Error

Aug 20, 2012

while i am shutting down the database, i am getting below error message.

SQL> shutdown immediate;
ORA-01116: error in opening database file 170
ORA-01110: data file 170: '/x01/CQ_Request/ORADATA_FILE/otlmedium_data08.dbf'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3

and also i know otlmedium_data08.dbf file is not exist in that location. how can i overcome this error and shutdown the database.

View 4 Replies


ADVERTISEMENT

Reports & Discoverer :: REP-50002 / Server Is Shutting Down?

Oct 27, 2013

we have a strange problem we running some reports from inside a customized application when we run the report we got that error

REP-50002: Server is shutting down

N.B there exists some reports that are working fine

View 2 Replies View Related

Reports & Discoverer :: Server Is Shutting Down / When Starting Up

Aug 17, 2011

I want to start up a reports server by executing the command "rwserver server=<server_name> start" via the windows command line. The status shows that the server is starting up but, the next second the status shows "Server is shutting down"

View 2 Replies View Related

Server Administration :: DB Shutting Down Automatically By Terminating Smon Process

Dec 22, 2010

I have a db on 10.2.0.1 and it's going down automatically after some time with the error in alert log file smon process terminating.

View 3 Replies View Related

Control Existence Shared Library In Memory Space To Define Real Need Of Shutting Down Of All Oracle Instances

Feb 7, 2013

according to article "Installing Netbackup for Oracle agent on Unix". URL.... Shut Down all oracle instances on this client. The reason: sometimes Oracle will take a shared library (such as ours) and place it into its shared memory spaceMy question is how I can control existence shared library in memory space to define the real need of Shuting down of all oracle instances ? I'm usung 11.2.0.3

View 4 Replies View Related

RMAN :: Error - Register Database With Catalog Database

Mar 4, 2013

I have created database with 11.2.0.3 in RHEL 5. I have catalog database(RMAN) with version 10.2.0.1 and 5 databases with different versions(10.2.0.1,10.2.0.3,10.2.0.5) registered with this catalog databases.

Now I want to register the 11.2.0.3 database with catalog (RMAN) database.

Am getting error while I register :

#rman target / catalog=rman/rman@rman

connected to target database: TEST (DBID=12345678)
connected to recovery catalog database

RMAN> register database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 03/04/2013 10:27:12
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 1: ORA-04023: Object RMAN.DBMS_RCVCAT could not be validated or authorized

View 9 Replies View Related

Error While Trying To Import Database?

Jul 3, 2012

i try to import MyData.DMP to my oracle using PL/SQL developer

i try this: Tools -> Import tables -> i choos MyData.DMP -> import

but i can see the new database in the log file i see this:

Import started on 03/07/2012 13:43:23
C:\app\ME\product\11.1.0\db_1\bin\imp.exe log=C:\DOCUME~1\ME\LOCALS~1\Temp\plsimp.log file=C:\DOCUME~1\ME\lab.DMP userid="scott/tiger@ORCL as sysdba" buffer=30720 commit=no full=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes
Import finished on 03/07/2012 13:43:23

View 4 Replies View Related

SQL & PL/SQL :: After Server Error On Database

Oct 12, 2012

I have a DBMS_JOB which fails due to unique constraint error while doing fast refresh. I wrote a After server error on database trigger to take backup of M$LOG file whenever unique constraint error occur.

Problem

Q1)If error is being logged in alert log then After server error on database trigger doesn't trigger. so no backup,
Is this a normal behavior because i was under the impression that if any error in DB occurs then "After server error on database " will catch it?

If i manually try to do fast refresh it works fine

Q2) Is there any other way in Oracle to counter such issue?

View 1 Replies View Related

Error While Starting Up Oracle Database

Jul 17, 2010

when i start the Oracle database, the database is mounted. Then when i issue the "alter database open resetlogs" command, i got the below error.

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oracle/NYP15S1D/data03/SYSTEM_01.dbf'

So i added the parameter "_allow_resetlogs_corruption=TRUE" in "init.ORA" file to force open the database but the Oracle instance crashed with following message.

In the alert log the following error is there:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4000], [2], [], [], [], [], [], []

How can i resolve the issue?

Please note: the database is Oracle 9i, installed in UNIX AIX OS.

View 1 Replies View Related

SQL & PL/SQL :: Getting Error When Try To Insert Values Into Database

Nov 25, 2011

I am trying to insert values into my database but it keeps coming up with the same error message: 'not enough values'

Here's what am I trying to do:

This is the insert I am having trouble with.

INSERT INTO Customers
VALUES (000120, 'Andy', 'Finnigan', 'M', '23/JUL/1978',
Address_varray_type
(Address_type('Home', 76, 'Fun Way', 'Semilong', 'NORTHAMPTON', 'NN3 8YF'),
Address_type('Work', 54, 'Region Street', 'Halfache', 'OXFORDSHIRE', 'OX4 7EG'),
Contact_table_type
(Contact_type('Non_work hours', '07659485743', '02084731131', 'AFinnigan@yahoo.com'),
Contact_type('Work_hours', '07795052846', '0768543323', NULL))));

Here are the Object tables.

CREATE TYPE Address_type AS OBJECT(
Location VARCHAR2(20),
House_number NUMBER(6),
Street_name VARCHAR2(30),
Town VARCHAR2(20),
County VARCHAR2(20),
Postcode VARCHAR2(20));
/

CREATE TYPE Contact_type AS OBJECT(
Contact_type VARCHAR2(30),
Home_no VARCHAR2(20),
Mobile_no VARCHAR2(20),
Email VARCHAR2(50));
/

CREATE TABLE Customers(
Customer_id NUMBER(6) NOT NULL,
Firstname VARCHAR2(20),
Familyname VARCHAR2(20),
Gender CHAR DEFAULT 'M',
DOB DATE,
Address address_varray_type,
Contact_details contact_table_type)
NESTED TABLE Contact_details
STORE AS customer_contact_table;

View 1 Replies View Related

SQL & PL/SQL :: Database Connector Error ORA-24338

Apr 18, 2012

We have a Crystal report which calles a stored procedure using cursors. One of the tables in the stored procedure has been changed to a view which has GRANT access for the connecting user. When the report is run I get a failed to connect to database error message.

View 1 Replies View Related

Getting Ora-24010 Error In Target Database?

Dec 13, 2011

I am getting ora-24010 error in the target database where I am configuring the apply process, DB is 10.2.0.1 on RHEL

SQL> conn strmadmin/strmadmin@db2
Connected.
SQL> begin dbms_streams_adm.add_table_rules
2 ( table_name => 'scott.test',
3 streams_type => 'apply',
4 streams_name => 'apply_stream',

[code]...

The capture process and the propogation rule and scn instantiation on the source were executed fine withut issue, I am having problem in the apply process.

View 2 Replies View Related

XE :: Database Configuration Failed Error?

Jun 27, 2013

Running a Dell x86_64 machine using CentOS 6.4 Install using the command: rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpmOracle XE installs without any errors.

 However: When during database configuration we get the Database Configuration failed error The logs all show similar errors, here's a snippet: Create controlfile reuse set database "XE"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0    BEGIN dbms_backup_restore.zerodbid(0); END;  *ERROR at line

1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0    ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directoryORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=1q6xlf1.bcohome.bco.com)(PORT=1521))'Create controlfile reuse set database "XE"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0    alter system enable restricted session*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0    alter database "XE" open resetlogs*ERROR at line 1:ORA-01034: ORACLE not available

View 2 Replies View Related

While Creating Database - Installation Error?

Jan 30, 2013

while creating database*(windows server 2008 R2 version and 11g r2)*

1.DIIM ERROR OCCURS
2.then i started all the oracle services on
3.then igot ora-01092:oracle instance terminated disconnection forced
4.ora-00450:background process'qmnc' did not start
5.ora-00444:background process"qmnc" failed while starting
6.ora-maximum number of process 0 exeeded

View 18 Replies View Related

Error Database Connection Closed?

Jan 29, 2013

I am gettting error message databse connection closed itried

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

[code]...

View 10 Replies View Related

Sqlplus Error While Connecting To Database?

Mar 13, 2013

after connecting to database using username and password , i get below error message connection is established and able to work asusal,

Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
select 'Welcome to database: ' || name from v$database
*
ERROR at line 1:
ORA-00942: table or view does not exist

View 8 Replies View Related

Error 1455 / Export Full DATABASE

Dec 13, 2012

I am trying to export a full DATABASE using the command...EXP [username/password]@[CS]FILE=PATH\[filename.dmp] LOG=PATH\[logname.log] INDEXES=n STATISTICS=none COMPRESS=Y

the database begins to export as shown below, but the export terminates with the below error.

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user [username]
. exporting PUBLIC type synonyms
. exporting private type synonyms
[code],,,,

considering that i have exported full databases successfully before using the mentioned command above.

View 9 Replies View Related

Error While Backup And Restore Database To New Host?

Jul 22, 2011

I have 2 server install oracle : server 1 and server 2

server 1 run database DB01

i use rman backup DB01 ( this command : BACKUP FULL DATABASE PLUS ARCHIVELOG DELETE INPUT; ) and move ( The database backup pieces , Controlfile backup piece, The parameter file i.e init.ora file) to server 2 .

At server 2 :

After start database with init.ora file and restore controlfile error :

RMAN-03002: failure of restore command at 07/22/2011 02:56:04
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

View 1 Replies View Related

Stats Gather Error On Production Database

Aug 27, 2012

I got following error when i am gathered stats on Schema level.

SQL> EXEC dbms_stats.gather_schema_stats(ownname=>'KDB', estimate_percent=>dbms_stats.auto_sample_size,cascade=>TRUE, force=>TRUE);
BEGIN dbms_stats.gather_schema_stats(ownname=>'MFDB', estimate_percent=>dbms_stats.auto_sample_size,cascade=>TRUE, force=>TRUE); END;
*
ERROR at line 1:
ORA-20003: Specified bug number (9196440) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 15342
ORA-06512: at "SYS.DBMS_STATS", line 15688
ORA-06512: at "SYS.DBMS_STATS", line 15766
ORA-06512: at "SYS.DBMS_STATS", line 15725
ORA-06512: at line 1

SQL> EXEC dbms_stats.gather_schema_stats(ownname=>'CDC_DATA', estimate_percent=>dbms_stats.auto_sample_size,cascade=>TRUE,DEGREE=>10);

BEGIN dbms_stats.gather_schema_stats(ownname=>'CDOMIG_DATA', estimate_percent=>dbms_stats.auto_sample_size,cascade=>TRUE,DEGREE=>10); END;
*
ERROR at line 1:
ORA-20003: Specified bug number (9196440) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 15342
ORA-06512: at "SYS.DBMS_STATS", line 15688
ORA-06512: at "SYS.DBMS_STATS", line 15766
ORA-06512: at "SYS.DBMS_STATS", line 15725
ORA-06512: at line 1

View 5 Replies View Related

Loading Date Value Into Database Using Sqlldr - Error?

Sep 22, 2008

I am having a problem loading the date value into database using sqlldr.

The nls_date_format is 'DD-MM-RR' from nls_database_parameters and no date format for nls_instance_parameters.

I am getting ORA-01722: invalid number, the format that i used in ctl file is column_name date 'DD/MM/YYYY'

View 5 Replies View Related

Server Administration :: Error In Creating Database

Feb 17, 2010

I have created a database in Oracle10g which is working fine. Now when I try to create another the system gives the following error.

ORA-12560: TNS protocol adapter error.

View 8 Replies View Related

Server Administration :: Getting Error When Start Database 10g

May 4, 2010

I start my database and suddenly got this error:

ORA-00371: not enough shared pool memory, at least 72102521958 bytes

How to fix? I use startup command only and shutdown when shutdown the database.

View 2 Replies View Related

Unable To Restart Database - Not Logged On Error

Jul 30, 2012

I just shutdown the database and it seems to take a while, don't know if it's stuck or just takes awhile. I try to restart it in another session and get this error:

'ORA-01012: not logged on'

1) Shutdown
SQL> connect sys/Welcome1 as sysdba
Connected.
SQL> shutdown normal
_

2) So I try to restart it as sysdba on another session and get this error
Connected to an idle instance.
SQL> startup
ORA-01012: not logged on

View 4 Replies View Related

Forms :: 10g On 9i Database - Protocol Adapter Error

Jun 5, 2010

l oracle 9i database , and then i install oracle 10g forms, and now when i run my form through browser ,it gives me following error message ..

ORA-12560 :TNS: Protocol Adapter Error

View 1 Replies View Related

EMCA Error - Database Unavailable Exception?

Jun 7, 2012

I have installed Oracle 11gR2 on Windows 7 professional. I created a DB and a listener also.No issues there; I can connect to the DB with sqlplus and SQL Developer.when I try to configure dbcontrol on this DB, it fires errors;

--------------------------------------------------------------------------------------------
C:Windowssystem32>emca -config dbcontrol db

STARTED EMCA at Jun 7, 2012 2:20:15 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: ORA112
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableExcep

[code]...

How this can happen?

View 3 Replies View Related

Database Creation With DBCA Fails With Error?

Apr 8, 2013

While Creating database on AIX Machine using DBCA utility I am getting following error

Error Details:
-------------------------------------------------------------------------------------------------------------------
Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...

[code]....

View 2 Replies View Related

Error While Datapump Export Backup Of Full Database

Sep 5, 2012

One of my Friend gets error While datapump Export backup of Full database.

Pfa below error details:-

ORA-31693: Table data object "RADIOMIRCHI_PIP_HRMS"."GM_DEPT" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-21780: Maximum number of object durations exceeded.
[code]......

View 1 Replies View Related

Data Guard :: Error While Connecting Standby Database

Apr 19, 2011

During data guard configuration i have receive an error while connecting to stanby database from primary database rman prompt.

rman target sys/srk786@orcli
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 19 09:59:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCLI (DBID=3754068166)
RMAN> connect auxiliary sys/srk786@stnd
[code]....

View 1 Replies View Related

Enterprise Manager :: Error Start Database Control

Sep 4, 2013

I have a problem when I install oracle 11g: I did an installation on a win2008 r2 server and everything works fine, I did another installation on another server in the same network as a test, but at the end of the installation I get an alert that says:

start database error control .....
Executing set oracle_unqname and then emctl start dbcontrol.
of course nothing happens.

dbcontrol_nome the service instance will not start. checking the file in your home directory I always acts everything is in place. I reinstalled windows to eliminate all the checks made​​, repeated installation and here appeared the same problem.

question: can exist 2 oracle installations on the same network with the same name db? I currently have two installations of the same name with oracle db 10

View 3 Replies View Related

Server Administration :: Database Creation Manual Error

Sep 16, 2011

i am creating database manually in oracle 9i os version ibm-aix5.3 it showing following error

CREATE DATABASE "varathu"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/backup/varathu/control01.ctl'
ORA-27040: skgfrcre: create error, unable to create file
IBM AIX RISC System/6000 Error: 13: Permission denied

View 18 Replies View Related







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