Thanks Howard,
Thanks for your advice.But last time when I installed oracle on that
time I faced a probs and solved that through tnsnames.ora.My os is
windows 2003 advance server.
Regards
Arijit Chatterjee
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<40d13bc4$0$3498$afc38c87_at_news.optusnet.com.au>...
> "Arijit Chatterjee" <arijitchatterjee123_at_yahoo.co.in> wrote in message
> news:ea01504d.0406162215.58a41e16_at_posting.google.com...
> > Hi,
> > I am new in Oracle.Yesterday I installed oracle 9i.On that time I
> > created a database called FirstDB after that through Db Creation
> > Wizard I created another database called SecondDB.
> >
> > 1.Now how can I access the SecondDB.
>
> Learn how to use a tnsnames.ora, or exploit your ORACLE_SID environment
> variable.
>
> > After successful creation of SecondDB I got a message your userid is
> > change_on_install and password manager and sid secondDB.But after
> > creation ,through this user id and password and SID I couldn't able to
> > connect the database.
>
> See above.
>
> > Today I think I did some wrong thing.
> > I went to TNSNAMES.ORA and change the port of SecondDB because
> > FirstDB and seconddb had same port no ..1521.I made secondDB as 1520.
>
> Also learn a bit about how Oracle net services work. The tnsnames.ora
> defines how you connect to a *listener*, not an instance. And your listener
> wouldn't suddenly have changed port, just because you created a new
> database. Leave the port at 1521.
>
> > After that I couldn't able to connect my FirstDb also.
> >
> > Please Suggest me.How to resolve this issue.Plz don't refer me to
> > metalink.
> > Because I don't have any ID.
>
> OK, I won't refer you to Metalink. Well, I wouldn't have done that in any
> case, because that's not the most user-friendly environment I've ever come
> across. All you need do is visit http://tahiti.oracle.com. Search the
> documentation for 9i. It's all there, but I suggest you start with the
> concepts guide, and then the networking stuff.
>
> In future, always include your operating system, since the answer to
> questions often varies depending on that. If I told you to type set
> ORACLE_SID=SecondDB, or to type export ORACLE_SID=SecondDB, one will work
> and one won't, but I have no idea which, because I don't know your O/S.
>
> Regards
> HJR
>
>
>
>
> > Regards
> > Arijit Chatterjee
Received on Thu Jun 17 2004 - 04:43:32 CDT
