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
I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).
I am getting a ORA-03114 (not connected to Oracle) error when I am creating a DB using DBCA. Here are the steps that I do:
1) Log onto the server remotely, using Exceed Query 2) Connect as the oracle user (Oracle) 3) set ORACLE_HOME, PATH 4) Run DBCA, give parameters
At around 12% and again at 19%, I get the error (see screenshot). I also tried to generate the scripts and run them remotely, and the steps run successfully upto & including the step " startup nomount pfile="/oracle/admin/<dbname>/scripts/init.ora"; ". After that, when I try to run the script specified in rmanRestoreDatafiles.sql from SQL> prompt, the error appears, and connection to ORACLE is lost.
Googling the error shows that it is a connectivilty issue, and Oracle says that it is usually caused by user scripts. But I am not running any user-created scripts as part of the DBCA process. Somehow, the instance is timing out immediately after doing the "startup nomount".
I am trying to create the Physical StandBy Database in the same server. Till last 2 Final steps, everything went on well. In the final steps, when I try to open the StandBy Database, it throws the following Error:
******************************************************* SQL...> alter database open; alter database open * ERROR at line 1: ORA-01154: database busy. Open, close, mount, and dismount not allowed now
I tried creating the Physical Standby with the following Steps.into that & tell me whether I have done any mistake.Also tell me any step I have missed from the following list of steps:
Environment: Oracle Release 10.2.0.1.0 / Windows 2003 Server Enterprise Edition SP2 Primary DB = 'PrimDB' StandBy DB to be created = 'StBy1DB'
In the same Server, location for PrimDB datafiles = 'F:\oracle\product\10.2.0\oradata\PrimDB\Data\', StandBy Datafiles = 'E:\StandBy_DB\Data\'
[code]...
ERROR at line 1: ORA-01154: database busy. Open, close, mount, and dismount not allowed now
I have downloaded and install oracle server6 and followed the
[URL].......
but i am getting error as follows
./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 42983 MB Passed Checking swap space: must be greater than 150 MB. Actual 7951 MB Passed Checking monitor: must be configured to display at least 256 colors Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation, Continue? (y/n) [n] n
User Selected: No
I have tried #export DISPLAY=localhost:0.0 #export DISPLAY=localhost:0.0 xhost: unable to open display "localhost:0.0"
I am trying to install Oracle Database 11gR2 database on Oracle Grid 11gR2. I successfully installed Grid without errors. However, when installing the database, I got an OLR Integrity error during the prerequisit Check
OLR Integrity - This test checks the integrity of OLR on the local node. Expected Value : n/a Actual Value : n/a List of errors: - Permissons of file "/u01/app/oracle/product/11.2.0/grid/cdata/localhost/localhost.olr" did not match the expected value. [Expected = "0600"; Found = "0660"] - Cause: Cause of Problem Not Available - Action: User Action Not Available.
My question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...
I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.
So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...
That is for express version only.
My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?
I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
error creating db ORACLE error from recovery catalog database ORA-01552: cannot use system rollback segment for non-system tablespace 'TS' ORACLE error from recovery catalog database:ORA-00942:table or view doesnt exist
creating the standby database from Active database using RMAN and getting the below issue after i executed the duplicate command.
Version of Database:11g(11.2.0.1.0) Operating System:Linux 5 Error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 12/21/2012 17:26:52 RMAN-03015: error occurred in stored script Memory Script RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [code]....
provide any work arounds to proceed further in creating the standby database.
i have a union all query (two quiries i suppose) that runs fine and returns the results i am after.... when i try to use this query to create a view I get
SQL Command: CREATE OR REPLACE FORCE Failed: Warning: execution completed with warning
CREATE OR REPLACE FORCE VIEW "schema1"."name_of_view" ("column1", "column2", "column3") AS SELECT b.column1, a.column2, c.column3
I am creating prim and phy standby on same WIN machine. I have done with all settings. I can do TNSPING to both oracle_sid.I am trying to connect as sysdba to UP the phy standby. But it gives below error:
Enter user-name: sys as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error
So i tried creating password file for phy standby. But gives below error:
Unable to find error file %ORACLE_HOME%\RDBMS\opw<lang>.msb
I have this requirement to pull the ACTIVE days that a participant holds true in a given month for a specific position he/she holds.The three date ranges here are: LOA dates(leave of absence), XFER dates(TRANSFER in/out of the position),Quality compliance(QUAL start/end dates).So,
INACTIVE DAYS = [(LOA + XFER + WW) - OVERLAPPING DAYS OF (LOA+XFER+QUAL)] CREATE TABLE PAYEES ( RUN_PERIOD DATE NOT NULL, PAYEEID VARCHAR2(20 BYTE) NOT NULL, LOA_START_DATE DATE, LOA_END_DATE DATE, [code]....
I am able to pull out the no of days on a individual basis(count of days for Xfer/LOA/Qual) but I am really not sure as to how should i go about determining the overlapping days between 3 date ranges to determine the ACTIVE/INactive days.
When trying to create package I receive this error...[Error] PLS-00103 (8: 16): PLS-00103: Encountered the symbol "." when expecting one of the following:;
pointing to "." in the last line "END nondrg_prod.Readmissions;"
CREATE or replace PACKAGE nondrg_prod.Readmissions AS TYPE Readmits IS REF CURSOR RETURN READMISSIONS_DATA_MH%ROWTYPE; PROCEDURE open_rdmh (rdmh IN OUT rdmhCurTyp); END Readmissions;
H want to Create a view which reside in one instance for example xxx Instance . I want to create the same view which reside in xxx instance to another instance for example YYY Instance How to acheive this ?I tried desc the View take the view script from XXX instance and copied the view script to YYY instance when I compiled Iam getting an Error
For Example My view in XXX Instance CREATE OR REPLACE FORCE VIEW xxx.sample ( First_name, last_name ) as select "F_NAME", "L_NAME" FROM EMP;
When try to copy and compile the same view in my YYY Instance i am getting error
I have a question. If i insert some values to a table and then write a create statement. But if the create statement gives me error (eg: table name already exist). And without commiting if i come out the session will the insert commit?
I am trying to create two tables and I am getting the "ORA-00911: invalid character" Error. I have been trying to work it out for last past 30 minutes to no success.
we have the following requirement for creating materialized view.
In database "DB1", a table "abc" is there in "user1" schema. In database "DB2", in "user2", we are accessing the "abc" through DB link "DBL1" to DB1: select * from user1.abc@DBL1; we have created a public synonym for "user1.abc@DBL1" as "sabc".
In database "DB3", we need to create the materialized view to access "abc" in DB1 through DB2. we are not allowed to access "DB1" directly from "DB3". so we create a db link as "DBL2" in "DB3" to "DB2".
when i try to create a materialized view as below: create materialized view abc_mv as select * from sabc@DBL2;
But got the error as "synonym translation invalid". When i access the SQL statement separately as below select * from sabc@DBL2, its working but in Materialized view, it shown that error. Even i tried with schema name as well like "user2.sabc@DBL2" , but that also thrown same error.
Is there any option available for this type of creating materialized view?