While I was trying to configure an Oracle DB called "NW6" using the Database Configuration Assistant, I have Oracle 11.2 database installed on a Windows 2008 Server, the configuration wizard thrown an error : ORA-01507:database not mounted
So I am not able to successfully complete the DB configuration. Also I tried to test the service using the net configuration assistant, it throws an error: ORA-27101 shared memory realm does not exist.
I'm trying to create a physical standby database on my Oracle9i DB runing on WinXP.
Note: I have both Primary and Standby on the same system.
Actually everything went well .... I did created the standby DB but the problem is I can not start my primary DB if my standby DB is mounted. I get this error:
ORA-01102: cannot mount database in EXCLUSIVE mode
And when I read about the error message I learnt that I should start my DB in compatible mode ...
I recovered dbf and ctl files, how to mount that database again. Using oracle 9i.
View 1 Replies View Relatedwhich commands only we can use in database mount mode?
View 7 Replies View RelatedHow i create Standby Database in Same HOST, we using SUN OS 5.8.
I read form Oracle DOC that i can create Standby Database in Same HOST and follow the tutorial , but when i try to mount standby database using ALTER DATABASE MOUNT STANDBY DATABASE EXCLUSIVE; i got a error message ORA-01102: cannot mount database in EXCLUSIVE mode
I performed Shutdown Immediate in Oracle 8I and now I am unable to mount the database.I'm getting the following message: ORA-01102 Cannot mount database in Exclusive mode/I only have one database running on this machine. It was automatically created by Oracle installer upon installation of Oracle software. I can no longer connect via SQL * Plus,Only through Server Manager (connect internal)
View 8 Replies View RelatedI 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.
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:oracleproduct10.2.0oradataPrimDBData',
StandBy Datafiles='E:StandBy_DBData'
PrimDB Control Files='F:oracleproduct10.2.0oradataPrimDBControl'
StandBy Control Files= 'E:StandBy_DBControl'
[code]....
Step 1 Create the Oracle Service for StandBy DB "StBy1DB' and Create the Standy DB Password file.
ORADIM -NEW -sid StBy1DB -intpwd passwd -startmode manual
Step 2 Shut down the primary database.
SQL> SHUTDOWN IMMEDIATE;
Step 3 Copy the datafiles to 'E:StandBy_DBData'. (including Temp01.dbf is it Right?)
Step 4 Restart the primary database.
Restart the primary database:
SQL> STARTUP;
Step 5 Create a Control File for the Standby Database (Should this command be given in Mount Status or Open Status?)
From Primary database,
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'E:StandBy_DBControlStByControl01.ctl';
Step 6 Prepare the Initialization Parameter File to be Copied to the Standby Database
SQL> CREATE PFILE='E:StandBy_DBPFileinitStBy1DB.ora' FROM SPFILE;
Step 7 Set Initialization Parameters on a Physical Standby Database
db_cache_size=444596224
java_pool_size=4194304
large_pool_size=4194304
shared_pool_size=150994944
streams_pool_size=0
[code]....
Now When I type the following command, it throws an error:
SQL...> alter database open;
alter database open
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
We have one primary oracle database 10.2 and standby by database with no data guard. Initially we have 2 redo log group in primary and standby database.
We have recently add 2 more redo log and increase the size of log member from 50m to 200m in primary database. We don't have any problem in primary database.but in standby database we face a problem because we cannot open it. It always in mount stage in which . How we change the size of current redo log because we can't run. Alter system switch logfile command in mount stage.
i am not able to mount my database created today. I uninstalled the RDBS software and all peoplesoft database content to start from a fresh again. But now i am not able to mount my DB. I am working on 11g. The error is -
SQL> startup
ORACLE instance started.
Total System Global Area 744910848 bytes
Fixed Size 1374696 bytes
Variable Size 226493976 bytes
Database Buffers 511705088 bytes
Redo Buffers 5337088 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 2192
Session ID: 5 Serial number: 1
SQL>
I started database in mount state;startup mount; alter tablespace users offline;
I tried to make tablespace offline In another case online but showing error database not open same for command alter tablespace begin backup; do think we can make tablespace offline in mount...
I am configuring RAC with two nodes. I have mapped iscsi targets successfully. I am unable to mount the ocfs2 filesystem.
mount -t ocfs2 -o datavolume,nointr -L "oracrsfiles" /u02
When execute the above command, it displays the follwing error:
ocfs2_hb_ctl: Device name specified was not found while reading uuid
mount.ocfs2: Error when attempting to run /sbin/ocfs2_hb_ctl: "Operation not permitted"
i encoutered lately on such statement:
Table D-7 shows a hierarchical file mapping of a sample OFA-compliant installation with two Oracle home directories and two databases. The database files are distributed across three mount points, /u02, /u03, and /u04. URL....
why three mount points (/u02, /u03, and /u04) for datafiles? don' understant this. isn't it better to store all datafiles in one mountpoint?
We are Using ACFS File system for DBHOME and its Called "/u01/app/oracle". I would like to know, can i use RMAN to backup my oracle home?
View 4 Replies View RelatedI want to shutdown the database using shutdown immediate and startup the database using startup mount.
1.)My system is client system if I connect start--> program -->Accessories --> communication --> Remote Desktop connection (connect server system) , open Run type cmd after
Shutdown immediate (database is shutdown)
Startup mount (database is mounted no problem it's working fine)
2.) But if I, open Run type cmd in client system If I run same command, I'm getting below error (ORA-12560: TNS:protocol adapter error).
C:>set oracle_sid=dbadb
C:>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on ╘± ╠ß± 31 18:09:27 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
[code].....
3. If I run same command in Sql Plus I'm getting below error(ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).
SQL*Plus: Release 10.1.0.2.0 - Production on Ôñ Ìáñ 31 18:23:13 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
[code].....
We are configuring NAS device on linux for RAC installation.
ISSUE: I had mounted NAS device to Linux server.As root user I can create directory but cannot change owner of cifs mount.It say permission denied.When I try to change permission it doesn't work.The mount point show the uid and gid as 33 and permissions drwxr-xr-x
I had mounted using the following command
#mount -t cifs storage:/ocr1 /u02/ocr1 -o username=XXXX,password=XXXX,uid=oracle,gid=dba
Permission denied
[root@SSIPL-WRKST-116 u02]# chown -R oracle:dba ocr1
chown: changing ownership of `ocr1': Permission denied
chown: changing ownership of `ocr1/ss': Permission denied
[root@SSIPL-WRKST-116 u02]#
Change owner
[root@SSIPL-WRKST-116 u02]# ls -lrt
total 0
drwxr-xr-x 3 33 33 0 Dec 4 2006 ocr1
[root@SSIPL-WRKST-116 u02]# chmod -R 777 ocr1
[root@SSIPL-WRKST-116 u02]# ls -lrt
total 0
drwxr-xr-x 3 33 33 0 Dec 4 2006 ocr1
[root@SSIPL-WRKST-116 u02]#
I am in need to find archive log mount point space detail usage through sqlplus on multiple instance. Is there any view in oracle which can give me the detail.
I know one method using external table but that is cumbersome for RAC.
can i get some command like this.
select inst_id,mountpoint,space_usage,space_available,total from GV$table --> returns
I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.
I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?
1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site
i want to convert oracle database(schema data) to postgresql database
which tool would be best and url to download and steps to convert from one database to another ?
Can we use M.S Sql Server Database with Forms 6i with out oracle database install.
View 1 Replies View RelatedI'm trying to migrate a mySQL database into an Oracle database.
View 7 Replies View RelatedBut i do a lot of work-arounds to make sure the installation does not make corrupt my OracleAgent,OracleService and OracleDataGatherer. If i just let the installation do its thing i have problems with my libraries, and can't start anything.
The errors are : Procedure entry point 'BlaBla' could not be located in the Dynamic Link library 'AnyName'.
I notice that i have 2 versions of the libraries in OracleHomeBIN (one version 8, one version 11). The programs that start the OracleAgent,Service and DataGatherer call the old libraries but expect to find values that can be found only in new libraries.
I have a requirement to put together a Oracle SQL template to create re-usable DDL/DML Scripts for Oracle databases.Only the Oracle DBA will be running the scripts so permissions is not an issue.
The workflow for any DDL is as follows:-
1) New Table
a. Check if the table exists from the system/admin views.
b. If table exists then give message "Table Exists"
c. If table does not exist then execute DDL code
2) Add Column
a. Check if Column exists for a given table from system/admin views
b. If column exists in the specified table,
b1. backup table.
b2. alter table to make changes to the column
b3. verify data or execute dml script convert from backup to the new change.
c. If Column does not exist
c1. backup table
c2. alter table to add column
c3. execute dml to populate column with default value.
The DML scripts are for populating base tables with data required for business operations.
3) Add new row
a. check if row exists by comparing old values of each column with new values to be added for the new record.
b. If exists, give message row exists
c. If not exists, add new record.
4) Update existing record (We have createtime columns in these tables so changes can be tracked)
a. check if row exists using primary key.
b. If exists,
b1. deactivate the record using the "active" column of the table
b2. Add new record with the changes required.
c. If does not exist, add new record with the changes required.
When I installed Oracle 11.g I set 'GlobalDataBaseName' ("orcl.net").SID was "orcl". from where can I invoke 'GlobalDataBaseName' value ?
View 1 Replies View RelatedI'd like to get database redundancy with Oracle Standard Edition One. currently have one physical database server and are considering getting a second physical database server.
What's the best way to achieve that without going to Oracle Standard Edition using RAC?
Actually I am using Oracle 9i in Windows Operating System. Now I want to move to my entire Oracle Database to Oracle 11g in Linux version. What are all the correct steps to do this. I am not a DBA.
View 1 Replies View RelatedIn my Production server, Database size increased very high due do to logs generated in a table called "Process Activity". And the table size is 50GB.
We deleted the data from the table "Process Activity". And still the table size and Database size remain same. Space not released by DB. One of my friend, recommended me to sync the oracle DB to release the space. how to synchronize the DB to release space.
I have the following question:
I try to duplicate a database on Host B with ORACLE_SID=hostb from an offline full backup plus archive log backup was taken from Host A with ORACLE_SID=hosta. Host A and Host B cannot communicate between them.
I don�t want to make a full restore of database, i want to make a duplicate database from that offline backup.
I need the duplicate database must be run with different ORACLE_SID and different DBID.
PD: I was reading the Oracle Documentation about that but i can�t find a step by step guide to follow.
Environment
Oracle 11gr2 with a Linux OS on x86_64 on host A and host B.
I need download the Oracle 10g to do some migration tests, but isn't not available in oracle website.
View 1 Replies View RelatedI would like to develop a system with Oracle 9i as the database and PHP 4/5 as the front end. I am not able to establish the connectivity to the database. What should I do now ?
View 3 Replies View RelatedI have a Database of My all customers Mobile Nos I want to send SMS to all customer from Oracle Database using Pl/SQL or any inbuilt Oracle Package, if available or through Oracle forms
How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed .