tooki
asked on
Oracle Install -- sqlplus window...
I installed Oracle9i software (9i Database) on my
Unix Solaris8 machine. Installation was completed successfully.
Now how can I launch "sqlplus"??
Also, per the documentation there should have been a file
named inittestdb.ora (SID is "testdb") in the firectory
"$ORACLE_BASE/admin/testdb /pfile/". But this directory is
empty after the installation.
Pleas elet me know.
tooki
Unix Solaris8 machine. Installation was completed successfully.
Now how can I launch "sqlplus"??
Also, per the documentation there should have been a file
named inittestdb.ora (SID is "testdb") in the firectory
"$ORACLE_BASE/admin/testdb
empty after the installation.
Pleas elet me know.
tooki
ASKER
Yes, there are two files
init.ora and initdw.ora in $ORACLE_HOME/dbs, they
look like default ones. But no file named
inittestdb.ora....
Also what actually do I need to do now to get
access to the database that I just created.
By acces I mean, sqlplus window, etc.
Thanks.
-tooki
init.ora and initdw.ora in $ORACLE_HOME/dbs, they
look like default ones. But no file named
inittestdb.ora....
Also what actually do I need to do now to get
access to the database that I just created.
By acces I mean, sqlplus window, etc.
Thanks.
-tooki
One again from the beginning.
You ran the Database Configuration Assistant (dbca).
(If you saved your settings as template you are able
repeat the creation.)
The dbca created the directories according to OFA and
did not put your init.ora there. But there must be a
file named "init.ora" (the right one) somewhere because
the database cannot be created (CREATE DATABASE...)
without having the instance up. And as you said (?) the
database was created, you have got your datafiles
(e.g "$ORACLE_BASE/oradata/test db/SYSTEMx xxx.DBF").
Hmm... strange to me. We need to find the right init.ora
or you have to copy and edit an existing sample.
initdw.ora is a sample for datawarehouses.
Have a closer look at the init.ora. Is instance_name ="testdb"?
If yes, it's the one we are looking for. Copy it to the desired location.
Startin sqlplus. Well you can run
sqlplus /nolog
sql> connect sys/**** as sysdba
sql> startup pfile='full_path_of_initor a'
Good luck,
-- Sven
You ran the Database Configuration Assistant (dbca).
(If you saved your settings as template you are able
repeat the creation.)
The dbca created the directories according to OFA and
did not put your init.ora there. But there must be a
file named "init.ora" (the right one) somewhere because
the database cannot be created (CREATE DATABASE...)
without having the instance up. And as you said (?) the
database was created, you have got your datafiles
(e.g "$ORACLE_BASE/oradata/test
Hmm... strange to me. We need to find the right init.ora
or you have to copy and edit an existing sample.
initdw.ora is a sample for datawarehouses.
Have a closer look at the init.ora. Is instance_name ="testdb"?
If yes, it's the one we are looking for. Copy it to the desired location.
Startin sqlplus. Well you can run
sqlplus /nolog
sql> connect sys/**** as sysdba
sql> startup pfile='full_path_of_initor
Good luck,
-- Sven
ASKER
Sven,thanks for your help.This is what I did so far:
Mine is Solaris8 OS and I have installed Oracle9i
Enterprise Edition (3 CD's that I required).
During installation, I provided SID=testdb.
Out of various choices, I chose to install
"Oracle9i Database". Then I chose "Enterprise Edition",
with the configuration of "General Purpose".
These are all the information that I have provided
during the installation. (Some other info like
$ORACLE_HOME, $ORACLE_BASE, etc. were obtained
from the environment variables).No error occurred
during installation (I had to run root.sh per the
instruction once during installation).
At the end, I was shown "Installation successful".
And I exited.
I have checked that the directory
"$ORACLE_BASE/oradata/test db/" exists but it is
empty (no .dbf file). Never I specified any datafile/control file/etc. locations during
installation!
Inside the init.ora file instance_name =default
(not "testdb").
DBCA (Database Configuration Assistant), I think
is the part of the above installation, I am not sure.
Do I need to install anything separately, apart
from the above installation?
So you see, I am not sure if the database has been
created!!Apologize I have no experience..
I have run "sqlplus /nolog" several times,
but it says "sql/plus" unknown option....
So cannot run it....
Please help me...thanks.
skundu
Mine is Solaris8 OS and I have installed Oracle9i
Enterprise Edition (3 CD's that I required).
During installation, I provided SID=testdb.
Out of various choices, I chose to install
"Oracle9i Database". Then I chose "Enterprise Edition",
with the configuration of "General Purpose".
These are all the information that I have provided
during the installation. (Some other info like
$ORACLE_HOME, $ORACLE_BASE, etc. were obtained
from the environment variables).No error occurred
during installation (I had to run root.sh per the
instruction once during installation).
At the end, I was shown "Installation successful".
And I exited.
I have checked that the directory
"$ORACLE_BASE/oradata/test
empty (no .dbf file). Never I specified any datafile/control file/etc. locations during
installation!
Inside the init.ora file instance_name =default
(not "testdb").
DBCA (Database Configuration Assistant), I think
is the part of the above installation, I am not sure.
Do I need to install anything separately, apart
from the above installation?
So you see, I am not sure if the database has been
created!!Apologize I have no experience..
I have run "sqlplus /nolog" several times,
but it says "sql/plus" unknown option....
So cannot run it....
Please help me...thanks.
skundu
I see. Sofar you had installed the Oracle software
sucessfully.
But a database wasn't created. Try to run dbca now.
-- Sven
sucessfully.
But a database wasn't created. Try to run dbca now.
-- Sven
ASKER
Thanks. OK, now I have run Databse Configuration Assistant
($ORACLE_HOME/bin/dbca).
Everything was going fine, but it gave me error at the
final step.
So far I have installed the Oracle 9i software successfully. The SID was "testdb".
When I ran "dbca", it gave me 4 options.First two were:
Option#1:Create a database
Option#2:Configure databse options in a database.
Seemed I should choose Option#1. When I choose option#1,
after choosing data/control/redo log file locations,etc., it says "Oracle Database Configuration Assistant Error". "The Oracle system ID (SID) testdb already exists. Specify another SID.
I do not know what is happening...
Then I try with option#2.The next step asks "Select the instance for the database that you want to configure database options for"
Available instances: "testdb". (it shows by itself)
I click "testdb", next step shows me error:
"ORA-01078: failure in processing system parameters"
Please help....
I have declared all system parameters and set the environment variables per the installation guide...
thanks.
-tooki
($ORACLE_HOME/bin/dbca).
Everything was going fine, but it gave me error at the
final step.
So far I have installed the Oracle 9i software successfully. The SID was "testdb".
When I ran "dbca", it gave me 4 options.First two were:
Option#1:Create a database
Option#2:Configure databse options in a database.
Seemed I should choose Option#1. When I choose option#1,
after choosing data/control/redo log file locations,etc., it says "Oracle Database Configuration Assistant Error". "The Oracle system ID (SID) testdb already exists. Specify another SID.
I do not know what is happening...
Then I try with option#2.The next step asks "Select the instance for the database that you want to configure database options for"
Available instances: "testdb". (it shows by itself)
I click "testdb", next step shows me error:
"ORA-01078: failure in processing system parameters"
Please help....
I have declared all system parameters and set the environment variables per the installation guide...
thanks.
-tooki
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sven..thanks..it worked...
I deleted the database then reinstalled
with the same SID....
thanks a lot.-tooki
I deleted the database then reinstalled
with the same SID....
thanks a lot.-tooki
just called "init.ora"
Your inittestdb.ora should be in "$ORACLE_HOME/dbs" (or \database on NT)
and usally has got one line with IFILE= pathname of the init.ora
Is there a file?
-- Sven