Home » RDBMS Server » Server Administration » how to create oracle 8.1.7 database if dbca dbasssist.cl is not working
how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588202] Sun, 23 June 2013 07:13 Go to next message
qanita786
Messages: 152
Registered: May 2007
Location: PAKISTAN
Senior Member
how to create oracle 8.1.7 database if dbca dbasssist.cl is not working
Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588203 is a reply to message #588202] Sun, 23 June 2013 08:36 Go to previous messageGo to next message
BlackSwan
Messages: 22726
Registered: January 2009
Senior Member
when all else fails, Read The Fine Manual

http://docs.oracle.com/cd/A87860_01/doc/index.htm

use CREATE DATABASE statement

[Updated on: Sun, 23 June 2013 08:56]

Report message to a moderator

Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588301 is a reply to message #588203] Mon, 24 June 2013 14:20 Go to previous messageGo to next message
qanita786
Messages: 152
Registered: May 2007
Location: PAKISTAN
Senior Member
pls define create database statement
Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588302 is a reply to message #588301] Mon, 24 June 2013 14:25 Go to previous messageGo to next message
BlackSwan
Messages: 22726
Registered: January 2009
Senior Member
Read The Fine Manual in URL my previous reply
Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588304 is a reply to message #588302] Mon, 24 June 2013 14:39 Go to previous messageGo to next message
qanita786
Messages: 152
Registered: May 2007
Location: PAKISTAN
Senior Member
when i apply this command then following error 1031: insufficient privileges display


CREATE DATABASE test
DATAFILE 'test_system' SIZE 10M
LOGFILE GROUP 1 ('test_log1a', 'test_log1b') SIZE 500K,
GROUP 2 ('test_log2a', 'test_log2b') SIZE 500K

Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588306 is a reply to message #588304] Mon, 24 June 2013 14:42 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
At this level you must hire someone that has the basic knowledge in DBA area, only SYS can execute this command.

Regards
Michel
Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588307 is a reply to message #588306] Mon, 24 June 2013 14:45 Go to previous messageGo to next message
BlackSwan
Messages: 22726
Registered: January 2009
Senior Member
sysmgrl
connect internal
Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588406 is a reply to message #588202] Tue, 25 June 2013 11:22 Go to previous messageGo to next message
kabaoracle
Messages: 5
Registered: June 2013
Location: Guinea
Junior Member
hello
if dbca not running do this:
1- prepare your architecture OFA
2-sqlplus / as sysdba
3-startup nomount
4-execute your script creation database with tis commande: @script_creation_database
in your script write this:
create database your_database
maxlogfiles 32
---
datafile----

refer to oracle document
Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588414 is a reply to message #588406] Tue, 25 June 2013 12:08 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Well, if I was OP, with his knowledge, I think I have no more information after your post than before. Cool

Regards
Michel
Re: how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588436 is a reply to message #588414] Tue, 25 June 2013 15:43 Go to previous message
kabaoracle
Messages: 5
Registered: June 2013
Location: Guinea
Junior Member
ok go to your invite with command: cmd
and we will create before your instance. sorry my english is no good. i have my OCP in oracle
Previous Topic: dynamic performance views (merged)
Next Topic: Unable to see/insert Chinees characters in Oracle db
Goto Forum:
  


Current Time: Tue Sep 02 10:32:59 CDT 2014

Total time taken to generate the page: 0.11931 seconds