How To Recommend Server To Create New Database
Aug 16, 2012
I have two production servers and business required a another one or two new databases need to create in these server A & B. what are the important things i need to task it while give this kind of recommendation.
Below is for your reference and in server A how database we can create[need sga size & pga size] and server B as well.
Server Name Physical Mem SGA PGA Existing DB Name
Server A 48GB 8gb 6gb PRODA
8gb 6gb PRODB
Server B 48GB 8gb 6gb PRODA
4gb 3gb PRODB
4gb 3gb PRODC
Note: Due to new database existing production db performance should not affect.
View 3 Replies
ADVERTISEMENT
Mar 26, 2011
i 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 Related
Apr 18, 2011
I have database in single server. I already have ORACLE_SID=stagedb. So i want to create new sid and named as proddb.Is it possible have multiple db in single server? This server not running as RAC. It run as single only.
View 1 Replies
View Related
Jul 6, 2012
How to create own database in oracle 10g. I want to create new database in oracle.
View 10 Replies
View Related
Aug 21, 2013
I am installing Oracle 12c R1 on Windows 2012. The windows is configured as a domain controller. I am logged in as the domain administrator.I created a normal domain user -- DomainNameORACUSER. I provided this as the existing user id during Oracle installation.
The software installs fine, but when creating the DB using the database configuration assistant, an error is shown "error in process:...inoradim.exe. Enter password for Oracle service user: DIM-00019: create service error. O/S-Error: (OS 87) The parameter is incorrect". The DB is not created.
I skipped the db creation and completed the installation. When tried to create the db using the database configuration assistant after installation, I received the same error.I performed the same installation on Windows 8 and was successful in creating the db.
View 5 Replies
View Related
Jul 16, 2010
create a new DB service and apply the load , then I need to verify the service load from Enterprise Manager or table V$SERVICEMETRIC .
Below are what I did
Quote:I tried to add service in tnsnames.ora like below
SERVICE = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=25057)(HOST=dadvmc))(CONNECT_DATA=(SID=tgc4)))
/************
Also I tried the serviceName like below, but not working when I conneted SALES1 from sqlplus
SALES1 = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=25057)(HOST=dadvmc))(CONNECT_DATA=(SERVICE_NAME=host.us.xxx.com)))
**********/
and login as
sqlplus scott/tiger@SERVICE[/email][/email]
then lock table EMP in exclusive mode in two session.
I can see the load is added to service SYS$USERS , but I can't see the new service from V$SERVICEMETRIC or Enterprise Manager.
select
SERVICE_NAME
from V$SERVICEMETRIC
How could we create the new DB service?
View 5 Replies
View Related
Jun 19, 2013
I have install Oracle 10g Database software in Red Hat 5.9 64bit. When I want to create a database manually (not using DBCA) I am getting errors like follow:
[oracle@t24app2 ~]$ export ORACLE_SID=dbend08
[oracle@t24app2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 19 16:19:37 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: I am trying to connect as host not using Tns file info.
View 4 Replies
View Related
Mar 30, 2012
If i create database on server(remote desktop connection) and try to some R&D like shutdown or startup command it will effect my other database or not.
View 1 Replies
View Related
Jan 5, 2011
we are having physical standby database and production database..we have create a soft link for a datafile in production to another mount point
ex- /disk1/data1 to /disk2/data1
now we want to keep the datafile in /disk2/data1 and remove the softlink..As we are having physical standby database . i need to know what are step to be taken. my action plan is as follows:
In production.
1. synchronise both standby(apply archive logs) and production.
2.shut down the standby
3.create controlfile in production in ascii format and edit the path (/disk1/data1 to /disk2/data1)
4. run the @control.sql that i have created
4.create a standby control file in production .
In standby:
1. take the backup of controlfile.
2.place the newly create controlfile(from production) to the location of controlfile
3. remove soft link.
4.startup mount.
5. then we can apply logs as usual to make the standby sync.
whether my action plan is 100% correct or any changes to be done.
View 1 Replies
View Related
Dec 20, 2011
i want to create new database in oracle 10g, i follow following steps.
C:ORACLE_SID=ALI
THEN create passwordfile
orapwd file=orapwdALI.ora password=ali entries=6
then create oracle instance
C:Oradim -new -sid ALI -STARTMODE AUTO
after that i use
SQLPLUS /NOLOG
THEN i write the command to connect to user ali but
CONNECT SYS/ali as sysdba
it display following message.
Error
ORA-1256: TNS: protocol adapter.
i also check the oracle services from "services.msc", where oracle instance is "start".
View 9 Replies
View Related
Jan 31, 2012
While creating my database manually i got error
sql> create database orcl
>national character set utf8
national character set utf8
*
ORA:12701 CREATE DATABASE CHARACTER SET IS UN KNOWN...
where
sql> create database orcl
> character set WE8ISO8859P1
is successful...
View 7 Replies
View Related
Dec 21, 2011
how 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 Related
Mar 5, 2013
how to create best profile for huge user in oracle database user which take lagre uga memory.
View 5 Replies
View Related
Jul 7, 2012
Through an Oracle Apex application I need to create/drop a user/schema in another Oracle database. i.e., create/drop user remotely using an Oracle Apex application.
View 12 Replies
View Related
Jan 13, 2011
can we use oracle client version to create a database in that server.
View 3 Replies
View Related
Aug 25, 2010
I 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?
View 2 Replies
View Related
Jan 11, 2013
1.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?
View 3 Replies
View Related
Oct 28, 2011
I 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
View Related
Aug 21, 2013
I want to create a database named Influx as well as tablespace influx.for this i login in sys account.now i am trying to run the following command:
CREATE DATABASE INFLUX LOGFILE GROUP 1 ('G:appdhirenderoradataINFLUX
edo01.log') SIZE 100M, GROUP 2 ('G:appdhirenderoradataINFLUX
edo02.log') SIZE 100M, GROUP 3 ('G:appdhirenderoradataINFLUX
edo03.log') SIZE 100M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 DEFAULT TABLESPACE users DATAFILE 'G:appdhirenderoradataINFLUXINFLUX01.dbf' SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED FOLLWOING ERROR IS COMMING:ora-01501 datbase fialed.ora-01100
database already mount .
View 3 Replies
View Related
Dec 6, 2010
I have installed oracle 9i in my PC.I would like to know the answer for the following questions.
1.Is it possible to create more than one database in oracle? If so, can it be used simultaneously through sqlplus?
2.If it is not , how can I move from one database to another?
View 3 Replies
View Related
Aug 16, 2013
Why 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 Related
Oct 19, 2011
How to create a standby database with and without rman......?
View 3 Replies
View Related
Jun 18, 2013
Usually where should we create the database link? In the production or development? create public database link dblinkname connect to user_in_db2 identified by password_in_db2 using 'tnsentry name in db2'; In production or development?
View 2 Replies
View Related
Jan 5, 2011
I'm trying to create a materialized view on a database on my local laptop, and when I execute the create it fails with the following error: ORA-06550: line 1, column 60:
PLS-00103: Encountered the symbol ".16" when expecting one of the following: . ( @ ; with the table name highlighted.
CREATE MATERIALIZED VIEW Schema.MV (col1,
col2,)
BUILD IMMEDIATE
REFRESH Complete ON DEMAND
WITH PRIMARY KEY
AS
select EXTRACTVALUE (rawxml, '/Test.class/@ID') AS col1,
EXTRACTVALUE (rawxml, '/test.class/test.attribute.name') AS col2,
from RAWXML
where Type = 'test.classvalue';
The query on its own though executes fine.
select EXTRACTVALUE (rawxml, '/Test.class/@ID') AS col1,
EXTRACTVALUE (rawxml, '/test.class/test.attribute.name') AS col2,
from RAWXML
where Type = 'test.classvalue';
Is there something wrong with the table setup? I have tried creating a public synonym and still the error comes up.
View 11 Replies
View Related
Apr 28, 2011
i would like to trace some connexions on database, once compile the code , i have the issus following:
10/2 PL/SQL: SQL Statement ignored
11/20 PL/SQL: ORA-00942: table or view does not exist
this is the
DROP TABLE connect_user;
CREATE TABLE connect_user
(
nom_ora varchar2(15),
naom_os varchar2(15),
programme varchar2(20),
poste varchar2(20),
[code]...
View 3 Replies
View Related
Dec 9, 2011
How to create db in oracle 11g and make some table in that from the web page 'database control' ?
View 11 Replies
View Related
Apr 3, 2013
I installed Oracle 10g XE on windows7 to create a database i opened "start database command interface" and created an SID and followed some steps afterwards i am facing "TNS ADAPTER NOT FOUND"
View 7 Replies
View Related
Aug 13, 2012
I need to create a database with a langauge set to Polish and territory set to Poland. I use dbca to create the database. I set there these settings but when the database is created and I try following sql commands I get this output.
SQL> select * from v$NLS_PARAMETERS;
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE POLISH
NLS_TERRITORY POLAND
NLS_CURRENCY zl
NLS_ISO_CURRENCY POLAND
[code]...
Why does SELECT * FROM NLS_DATABASE_PARAMETERS return AMERICAN language? How to create the database with Polish settings?
View 3 Replies
View Related
Aug 29, 2012
I want to create a database trigger which will test the database link, if it is ok then it will use dblink and do its work.
If it fails then it will send the data into its own server logfile.
I Wrote:
CREATE OR REPLACE TRIGGER PERMIT.TESTTRG
AFTER INSERT OR UPDATE
ON PERMIT.TR_LP_M_H_COMPANY_25072012
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
Declare
l number; nIgn PLS_INTEGER; nRows PLS_INTEGER := 0;
[code]....
When I execute it it is giving error:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/11 PLS-00201: identifier 'EXEC_SQL.CONNTYPE' must be declared
4/11 PL/SQL: Item ignored
8/2 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
[code]....
View 4 Replies
View Related
Feb 2, 2013
here we have san server and rac database two node database.i want to know how can i create directory on rac database. i know how to create directory on single database but i do not know how can i create directory on rac database.
View 3 Replies
View Related
