DBCA To Create Database In 11g?
Oct 28, 2011I was using DBCA to create database in 11g. It goes to the last step ,but was not able to show up database creation screen. I am running it on AIX.
View 1 Replies
ADVERTISEMENT
Create Database With DBCA
Aug 16, 2013Why there is default table such as AQ$_INTERNET and other table when I create database with DBCA I want to create commplete blank database
View 4 Replies View RelatedRAC/ASM Clusterware Installation :: Create 11g Database On Linux Using Dbca
Jun 20, 2012I was trying to create a 11g database on linux using dbca.
At very end "create database" I got 'The file pach +DATADG/orcl/system01.dbf in invalid. Check the permissions.'
How to check the permission?
Automatic Storage Management :: 10.2.0.1 RAC - ASM Created - DBCA Could Not Create Database
Jul 30, 2012I am using 10.2.0.1 on OEL5. I have installed CRS, Oracle home, ASM on both nodes and everything is fine.
When invoked dbca to create a database, it says:
*'DBCA could not startup the ASM instance configured on this node. To proceed with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?'*
Is it a bug? because some blogs say this is a bug. And patch 8288940 will solve this. They also say this patch is to solve the incompatibility between 11g ASM incompatibility with 10g. But here I am using everything of 10.2.0.1.
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 RelatedWindows :: Oracle 10g - Creating New Database / DBCA?
Jun 15, 2011when i am trying to create a new database in oracle 10 g in my local system when creating database error shows a number 146 no other error is showing what must be the reason.
View 14 Replies View RelatedServer Utilities :: Database Installation Using ASM In DBCA
Mar 6, 2010I have installed asm lib and asm instance has started successfully and is working if i am using
EXPORT ORACLE_SID=+ASM
but if I am using DBCA after that to create database on ASM activated disk group I am having problem in creation of spfile. How to follow steps to create database using already installed /mounted disk group with DBCA.
Enterprise Manager :: DBCA Does Not Recognize Database
Mar 28, 2010On our test database server, we restore a copy of the production database from the rman backup. The process worked well and we could connect and do the processing with sqlplus, or any other third party tools like Toad.
Strange enough, Database Configuration Assistant (DBCA) does not recognize it. So if we like to drop the database from the DBCA, it is not there. Also we could not get the DBCONSOLE to work with.
The all powerful command: emca -repos recreate generates a list of errors.
Database Creation With DBCA Fails With Error?
Apr 8, 2013While Creating database on AIX Machine using DBCA utility I am getting following error
Error Details:
-------------------------------------------------------------------------------------------------------------------
Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
[code]....
Backup & Recovery :: Clone Database Name Not Showing In Dbca
Aug 20, 2012i have just create a clone database. it work very well.but when i open the dbca to delete this database.it not show in dbca prompt. why ?
View 4 Replies View RelatedServer Administration :: ORA-01078 While Creating Database Using DBCA?
May 10, 2011I installed Oracle 11gR2 withouth creating a database in my laptop. Later when I tried to crete the database using DBCA it shows error ORA-01078:failure in processing system parameters.I clicked on ignore error, then shows the error ORA-01034: Oracle not available.
View 4 Replies View RelatedServer Administration :: Unable To Delete A Database Using Dbca?
Sep 17, 2012I am trying to delete a database using dbca, but the database configuration option and delete option are not enabled. It's grayed.
View 1 Replies View RelatedClone Testing Database From X86 To X64 Using DBCA Clonic Templates
Sep 14, 2012I'm using Oracle Database 11g R2 for study purposes.Currently I'm learning about the DBCA clonic templates.I have an Oracle DB 11g R2 X86 running properly in Ms Windows XP Professional SP 3 X86, using DBCA I created the seed template file .dbc and the .CTL and .DBF files, later I copied those files to a server running Oracle DB 11g R2 X86 in Ms Windows 7 Ultimate X86. Again, using DBCA I successfully created the source database through the seed template file, everything was ok.
Now, I formatted my testing server and I installed Ms Windows 7 Ultimate X64 and Oracle Database 11g R2 X64. I copied the seed template file .dbc and the .CTL and .DBF files to "assistantsdbca emplates" directory. Well, I started DBCA to try create the source database and when the DBCA is creating and starting the Oracle instance it shows the errors:
ORA-00604: error occurred at recursive SQL Level 1
ORA-06553: PLS-801: Internal error [56327]
Is it possible to clone my testing DB from X86 to X64 using DBCA clonic templates?
Server Administration :: ORA-03114 Error While Creating Database Using DBCA
May 16, 2013I 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".
Server Administration :: Error Creating Database Using DBCA Oracle 11g R2?
Nov 18, 2010This is on a vmware virtual server on Windows 2008R2 using ORACLE 11g R2 with patch set 6
I installed ORACLE (software only) and applied patch set 6 and tried to create a new database.
during the database creation I got an error as the system was adding the JVM that read:-
ORA-01927:cannot REVOKE privileges you did not grant.
I was given the options to ignore or abort
I chose to ignore the error and continue.
After the database creation completed I looked in the jserver log copied below and found two errors
I did not get the same error before installing patch set 6
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
No errors.
alter system flush shared_pool
drop role javauserpriv
[Code].....
Server Administration :: TNS Error - DBCA After Database Creation Script Complete
Aug 15, 2010I'm getting a "TNS disconnect" after database creation script creation in DBCA. Haven't figured out what's going on. I'm attempting to create a 2nd database on one linux 64 server. I get all the way through DBCA, but it won't go the final mile. Any thoughts? I've tried setting the port to a different port from the existing LISTENER, creating a LISTENER2 and associating it with the 2nd instance.
View 1 Replies View RelatedServer Administration :: Database Configuration Assistant Not Working / When Create New Database
Mar 26, 2011i am installing oracle database 8.1.7 on dell server power edge 2650 first time database successfully installed but when i want to crate new database by Database Configuration Assistant it is not working for new database creation.
View 1 Replies View RelatedCreate As Many As 100 Database With Upto 100 Users (max) For Each Database As Client
Aug 25, 2010I have CPU based Oracle server license. In this case as per license policies of Oracle I can have unlimited database with unlimited users connecting it.
I need to create as many as 100 database with upto 100 users (max) for each database as client. What is the recommended hardware for this server? CPU/ RAM/Harddisk, recommended chipset on the motherboard (in case of database storage capacity required is not high typically - 20 GB is OK per database - average), redundancy is critical, also Oracle database vault is going to be installed; as security is of prime importance between users of different database. Which specific server models from specific vendors like IBM/ Dell/ HP are good ones for this purpose?
PL/SQL :: Difference Between Install Database And Create Database?
Jan 11, 20131.what is the difference between install database and create database?
2. if i have connected with remote database(server) then it is an instance again?
Networking And Gateways :: DBCA Installation Through VPN
Sep 22, 2011I am facing a issue on DBCA Installation, when i tried from off-shore.
a. When Iam connecting a server using production / Model VPN , and try to start Installing DBCA Using X11-Forwarding of putty,
b. DBCA installation Started but its tooo Slow, it takes more than 3Hrs (Started at 9AM and ends at 11.17AM)
c. First time it fails and second time its went to success, Whereas when i take alog of server ping request - I am getting a frequent "Requested time out" due to network fluctuation.
So let me know is the network fluctuation affects the Installation through VPN, if So how to overcome and is any workaround on that ?
Error On DBCA From Script / Input A Value
May 17, 2013On Windows 7 I've created a DBCA from Script to automate the DB creation of identicall databases.I executed the bat from cmd.exe which I started as Administrator
On script xdb_protocol.sql when catqm.sql was called, the cmd stoped
it asks for a value "Give a value for 4 one:" (In german actually "Geben Sie einen Wert f³r 4 ein:" )
http://img62.imageshack.us/img62/1145/tempin.jpg
Its for *:user_opt_secfiles := '&4'*; shall be YES or NO it doesnt auto-set. What shall I put?
[code]....
Oracle 11g Installation Dbca Command Not Found?
Feb 17, 2013I installed oracle 11g on fedora 14 64 bit. i followed the instructions from the oracle docs. successfully installed. even the scripts ran. but when i try to execute dbca command. it says command not found. im in the oracle user acc.
View 10 Replies View RelatedServer Administration :: ORA-01034 While Running Dbca
May 27, 2011I hv created a database VAHAN with SID VAHAN , now I want to create another database in it with name SARATHI SID SARATHI.VAHAN db is running perfectly but everytime i tried to create the db with dbca it shows error "ORA-01034: ORACLE not avaiable."
I ran dbstart,lsnrctl start - getting same error..i dbshut the db and use startup nomount - getting same error.
DBCA Not Running On HPUX Itanium Server
Jan 30, 2013I have installed oracle software on HPUX IA server.After installation, I am trying to create the database using database template through DBCA.After setting database name , password, database file location and sga size on DBCA, DBCA not initializing the database creation after clicking "Finish" button and does not give any error though.I have tried multiple times but not able to create db using specific template using DBCA.
View 10 Replies View RelatedFilename Change During DBCA Data Copy
Jul 10, 2012I'm cloning a database from an existing dbca template. The clone is failing with datafile does not exist, because during the copying step, all the datafiles' name are changed, how do I force it to force dbca to keep the same names from the original database?
View 3 Replies View RelatedDBCA Wizard Hangs After Clicking Next On Welcome Screen?
Oct 4, 2012I am facing problems with the data base configuration wizard.The welcome screen opens on clicking the launch iconbut the moment i click on the next button it hangs
View 3 Replies View RelatedNetworking And Gateways :: DBCA Installation And Remotely From Off-shore?
Sep 22, 2011Iam facing a issue on DBCA Installation, when i tried remotely from off-shore. Steps I followed
a. I Connected a onsite desktop through a remote desktop connection (RDP) by using Corp-VPN from off-shore.
b. In the Remote Desktop, again by using production / Model VPN , connected the server which i need to Install DBCA
c. Using X11-Forwarding of putty, Started the DBCA installation.
d. Applied all the Parameters and on Finally clicking Finish to Start the database Creation, Finish button not responding and i can't continue the DBCA Installation.
Enterprise Manager :: DBCA Shows No Agents Found?
Jun 8, 2010I have EM Agent 10g installed in its own Oracle Home (c:oracleagent10g) and Oracle 11g installed in its own Oracle Home (c:oracle11.2.0) The Server shows in EM console but the only target is the EM Agent,.. neither the Listener or the Database show under the targets tab in EM. Also, when DBCA is ran and we get to step 4 it shows NO AGENTS FOUND.
Have installed patch: 8825226 and 8968580 for EM Grid Control (Windows 2003 R2 32Bit) And 9138201 for 10g Agent on Server 2008 R2 (64bit)
Server Administration :: Running DBCA In Silent Mode
Jan 27, 2012I'm trying to run dbca in silent mode and works perfect, this is how the code look like:
dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbName test.mydomain -sid test
-sysPassword passoracle -systemPassword passoracle -emConfiguration LOCAL -dbsnmpPassword passoracle
-sysmanPassword passoracle -characterSet WE8ISO8859P1
-initParams "open_cursors=500"
The problem is when I specify more than one initialization parameter in -initParams. If I try something like
-initParams "open_cursors=500, parallel_max_server=0"
Then I get this error Exception in thread "main".
Server Utilities :: Run DBCA From Unix Command Line?
Aug 27, 2007i am trying to run DBCA from unix command line. but it gives me error like this:
dbca[158]: /home/oracle/product/10.2.0/jdk/jre/bin/java: not found.
Also i tried to open some other utilites too. like netca it gives me same error.