Re: complete newbie

[Quoted] "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?
>

[Quoted] It is actually called the Net Configuration Assistant and should be on your start menu.. [Quoted] 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)

hth,
JOhn Received on Fri Mar 12 2004 - 21:54:18 CET