Avatar of YZlat
YZlat
Flag for United States of America asked on

Creating new database and a parameter file

I am new to Oracle and I am trying to create a database on the UNIX server that has Oracle software installed but no databases created yet. I need to create a databas usign SQL script (not dbca).
I am following these steps:

http://www.csee.umbc.edu/portal/help/oracle8/server.815/a67772/create.htm

My first step is to create a parameter file. I need to create it from scratch and need some help creating it and setting the parameters.

Can someone help me and also provide me with a sample pfile
Oracle DatabaseUnix OS

Avatar of undefined
Last Comment
YZlat

8/22/2022 - Mon
Guy Hengel [angelIII / a3]

really oracle 8?

the parameters (for oracle 8) are shown in step 3 of that page,
the file is a plain ascii file, each line have 1 parameter like:
paramter_name = paramater_value

anyhow, here a sample file shown:
http://psoug.org/reference/init_dot_ora.html
Praveen Kumar Chandrashekatr

if your are looking steps to create a 8.1.7 database here is the document.
http://www.akadia.com/services/ora_linux_install.html

if it is 10g and above here is the doc for step by step procedure.

http://kamranagayev.com/2009/05/31/create-database-manually-step-by-step-instruction/
YZlat

ASKER
I didn't even notice it was Oracle 8:)
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
YZlat

ASKER
Actually I am using 11g. I have just installed ORacle 11g software without a database and now I am attempting to create my first database. There is no listener file on the server. Do I need to create that one as well? And tnsname.ora too?
Praveen Kumar Chandrashekatr

yes you have to create a listener and tnsnames.ora file as well, you can go with my second doc which as given step by step procedure.
YZlat

ASKER
looks good, I am gonna try it
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Praveen Kumar Chandrashekatr

here some more doc on step by step process for creation oracle 11g database manually

https://sites.google.com/site/catchdba/11g-manual-database-creation

http://ack2904.wordpress.com/2009/09/18/database-creating-11gr2/
YZlat

ASKER
praqveen, I am trying to follow the steps but when I get to running

CREATE SPFILE FROM PFILE=’/home/oracle/product/11.2.0.3/initTEST.ora’;

SQLPlus gives me an error:

ORA-12547: TNS:lost contact
ASKER CERTIFIED SOLUTION
Praveen Kumar Chandrashekatr

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
YZlat

ASKER
actually as soon as I run

sqlplus / as sysdba

I get the error

ORA-12547: TNS:lost contact
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Guy Hengel [angelIII / a3]

I would say the instance is not up.
so you need to check the instance's alertlog file to see "why" this is so
YZlat

ASKER
how do I check this log? I am very new to all this

There isn't a database created yet. It's just a server with only software installed
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
YZlat

ASKER
I started sqlplus with

sqlplus /nolog

and as soon as I ran

startup nomount pfile=/home/oracle/product/11.2.0.3/dbs/initTEST.ora;

I got

ORA-12547: TNS:lost contact
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Praveen Kumar Chandrashekatr

i think it as to do with some permission issues, check this doc

http://www.dbvisit.com/forums/showthread.php?p=3058
Praveen Kumar Chandrashekatr

also can you post the listener.ora file details which is present in the directory
<ORACLE_HOME>/network/admin/listener.ora

and get this details as well
#lsnrctl status
YZlat

ASKER
I did and listener is started successfully but it also says "The listener supports no services". What does that mean?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
YZlat

ASKER
praveen, the permissions for the oracle file are -rwsr-s--x  which looks about right
YZlat

ASKER
Looks like "listener supports no services" means that there is no database started, which is about right since there is no database there to begin with
Gon75

Be sure that your are connected with oracle user and all enviroment variables are setting properly.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Praveen Kumar Chandrashekatr

you are goining step by step right as mentioned in previous post links

exporting the ORACLE_HOME, ORACLE_SID, LD_LIBIRARY_PATH, ORACLE_BASE and then the below steps

1) sqlplus /nolog
2)SQL> connect / as sysdba
connected to ideal instance
3)SQL> startup nomount pfile=/home/oracle/product/11.2.0.3/dbs/initTEST.ora;
YZlat

ASKER
@Gon75, already did
YZlat

ASKER
praveen, here is what happened:

> sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 28 13:44:48 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-12547: TNS:lost contact

Open in new window

Your help has saved me hundreds of hours of internet surfing.
fblack61
YZlat

ASKER
can someone tell me if my env variables look correct?

ORACLE_BASE=/u10/app/oracle
ORACLE_HOME=/u10/app/oracle/product/11.2.0.3
ORACLE_SID=TESTDB
ORAENV_ASK=YES
LD_LIBRARY_PATH=/u10/app/oracle/product/11.2.0.3/lib:/u10/app/oracle/product/11.2.0.3/lib
PATH=/home/oracle:/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.:/u10/app/oracle/product/11.2.0.3/bin