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:
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
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
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.
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.
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.
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 /nologSQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 28 13:44:48 2012Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL> connect / as sysdbaERROR:ORA-12547: TNS:lost contact
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