Server Administration :: Create Multiple Database In Single Server

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


ADVERTISEMENT

Server Administration :: Multiple Database With Multiple Instance On Same Machine?

Mar 16, 2011

can we have multiple database version running in a single machine with multiple instances provided there are enough resources.Can we do in RAC only?

View 15 Replies View Related

Server Administration :: Single Port For Database

Apr 8, 2013

what will be the advantages and disadvantages of configuring database on only one port number for connecting the database server.

View 1 Replies View Related

Server Administration :: Install Oracle 11.2.0.2 Single Instance Database On AIX 6.1?

May 4, 2011

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 Related

Server Administration :: Accessing Single Schema From Multiple Schema Logging?

May 16, 2011

A single master schema where many developers are accessing. all share same password.

now i would like to trace all the changes made by each users. so i create a individual users for all and grant permission to access that schema.do i have a possibility of auditing the changes did by each user for that particular schema

View 2 Replies View Related

Server Administration :: Single Big Tablespace Versus Multiple Tablespace?

Jan 26, 2011

My database version is

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

My os version is

Linux damdat01 2.6.18-128.7.1.el5 #1 SMP Wed
Aug 19 04:00:49 EDT 2009 x86_64 x86_64 x86_64
GNU/Linux

My database is OLP system.

My question is what are the advantages and disadvantages having one single tablespace versus multiple tablespace?

Easy to maintain when you have single tablespace. but hard to track the IO issues if you have one single tablespace.

View 7 Replies View Related

Server Administration :: Database Configuration Assistant Not Working / When Create New Database

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

Server Administration :: How To Create A Database (Oracle 10g)

Jul 6, 2012

How to create own database in oracle 10g. I want to create new database in oracle.

View 10 Replies View Related

Server Administration :: Unable To Create Database?

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

Server Administration :: Create New Service For Database?

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

Server Administration :: Create A Database Manually

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

Server Administration :: Create Controlfile In Standby Database

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

Server Administration :: Create New Database - Error Ora-12560?

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

Server Administration :: Script To Automate Startup / Shutdown Of Multiple Instance In One Database

Jun 24, 2010

Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.

View 1 Replies View Related

Server Administration :: How To Know Currently Running Databases In Single Server

Jul 30, 2010

I have installed three database in MY Linux server. I have started Instance for all database and started database also .

No I want to check my databases status or currently running database How can I know . Or which Dynamic View or Database dictionary I should use ?

View 2 Replies View Related

Server Administration :: ORA-12701 Create Database Character Set Is Unknown

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

Server Administration :: How To Create Best Profile For Huge User In Oracle Database

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

Server Administration :: Create / Drop User / Schema In Another Oracle Database Through Apex

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

Server Utilities :: Multiple DB In Single SQLPlus Window?

Feb 4, 2011

We can connect to many databases and can access them simultaneously in a single sqlplus window?

View 4 Replies View Related

Server Utilities :: To Load Single Column Data Into Multiple Columns

Mar 26, 2012

I want to load single column data into multiple columns.

View 3 Replies View Related

PL/SQL :: Single Long Connection Vs Multiple Short Connections To Oracle Server

Oct 8, 2012

A DB server (Oracle 11g) on Linux will support a Web Application Server (Java based) for hosting a public web site.For sending multiple INSERT statements over from the Java Server to Oracle Server, I have two ways to do it:

1) Wrap those insert statements together and send it over with one connection to Oracle

2) Send each insert statement separately to Oracle. As the result, multiple insert statements are sent and accordingly multiple connections to Oracle are needed.

Advantage of option 1 is just using one Connection. Disadvantages are that Oracle will then need to parse the statement string into multiple separate insert statements, and then loop through them to execute each. This may be costly in CPU sense.

While the option 2 may have quicker execute of each insert statement, but will need to create multiple connections.If the number of users is known and stable (such as intranet), I would prefer option 1; while for the internet there could hundreds concurrent users at the peak, I lean towards the option 2.

View 2 Replies View Related

Server Administration :: How Single Control File Enough To Have All Transaction SCN

Feb 5, 2011

1)How a single control file is enough to have all the transaction's SCN no for older transactions.

Eg - A transaction has the SCN 01 and after a month the new transaction's SCN is 502. Is the control file holding all those (01 to 502) SCN in it or just will have the latest SCN no (ie - 502).

View 2 Replies View Related

Server Administration :: Oracle Normal And Application DB In Single Machine

Apr 26, 2012

I have already installed oracle 10g version in my Desktop. Now i want to install APPLICATION SERVER 10g version.

Should I Un install the Normal Database.
Or else can I have both in a single machine.

View 1 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

View 22 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related

Server Administration :: Access To Database Server Machine Login?

Apr 30, 2012

database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?

View 9 Replies View Related

Server Administration :: Oracle 10g - Database Server Startup / Shutdown

Jun 29, 2011

I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.

View 5 Replies View Related

Server Administration :: Oracle Database Server - Logon Denied

Jul 19, 2011

I am connected as System. It was the only user I set-up a password when installed the database on personal computer.

SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

[code]...

SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied

View 1 Replies View Related

Server Administration :: Multiple 11g Databases

Dec 5, 2010

I have Oracle 11g installed on AIX and I want to install another 11gR2 single instance in a different oracle home, will it be possible?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved