Re: complete newbie

On Fri, 12 Mar 2004 19:43:15 -0000, "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?
>

Goto the Oracle Program Group. Choose 'Network Administration', fire up 'Net8 Configuration Assistant'
Please try to read the 'Getting Started Manual' before asking documented FAQs.

--
Sybrand Bakker, Senior Oracle DBA