- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
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
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- 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
тАО03-13-2002 04:05 PM
тАО03-13-2002 04:05 PM
Here is my setting up situation:
During the installation, I generated a database instance name sales, and I modified
the init
My question : Can someone show me on how to link this file using pfile?
In addition, I would like to know on the procedure on how to set up the tablespaces. According to oracle9i suggestion that using the raw devices, however, it has the procedure for AIX, and TRU64 but not on HP-UX. Or if there is possible, is there an other alternative ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-13-2002 11:24 PM
тАО03-13-2002 11:24 PM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
I have attached two scripts in a file.
You will need this file for the first step :
---------------------------------------------
init.0
#
# $Header: init.ora,v 6.14 91/03/28 14:42:31 pgreenwa Osd
#
ifile = /home/dba/oracle/admin/$ORACLE_SID/pfile/config.ora
processes = 20
----------------------------------------------
config.ora
# $Header: cnfg.orc 7001200.2 93/04/26 14:58:22 eruben Osd
#
# cnfg.ora - instance configuration parameters
control_files = (/unnn/ORACLE/SID/cntrl/control.ctl,
/u012/ORACLE/SID/cntrl/control.ctl,
/u015/ORACLE/SID/cntrl/control.ctl)
# Below for possible future use...
#init_sql_files = (?/dbs/sql.bsq,
# ?/rdbms/admin/catalog.sql,
# ?/rdbms/admin/expvew.sql)
audit_file_dest = /home/dba/oracle/admin/SID/audit
background_dump_dest = /home/dba/oracle/admin/SID/bdump
core_dump_dest = /home/dba/oracle/admin/SID/cdump
user_dump_dest = /home/dba/oracle/admin/SID/udump
log_archive_dest = /home/dba/oracle/admin/SID/arch/arch
db_block_size = 8192
db_name = SID
----------------------------------------------
init.1st
#
# $Header: init.ora,v 6.14 91/03/28 14:42:31 pgreenwa Osd
#
ifile = /home/dba/oracle/admin/$ORACLE_SID/pfile/config.ora
db_files=1022
db_file_multiblock_read_count = 32
db_block_buffers = 200
dml_locks = 1000
log_checkpoint_interval = 10000000
processes = 20
rollback_segments=(r0)
---------------------------------------------
for the startup at end of create step 2 you need your normal init.ora.
Hope, it helps.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-13-2002 11:39 PM
тАО03-13-2002 11:39 PM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
First make sure that this init.ora file is
located under
directory and subsequently, create a link
in the
$ ln -s
With regards to creating tablespaces, you dont
actually create them on the OS level, tablespaces are created and altered inside
the database that generate a datafile reflected in the filesystem as ".dbf" file.
hope this helps
~DANNY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2002 02:50 AM
тАО03-14-2002 02:50 AM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
Instead of raw devices use files:
SQL>startup nomount
SQL>create database DB_NAME
maxdatafiles 200
maxinstances 1
maxlogfiles 16
character set WE8ISO8859P1
datafile
'/u02/oradata/DB_NAME/DB_NAME_system_01.dbf' size 100M
logfile
group 1 ('/u02/oradata/DB_NAME/DB_NAME_redo_01a.rdo'
,'/u06/oradata/DB_NAME/DB_NAME_redo_01b.rdo') size 10M,
group 2 ('/u02/oradata/DB_NAME/DB_NAME_redo_02a.rdo'
,'/u06/oradata/DB_NAME/DB_NAME_redo_02b.rdo') size 10M,
group 3 ('/u02/oradata/DB_NAME/DB_NAME_redo_03a.rdo'
,'/u06/oradata/DB_NAME/DB_NAME_redo_03b.rdo') size 10M;
And to create tablespaces:
SQL>create tablespace USERS datafile '/u02/oradata/DB_NAME/DB_NAME_users01.dbf' size 1M;
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2002 02:54 AM
тАО03-14-2002 02:54 AM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
Instead of raw devices, you can use filesystem tablespaces with mincache=direct for mount option.
Regards,
Patrice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2002 05:51 AM
тАО03-14-2002 05:51 AM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
I do not know if this is still the same with 9i, but with earlier versions, you needed to create a public (non-system) rollback segment before you could create additional tablespaces.
create public rollback segment rbs_temp;
alter rollback segment rbs_temp online;
create tablespace ....
later on you should create a seperate tablespace for your rollback segments and then drop the temporary one again.
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2002 06:12 AM
тАО03-14-2002 06:12 AM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
You're absolutely right.
I just left it out due to the nature of the question.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2002 01:37 PM
тАО03-14-2002 01:37 PM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
Thank you for all of your inputs. However, I 'm still a little fuzzy on some of the point.
1. as suggested in the forum, I need to create
these filesystem prior to run the script.
My question is :
1. How large is required for these filesystem?
2. Can I configure these filesystem using the storage disks or internal disk on the O/S?
3. Do they need to be mounted before running the script?
/u03 : for index table space
/u04 redologs
/u05 temporary and rollback
/u06 redologs members
/u07 Archieved redologs...
4. Afer running the script, how would I know the tablespaces has been generated and alter?
5. without giving the database where to write to and size of the database how would it know where to write to?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2002 02:00 PM
тАО03-14-2002 02:00 PM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
If I didn't create any of the tablespaces file, then how does oracle run?
...if i want to have 15 tablespaces? then it would be reasonale for me to create these tables spaces using the LVM command structure on how to create filesystem? I have read that oracle suggested to use raw devices for the tablespace, but unfortunately there wasn't any procedure on to do it? so, if you can, could you help me with this problem?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2002 10:50 PM
тАО03-14-2002 10:50 PM
Re: NEED HELP ON SETTING UP TABLESPACES FOR ORACLE9i
What you do first is starting an instance without a database in the background.
Then you create the database from this instance. When you have finished step 1, you have created a minimal database. After step 2 you can already do more. In step three you should run all the sql scripts like catexp.sql and so on for whatever you need.
Raw devices give you a good performance, if you go for real BIG databases. But the backup and restore is a bit tricky. If you want to do cpio backups or even OmniBack i would suggest filesystems.
Rgds
Alexander M. Ermes