- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- How to create database in exisiting ..
Operating System - HP-UX
1753277
Members
4994
Online
108792
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-30-2008 10:59 PM
10-30-2008 10:59 PM
How to create database in exisiting ..
Hi, i have HP_UX system in this we have oracle 10G "myDB" in thsi different schemas is there, i want create another database in this can you plese help me in this regard.
Thanks
Thanks
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-05-2008 02:13 AM
11-05-2008 02:13 AM
Re: How to create database in exisiting ..
You can use the graphical tool dbca
you need a X-Windows on you PC - make following command on oracle accompt
export DISPLAY=YourIPAdrss:0.0
test with an xclock
if it's ok launch dbca
the other way is in using a shell script :
Here is some extract
ORACLE_SID=MyNewDataBaseName
NLS_LANG=.WE8ISO8859P15
export ORACLE_SID NLS_LANG
DISK0=/oracle/oradata
DISK1=/oracle/oradata
sqlplus "/ as sysdba" < spool $ORACLE_BASE/admin/$ORACLE_SID/scripts/createdb_1_$ORACLE_SID
set echo on
set pause off
shutdown abort
startup nomount
ALTER SESSION SET SORT_AREA_SIZE=10485760;
alter system set DB_CREATE_ONLINE_LOG_DEST_1='$DISK0';
alter system set db_create_file_dest='$DISK1';
CREATE DATABASE $ORACLE_SID MAXINSTANCES 3
MAXLOGHISTORY 30
MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXDATAFILES 254
NOARCHIVELOG
DATAFILE SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE
SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMPPROV TEMPFILE
SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
UNDO TABLESPACE UNDOPROV DATAFILE
SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
CHARACTER SET WE8ISO8859P15 ( This one is for France - check the good one for you)
LOGFILE GROUP 1 SIZE 30M,
GROUP 2 SIZE 30M,
GROUP 3 SIZE 30M,
GROUP 4 SIZE 30M,
GROUP 5 SIZE 30M,
GROUP 6 SIZE 30M,
GROUP 7 SIZE 30M,
GROUP 8 SIZE 30M,
GROUP 9 SIZE 30M,
GROUP 10 SIZE 30M
USER SYS IDENTIFIED BY sysman
USER SYSTEM IDENTIFIED BY manager;
CREATE SPFILE FROM PFILE;
ALTER SYSTEM SET UNDO_RETENTION = 0 SCOPE=MEMORY;
ALTER SYSTEM SET UNDO_TABLESPACE = UNDOPROV SCOPE=MEMORY;
you need a X-Windows on you PC - make following command on oracle accompt
export DISPLAY=YourIPAdrss:0.0
test with an xclock
if it's ok launch dbca
the other way is in using a shell script :
Here is some extract
ORACLE_SID=MyNewDataBaseName
NLS_LANG=.WE8ISO8859P15
export ORACLE_SID NLS_LANG
DISK0=/oracle/oradata
DISK1=/oracle/oradata
sqlplus "/ as sysdba" <
set echo on
set pause off
shutdown abort
startup nomount
ALTER SESSION SET SORT_AREA_SIZE=10485760;
alter system set DB_CREATE_ONLINE_LOG_DEST_1='$DISK0';
alter system set db_create_file_dest='$DISK1';
CREATE DATABASE $ORACLE_SID MAXINSTANCES 3
MAXLOGHISTORY 30
MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXDATAFILES 254
NOARCHIVELOG
DATAFILE SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE
SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMPPROV TEMPFILE
SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
UNDO TABLESPACE UNDOPROV DATAFILE
SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
CHARACTER SET WE8ISO8859P15 ( This one is for France - check the good one for you)
LOGFILE GROUP 1 SIZE 30M,
GROUP 2 SIZE 30M,
GROUP 3 SIZE 30M,
GROUP 4 SIZE 30M,
GROUP 5 SIZE 30M,
GROUP 6 SIZE 30M,
GROUP 7 SIZE 30M,
GROUP 8 SIZE 30M,
GROUP 9 SIZE 30M,
GROUP 10 SIZE 30M
USER SYS IDENTIFIED BY sysman
USER SYSTEM IDENTIFIED BY manager;
CREATE SPFILE FROM PFILE;
ALTER SYSTEM SET UNDO_RETENTION = 0 SCOPE=MEMORY;
ALTER SYSTEM SET UNDO_TABLESPACE = UNDOPROV SCOPE=MEMORY;
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP