SampleSchemassLogin

I have 10g and 11g enterprise edition installed on 1 machine but i cant log in to any instance or database to test some things.

Does anyone know the default schemas installed and what is the user/passwod and instance to log in using sql*plus.
sam15Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sdstuberCommented:
the samples aren't installed by default and when they are the accounts are usually locked

if you installed them you were prompted to enter passwords.

If you have lost those passwords then log in as the oracle owner (usually called "oracle" or an administrator account in windows)

then start

sqlplus  / as sysdba


this will log you in as SYS,  from there you can unlock accounts and reset your passwords as needed
0
slightwv (䄆 Netminder) Commented:
It might be a tnsnames.ora or config issue between the versions.

How are you trying to connect?  What errors are you getting?
0
slightwv (䄆 Netminder) Commented:
The two most common test schemas are:
scott/tiger and hr/hr

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

sam15Author Commented:
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:



0
slightwv (䄆 Netminder) Commented:
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.

0
sam15Author Commented:
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
0
slightwv (䄆 Netminder) Commented:
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.
0
sam15Author Commented:
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.
0
slightwv (䄆 Netminder) Commented:
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.
0
sam15Author Commented:
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.
0
slightwv (䄆 Netminder) Commented:
>>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.
0
sam15Author Commented:
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?
0
slightwv (䄆 Netminder) Commented:
I believe the exam you mention uses the HR schema.

The HR schema should be there.

But if not check out:
Installing the HR Database Objects

http://download.oracle.com/docs/cd/B31036_01/doc/appdev.22/b28839/about.htm#BABFJIDH
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.