XE :: OracleXE Version 11g R2 Installation During Database Startup
Sep 24, 2012
I am new user using oracle XE. During the installing process, all see is Ok, but, when database is over startup process, the process NOT RESPONDING, and i don't know the cause.
My environment
Hardware: NOTEBOOK HP Genuine Inter (R) CPU
T2500 @ 2.00GHz
1.66 GHz, 2 GB of RAM
SO : Windows XP with services pack 3
Installation flow implement:
1. Download Oraclexe from oracle site
2. The installation & configuration process finish succeful, but when el flow are in startup point and i treat to login
the login step give me the next message:
ERROR:
ORA-01089: Immediate shutdown in progress - no operations are permitted
Process ID:0
sESSION id: 0 Serial number: 0
I Hope about 5 hours and the message is the same, while when i hope about 5 hours.
View 7 Replies
ADVERTISEMENT
Oct 15, 2010
We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.
if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.
Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.
View 3 Replies
View Related
Nov 14, 2013
what is the recommended "LINUX" version for 12c cloud controller installation?
View 0 Replies
View Related
Jul 25, 2012
OS=Redhat LINUX6
DB=Oracle 11.20.1
Get the following error when installing Oracle. I have java version "1.7.0_05" and based on the log, it appears that Oracle is trying to install the binaries using an older version of java (1.5.0).
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0x00000030b7014d70, pid=2615, tid=140142440847120
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_17-b03 mixed mode)
# Problematic frame:
# C [ld-linux-x86-64.so.2+0x14d70]
#
View 7 Replies
View Related
Mar 16, 2013
I am configuring Grid Infrastructure 11g2 on node A, one of two cluster nodes, and getting the following message:
[INS-40916] Single-instance versions of Cluster Synchronization Services (CSS) are detected.
I executed runInstaller and installed software-only on both A and B nodes. It apparently the other node has already CSS instance running, and maybe caused by the installation.I remove the software from A first?
How do I stop CSS on the node A, and let the configuratoin to continue on this node B
View 2 Replies
View Related
May 15, 2011
I tried to login and start my db this evening and I receive the following message
[oracle@dbs]$ export ORACLE_SID=ORCL
[oracle@ukedxdtmtdbs01a dbs]$ sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Sat May 14 19:59:48 2011
Copyright © 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
How can I resolve - none of the passwords I enter seem to work? I have these init files
ls -ltr init*.ora
-rw-r--r-- 1 oracle oinstall 2867 May 14 18:53 init.ora
-rw-r--r-- 1 oracle oinstall 2867 May 14 19:12 initORCL.ora
my init.ora file looks like this:
db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/adump'
audit_trail ='db'
[code]...
db had been up and running for about 2 weeks with no issues since installation..I am just trying to get the db up and running - nothing more
View 14 Replies
View Related
Jan 5, 2012
We are having a problem trying to automate our 11g database startup on a Linux Platform (Redhat). This is the procedure we followed.
1. Logged in as the root user.
2. Edited the oratab file for the platform.
vi /etc/oratab
db:/u01/app/oracle/product/11.2.0/dbhome_1:Y
3. Create a file called dbora in /etc/init.d directory
4. Entered the following in dbora:
#! /bin/sh -x
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[Code] .....
4. Changed permissions of dbora
chgrp dba dbora
chmod 750 dbora
5. Created symbolic links to the dbora script in the appropriate run-level script directories:
# ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora
Have I covered everything needed? At system restart the listener and database fail to startup as expected.
View 4 Replies
View Related
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
Apr 27, 2010
MY oracle database is not starting ,at startup its giving me following error message .
ORA-00600: internal error code, arguments: [kccext_info_4], [], [], [], [], [],[], []
Alert Log file showing following message ,
Tue Apr 27 14:22:26 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Apr 27 14:22:26 2010
ARC1: Becoming the heartbeat ARCH
Tue Apr 27 14:22:26 2010
db_recovery_file_dest_size of 2048 MB is 36.88% used.
This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Tue Apr 27 14:22:27 2010Errors in file h:oracleproduct10.2.0adminorcl4udumporcl4_ora_3704.trc:ORA-00600: internal error code, arguments: [kccext_info_4], [], [],
[code]...
If i connect with scott user ,following message occurs ,
ORA-01033: ORACLE initialization or shutdown in progress
View 2 Replies
View Related
Feb 14, 2013
the db cannot startup after host crash.
the strange thing is "lkinstrdmetdev" is the wrong name(sid is rdmetdev), and the file does not exist in the FS too. the correct file name should be "lkrdmetdev" and i've deleted this file from the directory. I did not do any changes. and no any oralce processes running while i started up the oracle instance.
Thu Feb 14 09:25:20 EST 2013
sculkget: failed to lock /u01/app/oracle/product/10.2/dbs/lkinstrdmetdev exclusive
Thu Feb 14 09:25:20 EST 2013
sculkget: lock held by PID: 272600512
Thu Feb 14 09:25:20 EST 2013
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
Thu Feb 14 09:25:20 EST 2013
Failed to acquire instance startup/shutdown serialization primitive
[code]....
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/ shutdown serialization primitive
View 17 Replies
View Related
May 7, 2013
Any example of database startup event and database shutdown event?
View 2 Replies
View Related
Jun 20, 2011
im new to DBA.i installed oracle on my pc but im not able to startup database...im manually creating database ..CRD files r still not created as im unable to startup nomount..im getting this error.
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
i almost worked on this for 10 days but im getting the same error...
View 39 Replies
View Related
Jul 19, 2012
I am running ORACLE 10.2.0 on Windows Virtual PC. System: Microsoft Windows XP SP3.
Yesterday I wanted to make a copy of my Virtual Machine Hard Drive Image. I directly copied all the files to my external hard drive, but I forgot shutting down my virtual machine when I was doing this.
Today I found my instance failed startup.
In OEM, it is showing:
Agent Connection to Instance
Status: Failed
Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
In SQLPlus:
SQL> connect sys/password as sysdba
Connected to an idle instance
SQL> startup
ORACLE instance started.
[code]....
View 3 Replies
View Related
Mar 20, 2013
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?
View 3 Replies
View Related
May 6, 2013
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).
View 10 Replies
View Related
Jun 24, 2010
Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.
View 1 Replies
View Related
Feb 8, 2011
I successfully created a DB manually with PFILE.
I want the DB to startup with SPFILE at next login.So i fired the below command.
CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.
But it shows the error as below:
ORA-01078: failure in processing system parameters
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.
View 20 Replies
View Related
Aug 15, 2013
I have doubts on export
1.) If we have taken exp (traditional export)of schema�s on database version 10.2.0 then shall we imp(traditional export) on database version 11.2.0?
2.) If we have taken expdp of schema�s on database version 10.2.0 then shall we impdp on database version 11.2.0?
3.) If we have taken exp(traditional export) of schema�s on database version 10.2.0 then shall we impdp on database version 11.2.0?
View 6 Replies
View Related
Aug 24, 2012
Oracle 11.2.0.1 and 11.2.0.3.
Can rman refresh database from 11.2.0.1 to 11.2.0.3?
In another words, my source database is 11.2.0.1, my target database is 11.2.0.3
I want to refresh target database from source database. Is it ok since version is different?
View 6 Replies
View Related
Jun 3, 2010
I have a report of version 10g . I want to run this report in oracle reports 6i version.
View 1 Replies
View Related
Jun 24, 2012
I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in Linux 32 bit . I faced the version incompatibility error during patch set installation and hence ran the patchset installation with -ignoresysprereqs option.
Now during the patchset installation i encountered the below error in in the install logfile.
**************************************
INFO: Start output from spawned process:
INFO:
--------------------------------------------------------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/bin/genclntsh
INFO: genclntsh: genclntsh: Could not locate /u01/app/oracle/product/10.2.0/network/admin/shrept.lst
INFO: make:
INFO: *** [client_sharedlib] Error 1
INFO:
INFO: End output from spawned process.
INFO:
--------------------------------------------------------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/network/lib/ins_net_client.mk'. See '/u01/app/oracle/oraInventory/logs/installActions2012-06-24_11-45-11AM.log' for details.
Exception Severity: 1
***********************************************
Provide me the certified os and versions for oracle db 10gr2
View 2 Replies
View Related
Mar 30, 2012
I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?
View 4 Replies
View Related
Feb 1, 2013
What database version is supported as a repository for 10g OMS?
View 5 Replies
View Related
Jun 21, 2011
what does mean VERSION_TIME column in V$DATABASE;i know that there is an other column which is called CREATED which indicates when the database has been created and i think it will never change,but, what about VERSION_TIME ? when does it change ?
View 6 Replies
View Related
Feb 22, 2011
what version of java is supported by Oracle Database 10g and 11g. Actually i am writing a User Defined Function in Java and was asking this question to know which version of java i need to compile the source file before uploading the jar.
View 2 Replies
View Related
Feb 6, 2010
i have a oracle server installed enterprise edition, for some reation i need to degrade the version from enterprise to standard
i need same tablespace,data's everything same as of now.
View 8 Replies
View Related
May 10, 2012
I have Windows 7 (System Type - 64-bit OPerating System & ACPI X64 PC Type) and want to install Oracle Database.
The compatible version with the above operating system and send me the direct link for downloading.
View 17 Replies
View Related
Nov 16, 2012
how many rows created (replaced ?) und stored in v$object_usage on each fact of index scan? I'm using 11.2 version of database server
View 7 Replies
View Related
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
Jul 28, 2013
How to know the version of Oracle and JDBC of remote databases that is accessing my database through DBLInk.
For example I have a database A , B database is using my database Through a dblink.Now I want to know the version of oracle and jdbc which working on B.
View 4 Replies
View Related
