Oracle 9i Personal Edition set up problem

if under linux you may need to start the listener: lsnrtcl start
ora-12545 is typically a dns error. check your tnsnames.ora

Under Windows. Here is the status of the services I see:

OracleOraHome92Agent: When I try to start it manually, it gives me the following message:
"Could not start the OracleOraHome92Agent service on Local Computer. Error 259: No more data is available."

OracleOraHome92ClientCache: When I try to start it manually, it gives me the following message:
"Could not start the OracleOraHome92Agent service on Local Computer. Error 1067: The process terminated unexpectedly."

OracleOraHome92PagingServer: Started and then stopped. Seome services stop automatically if they have no work to do, for example, the Performance Log and Alerts service.

OracleOraHome92SNMPPeerEncapsulator: Started

OracleOraHome92SNMPPeerMasterAgent: Started

OracleOraHome92TNSListener: Started

Anything specific I should look for in tnsnames.ora?

line that has: host =
it may have a dns name, try putting in the ip address instead.

I have Windows 2003 Server. My machine is a standalone machine. How do I get an IP address? I did ipconfig /all. I get the following:

Host name: home
Primary Dns Suffix:  (blank)
Node Type: Broadcast
IP Routing Enabled: No
WINS PRoxy ENabled: No

Ethernet adapter Local Area Connection:

Media State: Media Disconnected
Description:  3Com 3C920 Integrated Fast Ethernet Controller (3C905C-TX Compatible)
Physical Address: 00-08-74-01-0E-CD

How do I find out what the ip address of my machine in this situation?

Media Disconnected says you are not connected to anything so try using the internal IP address of 127.0.0.1 since it appears you are running sql from the same machine that the database us running on. You can hardwire an IP address by going in "my networking places" properites for local connecton and hardwiring an IP address under tcp/ip properties.

you can use loopback adaptor to resovle your problem:

http://download-west.oracle.com/docs/html/B10130_02/reqs.htm#BABGCEAI

n8pitt, I tried you solution. I changed host = 127.0.0.1. I get a message during login:

SID given in connect descriptot could not be resolved.

I changed the SID to 127.0.0.1. Same message. I changed it to home which is my machine name. Same message.

actonwang, I installed the loopback adapter by following the URL that you gave. I followed every step. The only difference I see is that I don't have a domain name so I had to leave that blank. However, the result is the same. I get the same message:

SID given in connect descriptot could not be resolved.

did you try to use sqlplus to connect to it?

also look at your tnsname.ora to see what is in there?

Yes. I tried everything:

userid: system
password: manager
host string: 127.0.0.1
host string: dstage
host string: 192.168.1.1

My tnsnames.ora is pretty simple:

----------------------------------------------------
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

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

DSTAGE_DSTAGE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = 192.168.1.1)
      (SERVER = DEDICATED)
    )
  )

------------------------------------------

Initially it was DSTAGE instead of 192.168.1.1. I also tried with 127.0.0.1. No luck. Really appreciate your help.

>>DSTAGE_DSTAGE =
  (DESCRIPTION =
    (ADDRESS_LIST =

    did you try tnsping dstage_dstage to verify the entry?

issue :

tnsping DSTAGE_DSTAGE

also, why is it called "DSTAGE_DSTAGE"?

Here is the output of tnsping:


TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JUN-2006 12:23:37

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SID = 127.0.0.1) (SERVER = DEDICATED)))
OK (10 msec)

what is your error when you do:

sqlplus user/pass@DSTAGE_DSTAGE

Error:
ora-12505: TNS: Listener could not resolve SID given in connect descriptior

you said, you can do:

tnsping DSTAGE_DSTAGE


?

Here is the result of tnsping when I do

tnsping dstage_dstage

at the command prompt:


TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JUN-2006 12:23:37

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SID = 127.0.0.1) (SERVER = DEDICATED)))
OK (10 msec)

>>(CONNECT_DATA = (SID = 127.0.0.1) (SERVER = DEDICATED)))
     What is your db's SID? you need to change this.
     

My SID was dstage before I changed it to 127.0.0.1.

what is your sqlnet.ora?

and also your listener.ora.

sid should be changed back to what it was. the @database_name should not be required if you running
on the same PC with only 1 oracle_home on it.
btw: is this windows or linux?

I think my problem is in the installation of Oracle Personal Edition. I reformatted my standalone laptop's hard drive. I then installed Windows 2003 Server. There is no domain but there is a workgroup. I then tried to install Oracle 9i Personal Edition. After choosing the Standard Edition, I get the error message:

 "Thrown when IP address of a host cannot be determined"

and the 4 buttons Help, Retry, Continue and Cancel are shown. I have repeated this process several times. Same thing. I am thinking may be I should be on a network and it'll work.

I reinstalled Oracle 9i Personal Edition after connecting the computer to internet. No problems. I could not connect to the database fine. However, when I disconnected from the internet and tried to connect it won' let me saying "listener not running". I edited listener.ora and for HOST put in the IP address 127.0.0.1. Started the listener. Now, I can connect.

Do I have to have be connected to the internet during installation? It seems like if I put in the IP address manually, it doesn't see it during installation.