OraFAQ Forum: Server Administration » rdbms/admin scripts to run for new Oracle 7 database

Home » RDBMS Server » Server Administration » rdbms/admin scripts to run for new Oracle 7 database

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

rdbms/admin scripts to run for new Oracle 7 database [message #146150]

Tue, 08 November 2005 22:06

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay, don't pick on me. I have to use Oracle 7 and now I have to build a new one from scratch. I have the 'Create' statements working okay but want to know which of the following rdbms/admin scripts I should run.

connect sys/xxx
@/usr/oracle/rdbms/admin/expvew
@/usr/oracle/rdbms/admin/catalog
@/usr/oracle/rdbms/admin/dba_syn
@/usr/oracle/rdbms/admin/catproc.sql
@/usr/oracle/rdbms/admin/catdbsyn.sql

connect system/yyy
@/usr/oracle/rdbms/admin/dba_syn
@/usr/oracle/rdbms/admin/catdbsyn.sql
@/usr/oracle/sqlplus/admin/pupbld.sql

Or should I be running completely different ones to 'set up' the empty database?

David

[Updated on: Tue, 08 November 2005 22:09]

Report message to a moderator

Re: rdbms/admin scripts to run for new Oracle 7 database [message #146287 is a reply to message #146150]

Wed, 09 November 2005 14:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It is been a long time.
If my memory goes well, catalog.sql followed by catproc.sql should do.
Please check 'Server Reference' here in this URL.
http://oracledoc.wccnet.org/oracle7/DOC/dcommon/oin/index.htm

Report message to a moderator

Re: rdbms/admin scripts to run for new Oracle 7 database [message #146310 is a reply to message #146287]

Wed, 09 November 2005 18:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Thanks ... just the two scripts are required as a minimum.

David

Report message to a moderator

Re: rdbms/admin scripts to run for new Oracle 7 database [message #146944 is a reply to message #146150]

Mon, 14 November 2005 18:06

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Oracle 7? I feel sorry for you. Actually 7.3 was very consistant and solid.
I have about 700 lines of commands used to build a version 7 database on Solaris. If you want them, figure out how I can get them to you and I will send them. They are in about 20 .doc, .txt, and .sql files.

Report message to a moderator

Re: rdbms/admin scripts to run for new Oracle 7 database [message #146946 is a reply to message #146944]

Mon, 14 November 2005 18:17

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

7.3.2 actually - 7.3.4 gave them problems (years before my time)

Thanks for the offer ... I will Privately Mail you with my email address.

David

[Updated on: Mon, 14 November 2005 20:04]

Report message to a moderator

Re: rdbms/admin scripts to run for new Oracle 7 database [message #146955 is a reply to message #146946]

Mon, 14 November 2005 20:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

For people who come later ...

I did some directed searching in Metalink and "Note:1006497.6 How to Create a Database in the UNIX Environment" was retuned.

This is quite good. Wish I had found it earlier.

David

Report message to a moderator

Re: rdbms/admin scripts to run for new Oracle 7 database [message #147535 is a reply to message #146944]

Fri, 18 November 2005 02:17

BobatRMT
Messages: 2
Registered: November 2005
Location: Perth, Western Australia

Junior Member

nmacdannald wrote on Tue, 15 November 2005 08:06

Oracle 7? I feel sorry for you. Actually 7.3 was very consistant and solid.

I still have fond memories of Oracle 6.1.36

I HATED Oracle 4

Bob

Report message to a moderator

Previous Topic:	ORA-01033 ORACLE initialization or shutdown in progress
Next Topic:	oradim problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 13:54:55 CST 2025