- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Addition adding a new database
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
тАО06-28-2002 07:13 AM
тАО06-28-2002 07:13 AM
Addition adding a new database
thankx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 08:25 AM
тАО06-28-2002 08:25 AM
Re: Addition adding a new database
alias it=". $HOME/.IT.profile;unset INFORMIXSQLHOSTS"
alias dev=". $HOME/.DEV.profile;unset INFORMIXSQLHOSTS"
alias eval=". $HOME/.EVAL.profile;unset INFORMIXSQLHOSTS"
By the way - did'nt you crash the Enterprise ? :@)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 11:13 AM
тАО06-28-2002 11:13 AM
Re: Addition adding a new database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 11:46 AM
тАО06-28-2002 11:46 AM
Re: Addition adding a new database
Can you give me an example on how to do it?
I found the oraenv script in /usr/local/bin
Can you show me how you set your up?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 02:51 PM
тАО06-28-2002 02:51 PM
Re: Addition adding a new database
what are the other scripts that I might need to use to set up an environment?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 09:26 PM
тАО06-28-2002 09:26 PM
Re: Addition adding a new database
YOu have a good GUI kind of creating a database where you can select the options.
Else
you should do as
1.copy the initialization file to the new instance.
$cp $ORACLE_HOME/dbs/init.ora init"
2.Edit the init"instance-name".ora
to change the database_name
and set the values for the Shared_pool_size,DB_BLOCK_BUFFERS,etc..
Also change the location of your control files to the location you want to.
save the file
3.set you ORACLE_SID parameter to the new instance name.
eg.ORACLE_SID=DB001;export ORACLE_SID
check the value of the ORACLE_SID whether it is set properly.
echo $ORACLE_SID
4.$svrmgrl
svrmgr>connect internal
svrmgr>startup nomount pfile=$ORACLE_HOME/dbs/init"newinstance-name".ora
Now your instance will be started
svrmgr>create database "database-name"
>controlfile reuse
>datafile '
> group 2 ('oracle_home/dbs/log2NEW_NAME.dbf') size 10 M
check for the size for your database.
The datafile created is for the default system tablespace.
now after the database is created,you have to run the catalog.sql and catproc.sql
svrmgr>@$ORACLE_HOME/rdbms/admin/catalog
svrmgrl>@$ORACLE_HOME/rdbms/admin/catproc
After you run the two scripts.
create a seperate tablespace for rollback segment
svrmgr>create tablespace rollback datafile '/home/oracle/rollback.dbf' size 100 M;
svrmgrl>create rollback segment R01 tablespace rollback storage(maxextents unlimited);
svrmgrl>alter rollback segment R01 online;
Now the rollback segment is created .
Now make the entry in the
$ORACLE_HOME/dbs/init"new-instance".ora
In that enter R01 in the place of the
rollback segment in the file.
create the required tablespace ,like if you require user tablespace
like the one for the rollback segment.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 09:26 PM
тАО06-28-2002 09:26 PM
Re: Addition adding a new database
YOu have a good GUI kind of creating a database where you can select the options.
Else
you should do as
1.copy the initialization file to the new instance.
$cp $ORACLE_HOME/dbs/init.ora init"
2.Edit the init"instance-name".ora
to change the database_name
and set the values for the Shared_pool_size,DB_BLOCK_BUFFERS,etc..
Also change the location of your control files to the location you want to.
save the file
3.set you ORACLE_SID parameter to the new instance name.
eg.ORACLE_SID=DB001;export ORACLE_SID
check the value of the ORACLE_SID whether it is set properly.
echo $ORACLE_SID
4.$svrmgrl
svrmgr>connect internal
svrmgr>startup nomount pfile=$ORACLE_HOME/dbs/init"newinstance-name".ora
Now your instance will be started
svrmgr>create database "database-name"
>controlfile reuse
>datafile '
> group 2 ('oracle_home/dbs/log2NEW_NAME.dbf') size 10 M
check for the size for your database.
The datafile created is for the default system tablespace.
now after the database is created,you have to run the catalog.sql and catproc.sql
svrmgr>@$ORACLE_HOME/rdbms/admin/catalog
svrmgrl>@$ORACLE_HOME/rdbms/admin/catproc
After you run the two scripts.
create a seperate tablespace for rollback segment
svrmgr>create tablespace rollback datafile '/home/oracle/rollback.dbf' size 100 M;
svrmgrl>create rollback segment R01 tablespace rollback storage(maxextents unlimited);
svrmgrl>alter rollback segment R01 online;
Now the rollback segment is created .
Now make the entry in the
$ORACLE_HOME/dbs/init"new-instance".ora
In that enter R01 in the place of the
rollback segment in the file.
create the required tablespace ,like if you require user tablespace
like the one for the rollback segment.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 09:26 PM
тАО06-28-2002 09:26 PM
Re: Addition adding a new database
YOu have a good GUI kind of creating a database where you can select the options.
Else
you should do as
1.copy the initialization file to the new instance.
$cp $ORACLE_HOME/dbs/init.ora init"
2.Edit the init"instance-name".ora
to change the database_name
and set the values for the Shared_pool_size,DB_BLOCK_BUFFERS,etc..
Also change the location of your control files to the location you want to.
save the file
3.set you ORACLE_SID parameter to the new instance name.
eg.ORACLE_SID=DB001;export ORACLE_SID
check the value of the ORACLE_SID whether it is set properly.
echo $ORACLE_SID
4.$svrmgrl
svrmgr>connect internal
svrmgr>startup nomount pfile=$ORACLE_HOME/dbs/init"newinstance-name".ora
Now your instance will be started
svrmgr>create database "database-name"
>controlfile reuse
>datafile '
> group 2 ('oracle_home/dbs/log2NEW_NAME.dbf') size 10 M
check for the size for your database.
The datafile created is for the default system tablespace.
now after the database is created,you have to run the catalog.sql and catproc.sql
svrmgr>@$ORACLE_HOME/rdbms/admin/catalog
svrmgrl>@$ORACLE_HOME/rdbms/admin/catproc
After you run the two scripts.
create a seperate tablespace for rollback segment
svrmgr>create tablespace rollback datafile '/home/oracle/rollback.dbf' size 100 M;
svrmgrl>create rollback segment R01 tablespace rollback storage(maxextents unlimited);
svrmgrl>alter rollback segment R01 online;
Now the rollback segment is created .
Now make the entry in the
$ORACLE_HOME/dbs/init"new-instance".ora
In that enter R01 in the place of the
rollback segment in the file.
create the required tablespace ,like if you require user tablespace
like the one for the rollback segment.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 09:26 PM
тАО06-28-2002 09:26 PM
Re: Addition adding a new database
YOu have a good GUI kind of creating a database where you can select the options.
Else
you should do as
1.copy the initialization file to the new instance.
$cp $ORACLE_HOME/dbs/init.ora init"
2.Edit the init"instance-name".ora
to change the database_name
and set the values for the Shared_pool_size,DB_BLOCK_BUFFERS,etc..
Also change the location of your control files to the location you want to.
save the file
3.set you ORACLE_SID parameter to the new instance name.
eg.ORACLE_SID=DB001;export ORACLE_SID
check the value of the ORACLE_SID whether it is set properly.
echo $ORACLE_SID
4.$svrmgrl
svrmgr>connect internal
svrmgr>startup nomount pfile=$ORACLE_HOME/dbs/init"newinstance-name".ora
Now your instance will be started
svrmgr>create database "database-name"
>controlfile reuse
>datafile '
> group 2 ('oracle_home/dbs/log2NEW_NAME.dbf') size 10 M
check for the size for your database.
The datafile created is for the default system tablespace.
now after the database is created,you have to run the catalog.sql and catproc.sql
svrmgr>@$ORACLE_HOME/rdbms/admin/catalog
svrmgrl>@$ORACLE_HOME/rdbms/admin/catproc
After you run the two scripts.
create a seperate tablespace for rollback segment
svrmgr>create tablespace rollback datafile '/home/oracle/rollback.dbf' size 100 M;
svrmgrl>create rollback segment R01 tablespace rollback storage(maxextents unlimited);
svrmgrl>alter rollback segment R01 online;
Now the rollback segment is created .
Now make the entry in the
$ORACLE_HOME/dbs/init"new-instance".ora
In that enter R01 in the place of the
rollback segment in the file.
create the required tablespace ,like if you require user tablespace
like the one for the rollback segment.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2002 09:26 PM
тАО06-28-2002 09:26 PM
Re: Addition adding a new database
YOu have a good GUI kind of creating a database where you can select the options.
Else
you should do as
1.copy the initialization file to the new instance.
$cp $ORACLE_HOME/dbs/init.ora init"
2.Edit the init"instance-name".ora
to change the database_name
and set the values for the Shared_pool_size,DB_BLOCK_BUFFERS,etc..
Also change the location of your control files to the location you want to.
save the file
3.set you ORACLE_SID parameter to the new instance name.
eg.ORACLE_SID=DB001;export ORACLE_SID
check the value of the ORACLE_SID whether it is set properly.
echo $ORACLE_SID
4.$svrmgrl
svrmgr>connect internal
svrmgr>startup nomount pfile=$ORACLE_HOME/dbs/init"newinstance-name".ora
Now your instance will be started
svrmgr>create database "database-name"
>controlfile reuse
>datafile '
> group 2 ('oracle_home/dbs/log2NEW_NAME.dbf') size 10 M
check for the size for your database.
The datafile created is for the default system tablespace.
now after the database is created,you have to run the catalog.sql and catproc.sql
svrmgr>@$ORACLE_HOME/rdbms/admin/catalog
svrmgrl>@$ORACLE_HOME/rdbms/admin/catproc
After you run the two scripts.
create a seperate tablespace for rollback segment
svrmgr>create tablespace rollback datafile '/home/oracle/rollback.dbf' size 100 M;
svrmgrl>create rollback segment R01 tablespace rollback storage(maxextents unlimited);
svrmgrl>alter rollback segment R01 online;
Now the rollback segment is created .
Now make the entry in the
$ORACLE_HOME/dbs/init"new-instance".ora
In that enter R01 in the place of the
rollback segment in the file.
create the required tablespace ,like if you require user tablespace
like the one for the rollback segment.
Thanks