Location: Oracle Wiki Discussion Forum

Discussion: creating a databaseReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 4 posts
danrweki
danrweki
creating a database
Sep 20 2009, 12:40 PM EDT | Post edited: Sep 20 2009, 12:43 PM EDT
Hallo all,

Am new to this forum, am a very kin oracle dba still completing my OCA course. Now! i instlled oracle 11g on my linux fedora 10 succesfully with the option of it creating a database and sample schemas.

I wanted to create my own database so i used dbca command, it installed succesfully, but when i shut down my machine and restarted i could not access the db i created my self, but could only access the one the oracle installtion created for me.

when i type lsnrctl services, i do not see my instance listed, only the forma instance.
when i login like sqlplus sys@mydatabase/ as sysdba it gives me the following error,...ORA-12541: TNS:no listener

what shoul i do? i tried tampering wit my .bash_profile file to add this line "ORACLE_SID=mydatabase; export ORACLE_SID" , before adding the line the .bash_profile looks like this

ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

so wat can i do Do you find this valuable?    
pete91z
pete91z
1. RE: creating a database
Sep 23 2009, 11:30 AM EDT | Post edited: Sep 23 2009, 11:30 AM EDT
If you have ORACLE_SID set, you should be able to access your database just by using sqlplus / as sysdba. Do you find this valuable?    

nathan65
2. RE: creating a database
Sep 23 2009, 2:21 PM EDT | Post edited: Sep 23 2009, 2:21 PM EDT
Did you started your instance? Please, check if command "ps -ef | grep -i pmon | grep mydatabase" shows you a line. I supposed your SID equals to "mydatabase", if it isn't so, please change it to your SID value. By the way, do not forget to configure your "tnsnames.ora" or you cannot connect to your DB using SQLPLUS. You can do that using "netca". Regards. /nat Do you find this valuable?    
dbametrix
dbametrix
3. RE: creating a database
Oct 5 2009, 3:36 PM EDT | Post edited: Oct 5 2009, 3:36 PM EDT
In any Unix/Linux box your database doesn't starting default like windows. After rebooting server you should need to start your database in your server box using "startup" command in sqlplus tool.

http://www.dbametrix.com/online-training.html Do you find this valuable?