RAC & Failsafe :: Database Creation Hangs - RAC On SP2 On AIX-4.3.3?

Jan 17, 2003

Creating RAX 9.2.0 on SP2-AIX-4.3.3 64 bit hangs (2 node configuration) tablespacess are on VSD/raw partitions.

View 3 Replies


ADVERTISEMENT

Database Hangs On Performing Logswitch

Oct 16, 2012

Iam usin 11.2.0.3 database on linux 64 bit machine

I have got the report from the users that the dataload operation which they perform in the database is taking normal than the expected time

I rebooted the server and started the database i can see that the database startup is even taking more time

The memory allocated is sufficient and when i tried to perform the logswitch the database simply hangs

alertlog contents after restart
---------------------------------------

minact-scn: useg scan erroring out with error e:12751
Tue Oct 16 11:02:03 2012
minact-scn: useg scan erroring out with error e:12751
Suspending MMON action 'Block Cleanout Optim, Undo Segment Scan' for 82800 seconds
Tue Oct 16 11:12:47 2012

Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of ASHSIZE to a sufficiently large value. Currently, ASH size is 50331648 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query:

select total_size,awr_flush_emergency_count from v$ash_info;
Tue Oct 16 11:17:53 2012
Suspending MMON action 'undo usage' for 82800 seconds
Tue Oct 16 11:28:05 2012
Suspending MMON action 'metrics monitoring' for 82800 seconds

View 3 Replies View Related

Database Hangs In Shutdown Immediate For Cold Backup

Jan 28, 2013

we have scheduled cold backup for our database. is there any solution to resolve below mentioned errors other than RMAN hot backup or shutdown abort ?

Sat Jan 26 00:20:55 2013
Active call for process 3939 user 'oracle' program 'oracle@proddb.fgho.com'
SHUTDOWN: waiting for active calls to complete.

Sat Jan 26 01:15:59 2013
SHUTDOWN: Active sessions prevent database close operation
Instance shutdown aborted

View 9 Replies View Related

Data Guard :: Archiver Hangs When Standby - Database Is Not Available

Oct 10, 2013

we have two primary databases (Oracle release 9.2.0.8, HP-UX 11.31) installed on the same server. The corresponding standby-databases (Oracle release 9.2.0.8, HP-UX 11.31)are configured on one server, too.It happens once in a while that the server of the standby-databases struggles and performs a shutdown. The primary- and standby-databases are configured with Data Guard. If the server of the standy-databases is not reachable anymore that should not really cause any problems,meaning that both primary databases can be used as usual. One of our primary database behaves like this: the applications can connect to the database and work like as expected. The other primary database behaves different: the applications can't connect anymore. But the database is still up and running. When looking at the alert.log file the following messages can be found:

Fri Oct  4 03:19:51 2013ARC1: Evaluating archive   log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372      Log actively being archived by another processFri Oct  4 03:20:51 2013ARC1: Evaluating archive   log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372      Log actively being archived by another processFri Oct  4 03:21:51 2013ARC1: Evaluating archive   log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372      Log actively being archived by another process Fri Oct  4 03:22:51 2013ARC1: Evaluating archive   log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372   Log actively being archived by another processFri Oct  4 03:23:51 2013ARC1: Evaluating archive   log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372      Log actively being archived by another processFri Oct  4 03:24:51 2013ARC1: Evaluating archive   log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372     

Log actively being archived by another process Trying to connect to the database is not possible - the database seems to be busy with something... We have two archiver processes for each primary database. One process of the primary database which can't be reached anymore seems to hang. Executing the command SQL> alter system archive log all;seems to run forever. Instead of shutting down ands starting the instance killing one of the archiver-processes solves the issue. Maybe some of you have made the same experiences? I do not understand why the one database doesn't have any issues (which is expected behaviour) but the other database is not reachable anymore due to some issue with the archiving process.

View 5 Replies View Related

VNC Hangs While Installing 11.2.0.3.0 After Giving Finish Button To Install Database

Sep 20, 2012

My VNC Hangs after completing all the steps in dbca while installing 11.2.0.3.0 after giving finish button to install database.

Completed All software installation.

Red Hat version: Red Hat Enterprise Linux Server release 6.2 (Santiago)

Linux xxxxxxx.xxxxx.net 2.6.32-220.el6.x86_64 #1 SMP Wed Dec 7 10:41:06 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

View 3 Replies View Related

SQL & PL/SQL :: Database Link Creation

Jan 28, 2013

I have installed oracle database 11gr2 in laptop1 and installed oracle database 11gr2 in laptop2.Both the laptop's are connected to same internet connection through wifi. So my question is can i create a database link between these two databases using this wifi? give some steps in creation of a database link.

View 13 Replies View Related

Template File Used In Database Creation?

May 15, 2012

I am having a template file (only .dbt file) to create the database instance.I Kept it in $ORACLE_HOME/assistant/dbca/template/,after running DBCA it was loaded with details mentioned in it ,but at the second last step when i try to see initialization parameters control file ,datafile and tablespace detail was not mentioned.when it started database creation ,got hanged on 5% completion showing failure in processing system parameters. Is it the right way to create database using DBCA?what should I do to create database using template?

View 1 Replies View Related

SQL & PL/SQL :: Database Creation Manually In Oracle?

Dec 21, 2011

when i connected with oracle user i got error message like "

ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"

View 1 Replies View Related

SQL & PL/SQL :: Creation Of A Object Relational Database

Feb 25, 2012

i am working on a project that requires the creation of a object relational database. A number of different methods are required in order to insert different toy types into the appropriate toy related Object Table(s). Within this there will be the following fields:

Toy_name
Cost
Age_Range
rdy_allocation

and then some more specific information. The specific information for each toy is:

Toy_Type.
The toy_type can be electronic, game, or wooden.
For electronic I need to store Battery_Type and Number_of_Batteries.
For type Game, I need to store, Type, this could card_game, board_game or other_game.
For type wooden, I need to store Painted(Y/N).

The toys are requested by a child and created by elfs. This information also needs to be recorded but im more concerned with the creation of the toy class itself first. Now this was my first attempt at the solution but I cant seem to link the specific toy information into the same table. Will i have to create three separate tables then link them together?:

DROP TABLE TOY_OBJTAB;
DROP TYPE electronic_toy;
DROP TYPE wooden_toy;
DROP TYPE board_toy;
DROP TYPE toy_typ;
[code]....

View 9 Replies View Related

Specify Existing Template For Database Creation

Nov 7, 2013

During the database installation the two nodes after all the prerequisite check and copy of files i am getting the below error message 

"Template4 General_Purpose.dbc does not exist. Please specify an existing template for database creation". 

How can i overcome this error ? I am installing Oracle 11g R2 11.2.0 On Oracle Enterprise Linux (5.1.19) running on [Oracle Virtual Box 4.1.12 ]. Also what are the steps to uninstall the previously installed db_home1 which failed due to this error. 

View 1 Replies View Related

ASM Disk Groups Creation After ASM Instance Creation

Jul 9, 2012

During ASM Disk Groups creation after the ASM instance creation, receive the following error: Disk Group ORAASMGROUP2 already exists. Cannot be created again

The Grid infrastructure was deinstall one time and still the same issue.

View 4 Replies View Related

Server Administration :: Manual Database Creation

Jan 21, 2011

manual DB creation.I gone through the below steps:

1) created appropriate folders.

2) Copied a PFILE from an existing DB and changed the contents like DB name etc...

3)Then I Created a text file called %ORACLE_HOME%DATABASEinitmuktha.ora with the following contents: ifile=c:pragpfileinitmuktha.ora

4) Then i set Oracle SID (Through Environment variable in MY COMPUTER --> PROPERTIES...)

5) Then I Created a Windows service for the DB.

6) startup nomount pfile= c:pragpfileinitmuktha.ora

7) Then I ran the database creation command.

The DB was created but when i log in again, it is looking for the pfile in the another DB's location rather than from "%ORACLE_HOME%DATABASE". Where i missed out to create new oracle_home folder?

View 6 Replies View Related

Create Dictionary Tablespace Creation In 10g Database?

Nov 5, 2012

Is it possible to create Dictionary Tablespace creation in 10g database?

View 5 Replies View Related

RAC/ASM Clusterware Installation :: Database Creation Crashed

May 29, 2013

I try to install RAC with 2 nodes OEL 5.8.

GI 11.2.0 is installed...The installation of the database crashed in dbca.

When I tried to rerun, I got: PRCD-1121: Speciffied server pool RAC for RAC is already hosting an administrator-managed configuration for database(s) RAC

View 3 Replies View Related

Data Guard :: Creation Of Standby Database

Dec 7, 2010

I was able to create the standby database on different server with the same name for the primary and standby database but I want to know that can I create a standby database with different database name than that of the primary database server.

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

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

SQL & PL/SQL :: Difference Between File Catproc That Run After Creation Of Database In Oracle 9i /10g / 11g R2

Aug 18, 2010

I want to know what is the difference between the file catproc that we run after creation of the database in the Oracle 9i,10g and 11g r2. I have run that file in 11g R2 but it is taking more time and more over there are many new things that i saw in 11g R2 than what were there in 9i and 10g.

View 11 Replies View Related

Server Administration :: Manually Oracle Database Creation?

Feb 21, 2013

how to create database manually(without dbca).

View 2 Replies View Related

Server Administration :: TNS Error - DBCA After Database Creation Script Complete

Aug 15, 2010

I'm getting a "TNS disconnect" after database creation script creation in DBCA. Haven't figured out what's going on. I'm attempting to create a 2nd database on one linux 64 server. I get all the way through DBCA, but it won't go the final mile. Any thoughts? I've tried setting the port to a different port from the existing LISTENER, creating a LISTENER2 and associating it with the 2nd instance.

View 1 Replies View Related

RAC & Failsafe :: Difference Between RAC And Non-RAC Database

Sep 13, 2012

Tell me the difference between Oracle RAC and Non RAC database including commands and architecture?

View 4 Replies View Related

RAC & Failsafe :: Startup Sequence 10g RAC Database With ASM?

Dec 28, 2012

I want to restart a 10g database on ASM ? startp and shutdown sequence?I would like to shutdown everything including database, ASM and cluster and startup again

I read at various places but not sure of the sequence For database DB with database instance DB01 and DB02 having ASM instances ASM01 and ASM02 on node1 and node2, I understand following would be the sequence

1)
Login as root on node1
cd $CRS_HOME/bin
./crsctl start crs

2)
Login as root on node2
cd $CRS_HOME/bin
./crsctl start crs

3)
login as oracle on node1
$ORACLE_HOME/bin/srvctl start nodeapps -n node1

4)
login as oracle on node2
$ORACLE_HOME/bin/srvctl start nodeapps -n node2

5)
login as oracle on node1
start ASM instance on node1
$ORACLE_HOME/bin/srvctl start asm01 -n node1

6)
login as oracle on node2
start ASM instance on node2
$ORACLE_HOME/bin/srvctl start asm02 -n node2

7)
Start oracle database (from any node)
$ORACLE_HOME/bin/srvctl start database -d DB

A. confirm if the above sequence is correct?
B. This sequence if corrrect, is same for 10g and 11g?
C. Is shutdown sequence exact reverse of the above?

View 9 Replies View Related

RAC & Failsafe :: JDBC Connection To A 10g Database?

Mar 30, 2005

The problem i mentioned in my last posting "CRS installation/PRIF-10: failed to initialize the cluster registry" was due to the fact i was using Redhat Linux 9 that seems to have some missing packages. I installed White Box RH 3 and everything worked fine.

if it's possible to connect to a 10g RAC database using the jdbc java thin client. the java thin client requires an ip, and database sid. I am running a two node cluster and i have two ip's and a service name that uses TAF option.

View 5 Replies View Related

RAC & Failsafe :: Can Create Directory On Two Node Database

Feb 2, 2013

here we have san server and rac database two node database.i want to know how can i create directory on rac database. i know how to create directory on single database but i do not know how can i create directory on rac database.

View 3 Replies View Related

RAC & Failsafe :: Single Instance - Migration To Database

Oct 20, 2010

2 Database.

TP1 Database - Oracle RAC 11g (2 Node)
TP2 database - Single Instance

Is it possible to migrate from RAC to Non-RAC(Single Instance)?

Our requirement is, 3 Oracle Schemas@TP1(having DW data) we need to move it to TP2 Database.

View 4 Replies View Related

RAC & Failsafe :: Srvctl Stop Database D Devdb1?

Jul 21, 2011

srvctl stop database d devdb1

After that i got this below status .how to make it up Steup by steup procedure

crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.devdb.db application ONLINE ONLINE islr...v345
ora....b1.inst application ONLINE ONLINE islr...v333
ora....b2.inst application ONLINE ONLINE islr...v345
ora....dbap.cs application OFFLINE OFFLINE

[code]...

View 2 Replies View Related

RAC & Failsafe :: Upgrade Of Oracle And Standby Database In HP UX

Mar 9, 2011

we had our Oracle RAC database at primary and Standby database as DR. It was running in 10g (10.2.0.1.0) in HP UX 11i platform.

We need to upgrade both the setups from 10.2.0.1.0 to 10.2.0.4.0 . I will go through the upgrade guide, i like to know is there any special case for upgrading when we do for both primary and standby database.

And whether i need to create a new Oracle home with 10.2.0.4.0 software or i can upgrade in the same oracle home which already exists.

View 2 Replies View Related

RAC & Failsafe :: 5 Node Database - Services Management

Aug 17, 2012

We have 5 node RAC database. I want to user 2 node for OLTP and 3 for DSS system. Guide now to create service for the requirement.

View 10 Replies View Related

RAC & Failsafe :: ORA-01033 On One Node But Database Is Started

May 23, 2012

we encounter a problem with a 2-nodes RAC with 11gR2 SE : Database RAC is correctly running but we encounter problems using RAC TNS entry, obtaining the message ORA-01033.We can access to the DB using a TNS entry using each one of IP addresses but when we use the SCAN address, it fails. 2 weeks ago RAC2 node could connect perfectly with the SCAN address but RAC1 (used as a client) obtained error message almost 30% of tries.

We made a reboot of RAC1 node and now SCAN address works correctly from RAC1 and RAC2 (used as a client) fails systematically with SCAN address but works perfectly with direct access to the database.On both nodes, SCAN address is perfectly resolved by DNS server, cluster seems correct, listeners seems correct...We have opened an SR on Metalink 4 weeks ago but we don't progress.

View 4 Replies View Related

RAC & Failsafe :: Database Instance Using Srvctl Command

Aug 13, 2013

Would there be any issue in application and database when i down RAC database instance using below srvctl command ?

srvctl stop instance -d DB -i DB1
srvctl start instance -d DB -i DB1

View 18 Replies View Related







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