YZlat
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
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
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/
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/
ASKER
I didn't even notice it was Oracle 8:)
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?
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.
ASKER
looks good, I am gonna try it
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/
https://sites.google.com/site/catchdba/11g-manual-database-creation
http://ack2904.wordpress.com/2009/09/18/database-creating-11gr2/
ASKER
praqveen, I am trying to follow the steps but when I get to running
CREATE SPFILE FROM PFILE=’/home/oracle/produc t/11.2.0.3 /initTEST. ora’;
SQLPlus gives me an error:
ORA-12547: TNS:lost contact
CREATE SPFILE FROM PFILE=’/home/oracle/produc
SQLPlus gives me an error:
ORA-12547: TNS:lost contact
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
actually as soon as I run
sqlplus / as sysdba
I get the error
ORA-12547: TNS:lost contact
sqlplus / as sysdba
I get the error
ORA-12547: TNS:lost contact
I would say the instance is not up.
so you need to check the instance's alertlog file to see "why" this is so
so you need to check the instance's alertlog file to see "why" this is so
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
There isn't a database created yet. It's just a server with only software installed
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I started sqlplus with
sqlplus /nolog
and as soon as I ran
startup nomount pfile=/home/oracle/product /11.2.0.3/ dbs/initTE ST.ora;
I got
ORA-12547: TNS:lost contact
sqlplus /nolog
and as soon as I ran
startup nomount pfile=/home/oracle/product
I got
ORA-12547: TNS:lost contact
i think it as to do with some permission issues, check this doc
http://www.dbvisit.com/forums/showthread.php?p=3058
http://www.dbvisit.com/forums/showthread.php?p=3058
also can you post the listener.ora file details which is present in the directory
<ORACLE_HOME>/network/admi n/listener .ora
and get this details as well
#lsnrctl status
<ORACLE_HOME>/network/admi
and get this details as well
#lsnrctl status
ASKER
I did and listener is started successfully but it also says "The listener supports no services". What does that mean?
ASKER
praveen, the permissions for the oracle file are -rwsr-s--x which looks about right
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
Be sure that your are connected with oracle user and all enviroment variables are setting properly.
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/initTE ST.ora;
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
ASKER
@Gon75, already did
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
ASKER
can someone tell me if my env variables look correct?
ORACLE_BASE=/u10/app/oracl e
ORACLE_HOME=/u10/app/oracl e/product/ 11.2.0.3
ORACLE_SID=TESTDB
ORAENV_ASK=YES
LD_LIBRARY_PATH=/u10/app/o racle/prod uct/11.2.0 .3/lib:/u1 0/app/orac le/product /11.2.0.3/ lib
PATH=/home/oracle:/usr/loc al/bin:/us r/bin:/etc :/usr/sbin :/usr/ucb: /home/orac le/bin:/us r/bin/X11: /sbin:.:/u 10/app/ora cle/produc t/11.2.0.3 /bin
ORACLE_BASE=/u10/app/oracl
ORACLE_HOME=/u10/app/oracl
ORACLE_SID=TESTDB
ORAENV_ASK=YES
LD_LIBRARY_PATH=/u10/app/o
PATH=/home/oracle:/usr/loc
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