- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- create an oracle instance
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
тАО07-12-2001 11:41 AM
тАО07-12-2001 11:41 AM
create an oracle instance
I can use sqlplus to connect to remote databases running on other machines fine but I can not create a local instance.
I used the dbassist program to create the sql files and when I run them I get the following messages:
$ ./test.sh
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
SVRMGR> SVRMGR> Connected.
SVRMGR> ORA-03113: end-of-file on communication channel
SVRMGR> 2> 3> 4> 5> 6> 7> 8> 9> 10>
CREATE DATABASE "test"
*
ORA-03114: not connected to ORACLE
SVRMGR> Disconnected.
SVRMGR> SVRMGR> Server Manager complete.
$
The script running is below:
#!/bin/sh
ORACLE_SID=test
export ORACLE_SID
/oracle/app/oracle/product/8.1.7/bin/svrmgrl << EOF
spool /oracle/app/oracle/admin/test/create/crdb1.log
connect internal
startup nomount pfile = "/oracle/app/oracle/admin/test/pfile/inittest.ora"
CREATE DATABASE "test"
maxdatafiles 254
maxinstances 8
maxlogfiles 32
character set US7ASCII
national character set US7ASCII
DATAFILE '/oradata3/oradata/test/system01.dbf' SIZE 260M AUTOEXTEND ON NEXT 1024
0K
logfile '/oradata3/oradata/test/redo01.log' SIZE 500K,
'/oradata3/oradata/test/redo02.log' SIZE 500K,
'/oradata3/oradata/test/redo03.log' SIZE 500K;
disconnect
spool off
exit
It is dieing on the startup nomount pfile line.
What am I doing wrong?
I looked on Oracle's site for the ORA-03113 message and can only find references to receiving this message if an instance you are connected to is shutdown.
I am just trying to set up a small development instance but will probably run into this same problem trying to create a production database.
Any help will be appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2001 11:50 AM
тАО07-12-2001 11:50 AM
Re: create an oracle instance
Does your script has a "EOF" at the end ? If not, put a EOF after the exit statement in your script. Basically "svrmgrl" will try and execute everything until it encounters EOF.
Hope this helps !
Praveen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2001 12:05 PM
тАО07-12-2001 12:05 PM
Re: create an oracle instance
This is from the command line:
$ svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup nomount pfile = "/oracle/app/oracle/admin/test/pfile/inittest.ora"
ORA-03113: end-of-file on communication channel
What is wrong the the startup nomount pfile line?
The inittest.ora file was created by dbassist.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2001 12:18 PM
тАО07-12-2001 12:18 PM
Re: create an oracle instance
Here is a thread where someone reported a similar problem. They solved it by increasing the SEMMNS kernel parameter from 200 (which Oracle recommended) to 500.
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x92f8a12d6d27d5118fef0090279cd0f9,00.html
Good luck!
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2001 12:19 PM
тАО07-12-2001 12:19 PM
Re: create an oracle instance
I am not sure if this would help, but you may wanna set your environment variables, such as
ORACLE_HOME,SHLIB_PATH,PATH. You may wanna try run oracle.profile or oraenv.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2001 12:51 PM
тАО07-12-2001 12:51 PM
Re: create an oracle instance
Thanks for the idea!