Home » RDBMS Server » Networking and Gateways » create database
create database [message #66267] Tue, 26 February 2002 00:52 Go to next message
upadhya
Messages: 2
Registered: February 2002
Junior Member
how to create a database,tell me in detail.
and make databse link to remote computer.
Re: create database [message #66278 is a reply to message #66267] Thu, 28 February 2002 19:20 Go to previous messageGo to next message
seng
Messages: 191
Registered: February 2002
Senior Member
***********Create database. ******************

**** MANULLY
UNIX
1. Get the copy of parameter file (init<new sid>.ora). edit the parameter according your spec. especially database name(db_name), memory (shared_pool_size),space(data files,control file,redo log file),and so on.

Note:
- concern on space and memory of OS. Must be enough to start the instance.
- data, control and redo log file path must not use the existed database file, if this happen, the problem will happen on your existed database.

2. Edit the script to create the database. The sample(crdb.orc or crdb2.orc) is in ORACLE_HOME/rdbms/install/rdbms

3. Environment setting on UNIX user (Usually is Oracle user) on ORACLE_SID (similar to database name).

e.g
UNIX
export ORACLE_SID=sid name

NT/Windows 2000
set ORACLE_SID=sid name

Note:
- Make sure the Oracle Sid is set correctly.

4. Start the instance in new environment setting.

- Logon SVRMGRL
SVRMGRL
SVRMGRL connect / as sysdba

- Start the instance
SVRMGRLstartup nomount profile= { directory of new parameter file init(new sid).ora }

If no error after start the instance. this means your instance is up. you can find the instance process in UNIX (ps -ef&#124grep oracle) . the next step is created the database.

5. Create the database.
- create database with script(step 2)
SVRMGRL @(script file)

if you don't see error. this means your database is created.

Note:
- if your script has startup command then you don't need step 4.

6. After the database is up. The last step is to create directionary script.
- create directionary.
SVRMGRL @ORACLE_HOME)/rdbms/admin/catalog.sql

- PL/SQL.
SVRMGRL @(ORACLE_HOME)/rdbms/admin/catproc.sql

- Replication.
SVRMGRL @(ORACLE_HOME)/rdbms/admin/catrep.sql

- Parallel.
SVRMGRL @(ORACLE_HOME)/rdbms/admin/catparr.sql

NT/WINDOWS 2000
1. Similar to UNIX
2. Similar to UNIX
3. Similar to UNIX
3a. Before start instance and create the database. You need to create the services on NT/Windows 2000 with below command.

-create the service
ORADIM -NEW -SID stby -INTPWD internal_pwd -MAXUSERS n

- start/stop the service
net start oracleservice<sid>
net stop oracleservice<sid>
or using service in control panel to start or stop the service.

Note:
- this service must be started before go to next step.

4. Similar to UNIX
5. Similar to UNIX
6. Similar to UNIX

**** AUTOMATIC
In UNIX or NT/Windows 2000 does have Oracle Assitance
tool to create database.

***********database Link ******************
1. Configure TNSNAME to point to remove database.
2. Ping the remove database with tnsping(command).
e.g
tnsping servicename - if this return yes then the remove database is up and this means the link is worked.

3. Create the database link in the database with this command.

CREATE DATABASE LINK dblinkname
CONNECT TO username IDENTIFIED BY password
USING 'servicename in tnsname';

4. After create the database link. Try to query the table on remove database.

SELECT * FROM tab@dblinkname;
if this query is return the table then this dblink is working.

Note:
- For security reason, db link should create by a user. The admin can use this user to grant access right to other user.
oracle dba [message #66544 is a reply to message #66267] Sat, 27 July 2002 03:46 Go to previous messageGo to next message
Rangarajan
Messages: 4
Registered: October 2001
Junior Member
Sir,

I have few doubt .. but i wantt to exact answer for this

i have 3 yrs of experience in DBA.. but this question i could't able to answer

1. i am going to create 10 GB database in Unix machine

in oldb environment...

what are the parameter settings in OS i have to set

semaphore size like that and what should the the value

2. what is the SGA size should i set

3. what is the Temporary tablespace should i set

4. How many rollback segement and what is the size of that

5. how many users i can set

6. how many tablespace i can create

tell me the exact answer
Re: oracle dba [message #66548 is a reply to message #66267] Mon, 29 July 2002 07:30 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
your question is more in real system, all these question is difference in difference system, difference implementation and business process.

>> 1. i am going to create 10 GB database in Unix machine in oldb environment...what are the parameter settings in OS i have to set

the db block size should be few os block size

>> 2. what is the SGA size should i set

depent on your memory on your machine, available memory, and request by your business requirement...

>> 3. what is the Temporary tablespace should i set

depent on system, datawarehause needs more temp for sorting,

>> 4. How many rollback segement and what is the size of that

depent on system, more transaction needs more rollback, and sometime data patch needs more rollback ..

>> 5. how many users i can set

depent on system, number is based on requirement ..

>> 6. how many tablespace i can create

depent on system, few application should have few tablespace for better maintenace ..

Sorry no to get exact answer, because difference system needs difference requirement. all these are need to go through problem, analyze and tuning to get and best parameter for a system.

Hope this is helping.
Previous Topic: Re: Getting ORA-01034 Oracle not available error ,even though database is up
Next Topic: ORA-12154: TNS:could not resolve service name
Goto Forum:
  


Current Time: Thu Mar 28 06:59:06 CDT 2024