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