New to Oracle8i, please help!

[draissam]

Hello Forum,

I am new to Oracle, and would appreciate your help.
I have installed Oracle8i Ent. edition on my PC, and want to use the database that comes with it. My problems are:
1- I am able to access the database through SQL+, however, doing it through Toad is not possible. I keep getting an ORA-12541:TNS:no listener. I made sure my listener is started but the error is stil coming up.
2- When I access the database through SQL+, using the scott/tiger login, I am not able to see any database.
In SQL there is a Pubs default database that come with the SQL server. Is there something similar in Oracle, or do I have to create my own tables, and populate them with some data.
3- Prior to installing Oracle8i, I have installed Developer2000. Dev.2000 oracle home is on the d drive (drant), and Oracle8i home is on the c drive (crahome8i). I have 2 tnsnames.ora files. I am attaching a copy of them, and would appreciate if you could tell me if there is anything wrong with the files. Thanks!


"# TNSNAMES.ORA Network Configuration File: C:\orahome8i\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = na-f0v5zxbwhysc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db)
)
)
(CONNECT_DATA=
(SID=<db>)
[ (GLOBAL_NAME=<db>) ]
)"

"Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
NmpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION=(address_list=
(ADDRESS=
(PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
(ADDRESS=
(PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
(CONNECT_DATA=(SID=ORCL))
(SOURCE_ROUTE=yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC0)
)
(CONNECT_DATA = (SID = extproc)
)
)"

 

[SantaMufasa]

Draissam,

Welcome to the Oracle 8i Forum !

Before I suggest a solution, we need to gather a bit more information:

1) Confirm the name of your Oracle instance: Navigate: Start...Settings...Control Panel...Administrative Tools...Services. Scroll down to an item on your Services list with the name format "OracleService<SID>". When I refer, later, to "<SID>", use the string that appears following "OracleService...".

2) Confirm the name of your PC: Navigate: Start...Settings...Control Panel...System...Network Identification. On that page, note the "Full Computer Name". When I refer, later, to "Host", use the value that appears for "Full Computer Name".

3) Confirm the settings for Oracle-related system variables: From a Windows command prompt, issue the command, "set". This displays your current system variables. Please post the Oracle-related variables and their values, including your "Path=" setting.

4) Confirm the contents of "listener.ora" file: It would be best to post the contents of your listener.ora file here so we can confirm correct contents. You should find that file in your %ORACLE_HOME%\network\admin directory. (If you wish to obscure your "host = " and "SID_NAME = " entries, that is fine, just as long as the values for those entries match your findings in Steps 2) and 1), respectively.)

5) Confirm the contents of "sqlnet.ora" file: Please post the contents of that file. That file also typically resides in your %ORACLE_HOME%\network\admin directory. If you cannot locate that file, please note that here.

Please post the findings from your discoveries, above. Then we can better help you.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[draissam]

Mufasa,

Thank you for your willingness to help.
I have the following answers to your questions:

1) Confirm the name of your Oracle instance:
SID=DB

2) Confirm the name of your PC:
Full computer Name: na-f0v5zxbwhysc

3) Confirm the settings for Oracle-related system variables:
CLASSPATH=C:\orahome8i\orb\classes\yoj.jar;C:\orahome8i\orb\classes\share.zip;Path=C:\Program Files\Oracle\jre\1.1.7\bin;D:\orant\bin;C:\orahome8i\orb\bin

4) Confirm the contents of "listener.ora" file:
# LISTENER.ORA Network Configuration File: C:\orahome8i\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = na-f0v5zxbwhysc)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = na-f0v5zxbwhysc)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\orahome8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = db)
(ORACLE_HOME = C:\orahome8i)
(SID_NAME = db)
)
)


5) Confirm the contents of "sqlnet.ora" file:
# SQLNET.ORA Network Configuration File: C:\orahome8i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


I would also like to mention that I have tried again login into the database through SQL+ using scott/tiger, but I wasn't able to. I kept getting the message:"ERROR:
ORA-12560: TNSrotocol adapter error"

Thanks a lot for your assistance.

Cheers!

 

[KenCunningham]

Re. 3

Do you have settings for ORACLE_HOME and ORACLE_SID?

 

[SantaMufasa]

Ken is correct: whenever you receive "...protocol adapter error...", it is typically because the ORACLE_HOME system variable is not set to your proper ORACLE_HOME directory.


Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[draissam]

What can I do to correct this?

 

[SantaMufasa]

First, to confirm that this is your problem/solution, you can issue the following commands, either from the command prompt or in a batch (.bat) file:

set ORACLE_HOME=C:\orahome8i
set ORACLE_SID=db

Once you do that, retry your connection(s) to Oracle. If it works properly, then you can "institutionalise" your changes...(Here are the navigations on my Windows2000 system):

System...Settings...Control Panel...System...("Advanced" tab)...(System variables)...[New]...(Variable Name): ORACLE_HOME...(Variable Value): C:\orahome8i.

...then do the same for ORACLE_SID.

Let us know the outcome.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[SantaMufasa]

Oops...The first navigation should be "Start" (not "System"). But they both begin with "S", right

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.