OraFAQ Forum: Server Administration » how to create oracle 8.1.7 database if dbca dbasssist.cl is not working

Home » RDBMS Server » Server Administration » how to create oracle 8.1.7 database if dbca dbasssist.cl is not working

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to create oracle 8.1.7 database if dbca dbasssist.cl is not working [message #588202]

Sun, 23 June 2013 07:13

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

how to create oracle 8.1.7 database if dbca dbasssist.cl is not working

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

pls define create database statement

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Read The Fine Manual in URL my previous reply

Report message to a moderator

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

qanita786
Messages: 229
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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sysmgrl
connect internal

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	dynamic performance views (merged)
Next Topic:	Unable to see/insert Chinees characters in Oracle db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:44:49 CST 2024