Re: complete newbie

From: Jackie <jackie_at_nospaplanet51.zzn.com>
Date: Fri, 12 Mar 2004 23:06:04 -0000
Message-ID: <c2tfpa$228ktv$1_at_ID-28118.news.uni-berlin.de>

"Turkbear" <john.g_at_dot.spamfree.com> wrote in message news:gk8450pavifoak0gt6p9l1hh0f2o7a60pm_at_4ax.com...
> "Jackie" <jackie_at_nospaplanet51.zzn.com> wrote:
>
> >
> >"Turkbear" <john.g_at_dot.spamfree.com> wrote in message
> >news:k72v409j8uhftn0gi5ofnlh4g3388137aa_at_4ax.com...
> >> "Jackie" <jackie_at_nospaplanet51.zzn.com> wrote:
> >>
> >> >
> >> >"Turkbear" <john.g_at_dot.spamfree.com> wrote in message
> >> >news:3qsu409f4uelq0c1vsa9imfr9971uptk94_at_4ax.com...
> >> >> "Jackie" <jackie_at_nospaplanet51.zzn.com> wrote:
> >> >>
> >> >> >Hi I have installed oracle SQL*Plus: Release 8.1.7.0.0 and Oracle
> >Reports
> >> >> >6i - oracle1 to help me with my college work. However I cannot get
> >into
> >> >the
> >> >> >report builder as I do not know what to put into the connect
database
> >> >field.
> >> >> >I at present put system and manager in the user and password field
for
> >> >> >SQL*Plus: Release 8.1.7.0.0 but no matter what I put into the
connect
> >box
> >> >I
> >> >> >get and error message unable to connect to the specified database.
> >> >> >
> >> >> >I installed oracle on my computer at home so that I could practice
my
> >> >> >college work but it is not much good if I cannot practice report
> >> >building.
> >> >> >Any ideas?
> >> >> >Thanks Jackie
> >> >> >
> >> >>
> >> >> Did you, in addition to what you listed, actually create a database?
> >> > Yes I did create a database it is called jackie. there is also one
> >called
> >> >orac created when I installed the program.
> >> >
> >> >Jackie
> >> >
> >> Did you run the Sqlnet configuration wizard and, if so, what alias did
you
> >assign to those instances -
> >> As a quick check, look into <youroraclehome>/network/admin
> >> for a file called tnsnames.ora and see what aliases are in it.
> >> Use one of those as the connect database entry.
> >Hi I have still not managed to get any further with connecting to make
> >reports. Nor have I been able to find the Sqlnet configuration wizard.
> >Perhaps it is on my computer with a different name. Is there default
> >settings I could use? I aready use system as user and manager as password
> >and orac as host string. These do not allow access to report builder. I
get
> >an error message
> >
> >REP-0501: Unable to connect to the specified database.
> >
> >ORA-12154: TNS: could not resolve service name
> >any further suggestions?
> >
>
> It is actually called the Net Configuration Assistant and should be on
your start menu..
> Is the orac instance up and running? Is your listener running?
> to find out:
> go to a cmd window ( dos prompt)
> go to oracle_home/bin
> type lsnrctl status
> and see what you get..
> also,
> Look at your tnsnames.ora file and see where 'orac' is 'pointing' (
server, port , etc)
>

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

ORAC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = winxp)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = orac)
    )
  )

The above is what is in tnsnames.ora

D:\Documents and Settings\Ronald>lsnrctl status

LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 12-MAR-2004 22:55:
00

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 -

Produc
tion

Start Date                12-MAR-2004 13:21:17
Uptime                    0 days 9 hr. 33 min. 43 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   D:\oracle\network\admin\listener.ora
Listener Log File         D:\oracle\network\log\listener.log
Services Summary...
  PLSExtProc            has 1 service handler(s)
  orac          has 1 service handler(s)
  orac          has 2 service handler(s)
  ron           has 1 service handler(s)
  ron           has 2 service handler(s)
  jackie                has 1 service handler(s)
  jackie               has 2 service handler(s)

The command completed successfully

Hi the above is what I get when I type lsnrctl status Received on Sat Mar 13 2004 - 00:06:04 CET