My database is working on Oracle 10g. After installing a Oracle 11g in my PC instance went down and my database got corrupt. What are the steps I should follow to recover my Database?
View 2 RepliesI have an issue with restoring a RMAN backup that i have with me to a new database instance. What i have with me are: 1. Backup of SPFile.
(O1_MF_NCNNF_CTLFILE_BU_92DVGYO2_.BKP)2. Backup of Control file (O1_MF_NNSNF_SPFILE_BU_92DVGW9H_.BKP)3. Full database backup (O1_MF_NNSNF_FULLPROD_BU_92DVGW9H_.BKP)
I have received these files from a customer environment and I need to restore these to a new database instance in a local machine. I have given a attempt as follows (in Oracle 10g): 1, Created a new database instance (Test75) using Oracle Database Configuration Assistant2. SET ORACLE_SID = Test753. Connected to this instance using RMAN4. Tried to restore the SPFILE from the received BKP file.I am getting errors and cannot proceed. I am not sure whether I am executing the correct steps.
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 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 RelatedI need to make my database to ARCHIVELOG mode when i try it it gives below following error
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
we have a running Oracle 8i in NT 2000 since year 2004, now we have a new Machine onto which we install a fresh copy of OS and also fresh Installation of Oracle. but..i want to have all those settings, users, database as it is running. i am creating regular dumps of the current database running.
View 4 Replies View RelatedI am doing an experimental setup of Siebel Servers in Linux . For this , i had installed Oracle 11gR2 x64 db in OEL 5.4 x64 , and created a db instance 'oracle'. But , i am not able to tnsping to the db (installed on the same machine).
PSB o/p..
[oracle@localhost ~]$ source oraenv
ORACLE_SID = [oracle] ?
The Oracle base for ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1 is /home/oracle/app/oracle
[Code].....
Had started up the db successfully using 'startup' command in the sql prompt.
I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?
View 1 Replies View RelatedI'm have in Oracle version Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production:
while enter in a command
$emctl status dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Oracle Enterprise Manager 10g is running.
----------------------------------------------------------------------------------
$emctl stop dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
-----------------------------------------------------------------------------------
$emctl start dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
-----------------------------------------------------------------------------------
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
i have installed grid(crs+asm) on my two linux node(Enterprise linux 5) setup, using openfiler(SAN) , i have configure grid Home like ORACLE_ HOME=/ u01/ home/app/11.2.0/grid.
1) i don't get any instance specific asm parameter file like init+ASM1.ora instead of that i got ab_+ASM1.dat, hc_+ASM1.dat, init.ora, orapw+ASM four files, do i need to create ASM instance specific parameter manually to create diskgroup in the same location,
2) +DATA diskgroup has been created while grid installation, but when i try to create database, its giving me error diskgroup +DATA doesn't exit or not mount, but when i check it shows me mount like below $cd $ORACLE_HOME/dbs (here oracle home is grid home)$export ORACLE_SID=+ASM1$sqlplus / as sysdba>select name,state from v$asm_diskgroup; name state DATA Mounted even i cant able to dismount diskgroup DATA, it throws an error insufficient privilege.
3) After grid installation how can one create diskgroup i mean what needs to exported as ORACLE_SID like in 10g we have $export ORACLE_SID=+ASM1 then creat diskgroup.
i have a problem when i try to login to oracle...i found this message error.
ora-01033 oracle initialization or shutdown in progressafter i logged on with / as sysdba...i did the following
SQL> shutdown immediate;
ORA-01507: database not mountedORACLE instance shut down.
SQL> startup mount;
[code]....
We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.
View 2 Replies View RelatedGive me a link where i can download Oracle Database 10g for AIX?
View 4 Replies View RelatedI want to replicate an Oracle instance from one Server to another one. On server 1 Oracle is running with instance TEST02 in archive mode. I have to backup this instance while it is running active and in use by multiple users working in our ERP-System. Now I want to backup alle stuff I need (database, archivelogs, rodlogs?) into another instance TEST03 running on another Server to have a fallback solution. This backup I would like to repeat every 2 hours to have always a copy of Server 1 TEST02 on Server 2 TEST03
Any script how to do this Job(s)? (I know how to connect to instance by *.bat but in internet I did not find the useful statement(s) how to backup / recover the complete instance.
During rollback phase of instance recovery, where is the undo applied from:
- redo logs
or
- undo generated during redo application in roll forward phase?
I want to install any version of Oracle database in my laptop IBM Lenovo Y450 64 bit, but i have win 7 home, how to install it in win 7 home edition, one main thing i don't have money to upgrade it to windows 7 ultimate,
View 3 Replies View Relatedi want to create auxiliary instance for remote database.how i will create .how many instance can be open at a time and what is actually instance.
View 7 Replies View Relatedwe have given shutdown abort to a database.At the next startup SMON process will do instance recovery. If it contains committed as well as uncommitted transactions on what basis or how the SMON process will roll forward or rollback the transactions and from where it will get these informations or data?
View 4 Replies View Relatedwhere to download - Oracle database client(32-bit) 11.2.0.3 for windows 7 ?
View 5 Replies View RelatedI am planning to use Data Guard facility in Oracle 10g database.
1) I would like to have a standby database, which can be used if the primary goes down and also for reporting and other queries (read-Only).
2) What is the difference between Physical and Logical standby database. I have to explain non-technical users (management) regarding this.
3) What is Sync and Async redo log apply?
4) When i manipulate data (Insert,Delete,Update) in logical standby database, will these changes reflect in Primary database synchronously?
5) Which type of REDO APPLY is better: Managed Recovery Process(MRP) or Real Time Apply(RTA)?
6) can the redo data be deleted if its obsolete or is it deleted automatically by oracle?
7) If i want to take backup, should i take it from primary or standby database? If standby, then the database should be in which mode (Read-only or Recovery Mode)
Can i have 2 versions of oracle database installed on same server under one user on AIX also on windows,
Currently we have oracle 10.2.0.4.0 installed on AIX server, can we install oracle 11gR2 on the same server under on user, & both the versions will be in use.
How to manage the profile of the user having 2 oracle versions on AIX & on windows how to handle it.
Yesterday i installed oracle 11g r2 by default i installed database Oracle with the installation .but today i tried to create the database with the name green tat also completed successfully..the problem is in startup
export oracle_sid=green
sqlplus '/ as sysdba'
startup
database mounted
select instance_name from v$instance; But it SHowing the instance name as Oracle...i tried with the other method also
export oracle_sid=green
sqlplus /nolog
conn sys/b123 as sysdba
database mounted
select instance_name from V$parameter;
and it shows instance name as green..i tried to see the datafile location for green database
select file_name from dba_data_files; it shows the orcl datafile locations.
Is Oracle Database 11g Release 2 (11.2.0.3.0) available for IBM AIX on POWER Systems (64-bit), Or do we need to upgrade 11.2.0.1 to 11.2.0.3.0.
View 4 Replies View RelatedI 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 installed the Oracle database following the this link .
1.Downloaded 11g express edition
2.Created a new user 'oracle' under the group dba. Following steps are executed using this.
3.unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package
sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
4.Created /sbin/chkconfig file and added the entries as specified here
5.Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.
6.Below steps:
ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener
7.sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)
8.sudo /etc/init.d/oracle-xe configure (left the default values as it is)
9.Set the following env variables in ~/.bashrc file
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
[code]....
Now when exectute any SQL statements on SQLplus, i end up with the following error
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
I have increased the swap memory as specified in here
free -m
total used free shared buffers cached
Mem: 3901 3428 473 0 182 1988
-/+ buffers/cache: 1258 2643
Swap: 5066 0 5066
On production server i have the production database and i have another instance for recovery catalog database.and on DR server i have only one instance for production database .In the scenario of recovery,
- i did export for recovery catalog user
- i have latest rman backup for production database
On the DR server as i mention up , i have only on instance , my question is , i need to create another instance for recovery catalog user to import it ? or on the same target database on DR i can import the recovery catalog ?
I have installed Oracle virtual box on windows host and have created Oracle Linux virtual machine as guest. I have installed the database server on my host machine but rest of the things(Peoplesoft peopletools etc....) on Oracle Linux guest.Now, I am trying to installed database client on guest machine which is Linux so that I can connect to DB server running on host, but having difficulties in doing so.
, I am following the installation instruction given in the doc docs.oracle.com/cd/E11882_01/install.112/e24322.pdf, but when I finally run command runInstaller.sh doesn't happen anything.Actually, to install other software's I just double clicked the .sh file and it automatically started the installation process on a terminal window but when I clicked runInstaller.sh to install DB client, it didn't do anything.
Also, when I run the same command runInstaller.sh from command line after navigating to the directory where this file is present, It throws me error saying "no command found".By the way, why the steps given in doc are so complex, I wish If I could just double click runInstaller.sh just like others and it start the installation process.
OS=Redhat 5
Oracle=11gr2
Grid=11gR2
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.
O/S: Windows 7 64-bit
DB: Oracle XE 11g2 32-bit
APEX: 4.0.2
=============
Trying to upgrade APEX within an Oracle XE database installation on Windows 7. The version of APEX that came with Oracle XE is 4.0.2. Trying to upgrade to 4.1.1 and, from the SQL*Plus command-line (ie. the 'Run SQL Command' tool which comes with Oracle XE), I try to run @apexins.sql.
It starts to run momentarily, then the MS-DOS windows just closes. Can not find any install log to determine the cause.