How To Create Instance Using Database Template File
May 8, 2012how to create database instance using database template file(.dbt) while running DBCA?
View 1 Replies
ADVERTISEMENT
Enterprise Manager :: Unable To Apply Monitoring Template On Database Instance
Sep 13, 2011I have to apply monitoring template on my databases. Databases are already added and configured into OEM. They are visible under Databases tab and also under Groups where I have added them.
But when I try applying monitoring template and look for database in search window, it doesn't appear there.
Template File Used In Database Creation?
May 15, 2012I 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 RelatedPL/SQL :: Oracle SQL Template To Create Re-usable DDL / DML Scripts For Oracle Database
Jun 13, 2012I 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.
Error In Identifying Control File / Database Not Mounted ORACLE Instance Shut Down
Nov 21, 2012i 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]....
Forms :: Migrating 6i With 11i Template To R12 Template
Apr 20, 2010We have many customized forms built on 6i (11i Template) and deployed to EBS 11i, We want to Upgrade to R12, what shall i do with the customized form which already applied to 11i Template ?I know i have to migrate 6i to 10g then deploy, but my problem in the Template, shall i remove 11i Template and apply R12 Template from the beggining?
View 4 Replies View RelatedSpecify Existing Template For Database Creation
Nov 7, 2013During 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.
Client Tools :: Create MDD File - Database Designer
Jun 5, 2013I heard .MDD file is Database Designer for MYSQL(i don't knw exactly).how to create it..
View 1 Replies View RelatedServer Utilities :: How To Create Control File To Insert Data In Our Database
Dec 21, 2011how to create control file and how to load the data through command window in our database using sql * loader.i am having structure in my database and .csv file in my desktop.
View 20 Replies View RelatedEnterprise Manager :: Create A Standby Database - File Locations ERROR
Nov 12, 2010I have this message when I try to create a new standby database.In the others targets I don't have it..Some database file locations are empty. Please specify locations for all database files.
If I try to customize ... I have the same error.
Data Guard :: Create Control File With Standby Keyword On Primary Database
Jul 4, 2012What is difference when you issue a create controlfile with "standby" keyword on the primary database
ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/path/db_stby.ctl';
vs. creating a control using
ALTER DATABASE BACKUP CONTROLFILE to '/path/db_control.ctl';
what does ORACLE put into the standby control that is "extra"? ie. what is the difference between a standby control file and a normal control file?
Server Administration :: How To Create ASM Instance Using DBCA
Jul 15, 2010I am learning to create an ASM (Automatic Storage Management) instance using dbca.
View 3 Replies View RelatedBackup & Recovery :: How To Create Auxiliary Instance
May 13, 2008i 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 RelatedBackup & Recovery :: Create Another Instance For Catalog User To Import It
Jan 13, 2013On 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 ?
RMAN :: Clone 2 Node RAC Database To Single Instance Non-RAC Database Using Existing Backup
Jul 25, 2012I tried to clone a 2 node rac database to single instance non rac database using existing backup. I have not used connectivity to target or catalog. rman duplicate finished with below messages:
rman auxiliary sys/******@dbracdup
RMAN> duplicate database to dbrac spfile backup location '/oracle/backup';
...
...
Finished recover at 25-JUL-12
Segmentation fault
And the database was in mount stage, and when i tried to open database it failed with below error:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-19838: Cannot use this control file to open database .
Is It One Alert Log Per Instance Or One Per Database
Jul 28, 2010Is it one alert log per instance or one per database? My guess would be per instance, but I have some documentation that indicates per database.
View 4 Replies View RelatedCan't Able To Connect To Local Database Instance
Oct 31, 2012I cant able to connect to my local DB instance. Oracle service for DB instance will be started running when the system boots automatically.I faced this problem before, I was instructed to boot my system without network connection. It worked for few days. Suddenly I cant able to connect to my local DB instance again, even though I am booting my system without network connection.
This is the configuration I have in tnsnames.ora in my local machine.I have the host as localhost, because local machine is laptop and IP will change periodically.
CSS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CSS)
[code]....
JDeveloper, Java & XML :: Create XML File From XSD File?
Dec 14, 2010get me an example where i create a XML file from a xsd file?
View 1 Replies View RelatedData Guard :: Possible To Use Dataguard From Single Instance To RAC Instance?
Jul 1, 2010Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?
View 1 Replies View RelatedServer Administration :: How To Get Disk List On Any DB Instance That Uses ASM Instance
Mar 16, 2011My context on our servers is the following one:
- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks
On each DB instance you can see:
- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view
So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?
Oracle 11g Installation - Database Instance Recovery
Oct 16, 2010My 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 Replies View RelatedEnterprise Manager :: Can't Configure 11g R2 - Database Instance Not Available
Dec 12, 2010I've checked ALL the parameters. It seems to be OK.The db is running and OK.But when I try to configure the EM I get the following error Says that the databse instance is not available.But, tnsping works ok, and I can connect as sys without problems. the DB is OK.
EMCA iniciado en 12-dic-2010 12:54:17
Asistente de Configuraci¾n EM, Versi¾n 11.2.0.0.2 Producci¾n
Copyright (c) 2003, 2005, Oracle. Todos los Derechos Reservados.
[code]....
RAC & Failsafe :: Single Instance - Migration To Database
Oct 20, 20102 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.
RAC & Failsafe :: Database Instance Using Srvctl Command
Aug 13, 2013Would 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
Enterprise Manager :: Failed To Connect To Database Instance
Oct 27, 2011When login i'm getting error : Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin).
I have checked DBCONSOLE & AGENT are running properly.
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_SID=infoddp
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOME=/opt/oracle/product/11.2.0
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOSTNAME=liteningv
litening:/opt/oracle/product/11.2.0/bin>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
[code].....
RAC & Failsafe :: Query On Dependency Between Database Instance And Service?
Jul 8, 2013suggest on the dependenecy between the database service and the database instance?
srvctl start instance -i db1
will this start service as well for which the above instance is either preferred or available instance?
will it start the listener as well?
srvctl stop instance -i db1
will this stop service as well for which the above instance is either preferred or available instance?
will it stop the listener as well?
srvctl start service -d db -s dbserve
will this start service as well for which the above instance is either preferred or available instance?
srvctl stop servive -d db -s dbserve
will this stop service as well for which the above instance is either preferred or available instance?
srvctl start database -d db
will it start instance, listener and service as well?
srvctl stop database -d db
will it stop instance, listener and service as well?
Database Instance Cannot Be Startup / Status / Failed ORA-12505
Jul 19, 2012I 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]....
Cons Of Running 8 Production Database Instance On One Windows Server
Dec 3, 2010We are planning to consolidate our Oracle Production DB into one server. We are basically a windows shop. Is it feasible to run 8 production Oracle DB in one windows server. All the DB are not really transaction intensive DB. 2 DB in the size of 300GB and others all DB falls under average size of 40GB.
I can take care of the HD slicing so Oracle does not enter into IO bottleneck. We are planning to go for external NAS or SAN for storage.
My main concern is on processor usage. The processor we are thinking about is Intel Xeon Quad Core x 2nos. Will there be a processor bottleneck or is there way in Oracle to assign processor usage(I belive there is no much tweaking options here)
Server Administration :: Install Oracle 11.2.0.2 Single Instance Database On AIX 6.1?
May 4, 2011I 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 RelatedRecovery Manager (RMAN) :: Restoring A Backup To A New Database Instance
Sep 4, 2013I 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.