- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to create a database and perform transacti...
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
тАО04-23-2002 06:40 AM
тАО04-23-2002 06:40 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2002 06:42 AM
тАО04-23-2002 06:42 AM
Re: How to create a database and perform transaction
If you are interested in ANY database then download the source of Berkley DB and use it.
Or you can source of MySQL and install it.
- Sukant
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2002 08:05 AM
тАО04-23-2002 08:05 AM
Solutionin general terms you will need a "create database ...;" statement, once, and every transaction has to be followed by "commit;" (well,, or "rollback;" in case you do not like it ;-)
But if you tell us for which product you need it, we can be more specific!
Regards,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2002 10:57 AM
тАО04-23-2002 10:57 AM
Re: How to create a database and perform transaction
I can't get my script to create the database...
here is the script that I use, and also these are the errors that I get when I run the script
@/u02/create_db.sql
Connected.
ORA-01081: cannot start already-running ORACLE - shut it down first
SP2-0734: unknown command beginning "This creat..." - rest of line ignored.
Maxinstance 1
*
ERROR at line 3:
ORA-02165: invalid option for CREATE DATABASE
Alter rollback segment rbs_temp online
*
ERROR at line 1:
ORA-01109: database not open
Alter rollback segment rbs02 online
*
ERROR at line 1:
ORA-01109: database not open
Alter rollback segment rbs03 online
*
ERROR at line 1:
ORA-01109: database not open
Alter rollback segment rbs04 online
*
ERROR at line 1:
ORA-01109: database not open
Alter rollback segment rbs05 online
*
ERROR at line 1:
ORA-01109: database not open
Storage ( initial 1M next 1M optimal 100M minextends 20 maxextends unlimited)
*
ERROR at line 2:
ORA-02143: invalid STORAGE option
Storage ( initial 1M next 1M optimal 100M minextends 20 maxextends unlimited)
'/u02/oradata/sales/sales_tools01.dbf size 100M reuse
*
ERROR at line 2:
ORA-01756: quoted string not properly terminated
SP2-0734: unknown command beginning "Creating 3..." - rest of line ignored.
(initial 40K next 40K *cincrease 50 minextends 1 maxextends 505)
ERROR at line 3:
ORA-02143: invalid STORAGE option
(initial 40K next 40K *cincrease 50 minextends 1 maxextends 505)
ERROR at line 3:
ORA-02143: invalid STORAGE option
(initial 40K next 40K *cincrease 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2002 11:06 PM
тАО04-23-2002 11:06 PM
Re: How to create a database and perform transaction
I cannot access your attached script. Please check it yourself.
I suspect that you have some comment starting as "This creat" in your script, that is not properly written. All other errors can be result of this wrong line.
Best regards,
Rok
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2002 02:27 AM
тАО04-24-2002 02:27 AM
Re: How to create a database and perform transaction
The trouble is the first error (ORA-...)
Are you sure to have the ORACLE_SID set ?
If it's not the cas do it with the proper SID.
And if you have another database running on the same server, with the same ORACLE_SID then caution !!
If you have a previously database with this SID set which is running and you want to remove it, then shut it down first before the create !!
hope it may help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2002 03:34 AM
тАО04-24-2002 03:34 AM
Re: How to create a database and perform transaction
So your still strugling with your databases...
Can access your script, but this is a start:
First; have you created and started and database earlier. Check with "ps -ef |grep pmon". If you get any ora_pmon_
If you want to create a new database with your script, make sure you set a different ORACLE_SID in your enviroment than the one(s) already in use. Then run your script.
Second there seems to be a number of error in the script. Most of the error are due to the fact that the database already was running, as you can't recreate it..
>SP2-0734: unknown command
This is most probably remarks in the script that you have forgotten to put an # sign in front of.
>Maxinstance 1
This is spelled wrong: "maxinstances 1"
>Storage ( initial 1M next 1M optimal 100M minextends 20 maxextends unlimited)
This is spelled wrong:
Storage ( initial 1M next 1M optimal 100M minextents 20 maxextents unlimited)
>'/u02/oradata/sales/sales_tools01.dbf size 100M reuse
This lacks the last "'" should read:
'/u02/oradata/sales/sales_tools01.dbf' size 100M reuse
>(initial 40K next 40K *cincrease 50 minextends 1 maxextends 505)
This is spelled wrong:
>(initial 40K next 40K pctincrease 50 minextents 1 maxextents 505)
Hope this helps on your database creation.
For your transaction, you'll need a table to enter data into. Use the "create table" statement.
Further enter data using "insert into" statement.
End the transaction using "commit;"
To read data from teh table use "select * from tablename;"
Good luck
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2002 03:42 AM
тАО04-24-2002 03:42 AM
Re: How to create a database and perform transaction
Should be:
CAN'T access your script...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2002 05:32 AM
тАО04-24-2002 05:32 AM
Re: How to create a database and perform transaction
Here's the steps I typically follow:
Step 1 - Create parameter that points to ../admin directory named $ORACLE_ADMIN
Step 2 - Create directories under $ORACLE_ADMIN/
adhoc/scripts
bdump
cdump
pfile
create
udump
Step 3 - Create necessary directories to hold datafiles, control files, redo logs, archive logs, etc.. e.g. /u01/oradata/
Step 4 - Create at least 4 db create files in $ORACLE_ADMIN/
a. createdb
b. createdbenv
c. createts
d. createus
Step 5 - Create at least 3 db parameter startup files in $ORACLE_ADMIN/
a. config
b. init
c. config
Step 6 - Make sure that oracle owns all files and directories.
Step 7 - Add oracle sid to $ORACLE_HOME/network/admin/tnsnames.ora and listener.ora.
Step 8 - Update /etc/oratab
Step 9 - Restart oracle listener.
Step 10 - Change to $ORACLE_ADMIN/
Step 10 - Logon to Oracle, export ORACLE_SID=
Step 11 - Execute createdb
Step 12 - Execute createdb
Step 13 - Execute createts
Step 14 - Execute createus
Step 15 - Shutdown the database.
Step 16 - Create a symbolic link in $ORACLE_HOME/dbs/init
e.g. ln -s $ORACLE_ADMIN/
Step 17 - Create a password file.
e.g. passwd file=/u01/app/oracle/product/7.3.4/dbs/orapw
Step 18 - Update $ORACLE_ADMIN/
Step 19 - Restart svrmgrl and start the database. Online archiving will require starting the database the first time in mount and executing alter database archivelog and alter database open.
Step 20 - Verify startup... If everything looks okay, shutdown the database and backup all your files before restarting database.
I'm placing copies of some of the files that I've identified into a single file. Files are separated by the following string "===FILE==="
jack...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2002 08:59 AM
тАО04-24-2002 08:59 AM
Re: How to create a database and perform transaction
as long as we have that problem (broken attachments),
if you want to, email me your script or ask for an example of an Create-an-Oracle-Instance-under-HPUX-from-scratch script...
Regards,
Wodisch
PS: read my "profile" for the eMail-address...