[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2588
  • Last Modified:

Oracle 9i Personal Edition set up problem

I installed Oracle 9i Personal Edition from Oracle's site. After installation was complete, and I tried to connect to the database. I put in system/manager. When I click on Ok, I get the message ORA-12545: Connect failed because target host or object does not exist. Any ideas?
0
mfarid1
Asked:
mfarid1
  • 11
  • 10
  • 5
1 Solution
 
n8pttCommented:
if under linux you may need to start the listener: lsnrtcl start
ora-12545 is typically a dns error. check your tnsnames.ora
0
 
mfarid1Author Commented:
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


0
 
mfarid1Author Commented:
Anything specific I should look for in tnsnames.ora?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
n8pttCommented:
line that has: host =
it may have a dns name, try putting in the ip address instead.
0
 
mfarid1Author Commented:
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?
0
 
n8pttCommented:
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.
0
 
actonwangCommented:
you can use loopback adaptor to resovle your problem:

http://download-west.oracle.com/docs/html/B10130_02/reqs.htm#BABGCEAI
0
 
mfarid1Author Commented:
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.

0
 
actonwangCommented:
did you try to use sqlplus to connect to it?

also look at your tnsname.ora to see what is in there?
0
 
mfarid1Author Commented:
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.
0
 
actonwangCommented:
>>DSTAGE_DSTAGE =
  (DESCRIPTION =
    (ADDRESS_LIST =

    did you try tnsping dstage_dstage to verify the entry?
0
 
actonwangCommented:
issue :

tnsping DSTAGE_DSTAGE
0
 
actonwangCommented:
also, why is it called "DSTAGE_DSTAGE"?
0
 
mfarid1Author Commented:
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)
0
 
actonwangCommented:
what is your error when you do:

sqlplus user/pass@DSTAGE_DSTAGE
0
 
mfarid1Author Commented:
Error:
ora-12505: TNS: Listener could not resolve SID given in connect descriptior
0
 
actonwangCommented:
you said, you can do:

tnsping DSTAGE_DSTAGE


?
0
 
mfarid1Author Commented:
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)
0
 
actonwangCommented:
>>(CONNECT_DATA = (SID = 127.0.0.1) (SERVER = DEDICATED)))
     What is your db's SID? you need to change this.
     
0
 
mfarid1Author Commented:
My SID was dstage before I changed it to 127.0.0.1.
0
 
actonwangCommented:
what is your sqlnet.ora?
0
 
actonwangCommented:
and also your listener.ora.
0
 
n8pttCommented:
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?
0
 
mfarid1Author Commented:
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.
0
 
mfarid1Author Commented:
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.
0
 
n8pttCommented:
You needed an IP number from the nic card and didn't have that. You could hardwire and IP number to the nic card during installation with it disconnected that might work. by default nothing uses the loopback address (127.0.0.1), almost every program I've ever used (or written) grabs the IP number from the nic card which in the case of not being connected to internet... there isn't one.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 11
  • 10
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now