Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
5 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Creating new database and a parameter file
Posted on 2012-12-24
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
13
8
2- +1
24 Comments
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
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
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/
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.
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/
praqveen, I am trying to follow the steps but when I get to running
CREATE SPFILE FROM PFILE=’/home/oracle/produc
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
before executing the above command you have to login to DB i.e
#sqlplus / as sysdba
SQL>startup nomount pfile=/home/oracle/product
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1341312 bytes
Variable Size 620759168 bytes
Database Buffers 444596224 bytes
Redo Buffers 4636672 bytes
SQL>CREATE SPFILE FROM PFILE=’/home/oracle/produc
I think these paticular step is missing you can go through the doc in my post 38719026
#sqlplus / as sysdba
SQL>startup nomount pfile=/home/oracle/product
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1341312 bytes
Variable Size 620759168 bytes
Database Buffers 444596224 bytes
Redo Buffers 4636672 bytes
SQL>CREATE SPFILE FROM PFILE=’/home/oracle/produc
I think these paticular step is missing you can go through the doc in my post 38719026
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
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
The alertlog will be present only when your database is created, so first create the database.
try execueting sqplus /nolog once you get SQL prompt then execute below stepts top create the database.
SQL>startup nomount pfile=/home/oracle/product
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1341312 bytes
Variable Size 620759168 bytes
Database Buffers 444596224 bytes
Redo Buffers 4636672 bytes
SQL>CREATE SPFILE FROM PFILE=’/home/oracle/produc
if still you are getting an error, can you post the error meassage and the listener.ora details.
try execueting sqplus /nolog once you get SQL prompt then execute below stepts top create the database.
SQL>startup nomount pfile=/home/oracle/product
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1341312 bytes
Variable Size 620759168 bytes
Database Buffers 444596224 bytes
Redo Buffers 4636672 bytes
SQL>CREATE SPFILE FROM PFILE=’/home/oracle/produc
if still you are getting an error, can you post the error meassage and the listener.ora details.
I started sqlplus with
sqlplus /nolog
and as soon as I ran
startup nomount pfile=/home/oracle/product
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
and get this details as well
#lsnrctl status
<ORACLE_HOME>/network/admi
and get this details as well
#lsnrctl status
I did and listener is started successfully but it also says "The listener supports no services". What does that mean?
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
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
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
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
can someone tell me if my env variables look correct?
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
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
Featured Post
Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC
Introduction
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Datapump Export Utility. The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses
Course of the Month5 days, 15 hours left to enroll
707 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.