SampleSchemassLogin

It might be a tnsnames.ora or config issue between the versions.

How are you trying to connect?  What errors are you getting?

The two most common test schemas are:
scott/tiger and hr/hr

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 7 23:42:01 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

i tried scott/tiger and hr/hr and i get same TNS error

Is this because a missing tnsnames.ora file file.


Enter user-name:

It could be a couple things.

Go through the checklist on:
http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm

What OS are you using?
Make sure the database(s) are running.
Make sure there is a listener running and the database/instance is registered with the running listener.   You can have a single listener to cover databases from both Oracle versions you have.  I would probably go with the 11g version since it's the newest.

I started the listener but i think the DB is not up. How do you normally find out the DBs installed names and start them.

LSNRCTL> start
Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is C:\app\ggs\product\11.2.0\client_2\network\admin\listen
er.ora
Log messages written to c:\app\ggs\product\11.2.0\client_2\log\diag\tnslsnr\GLDD
IT12190\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=INT12190.silverlnk.root
lnka.net)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                08-APR-2011 09:14:34
Uptime                    0 days 0 hr. 0 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\ggs\product\11.2.0\client_2\network\admin\liste
ner.ora
Listener Log File         c:\app\ggs\product\11.2.0\client_2\log\diag\tnslsnr\INT12190\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=INT12190.goldlnk.rootlnka.net)(PO
RT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL>


C:\>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 8 09:16:10 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

There are no instances being listened to on that listener.

>>How do you normally find out the DBs installed names and start them.

On a Windows machine there will be an OracleService<SID NAME> for each SID.  Just start those.  That will at least get you to where you should be able to connect.  That database might not start but we'll cover that when we get there.

Which file you refer to? Listner.ora or tnsnames.ora or other file.

I am wiondering if the software on this machine is not complete.

I see Programs-->Oracle - Oracle 11g - home 2 --->
Application Development
Configuration and Migration Tools
Integration Management Tools
Oracle installation products


If i am missing things here let me know so i uninistall and reinstall the software.

I'm really not referring to a file.  Staring in 10g whenever a database instance is started it is supposed to automatically register itself with the listener.

Early on there were some bugs and you had to manually add the instance to the listener.ora file.  If you want to do that, then it does involve the file.

As far as the OracleService comment, those are displayed in the Windows Services window.

yes, i did find the service in windows and hit start. It stops right away and say that some service are stopped if they have no work to do.

Do you think i should remove and reinstall the software on this machine.

>>Do you think i should remove and reinstall the software on this machine.

I doubt that will help unless you received errors on the install.

>>It stops right away and say that some service are stopped if they have no work to do.

Check the alert log for that database.  There should be a reason the database didn't start.

i removed the software and reinstalled 10g express. it works fine and should be sufficient for training for the SQL exam.. there is XE and OE schemas created. OE needs to be unlocked. I have two accounts SYS and SYSTEM.

Oracle also seems to have released 11g Express BEta but did not install it yet.

Is not there a eal xternscript that can create all those sample schemas and test data?