Re: TNS Problem

I'm guessing that when you run DBSTART you aren't seeing any of the SGA information show up, just the warm started message?

If so, this is a documented bug with 8.1.6. They startup banner inside SVRMGR changed with 8.1.6 and the dbstart program doesn't pick up the new banner.

I don't have the bug # or document ID but if you go to metalink.oracle.com and search for dbstart & 8.1.6 (or 8i) you should be able to find it. The fix just involved adding a few lines to the dbstart program.

HTH,
Roy

In article <O7iHVJ#tAHA.293_at_cpmsnbbsa09>, iqbalkhan1 <iqbalkhan1_at_email.msn.com> writes:
>Hi,
> I recently installed Oracle8i (8.1.6) on Intel Solaris 8. Oracle is
>successfully installed without any errors. When I create the database thru
>dbassist command, the database is also created. I have changed the follwoing
>settings:
>My Oracle Home is /export/home/oracle
>1. /etc/oratab
> test:/export/home/oracle:Y
>
>2. /var/opt/oracle/oratab
> test:/export/home/oracle:Y
>
>3. /etc/hosts
> 192.168.8.1 mars
>
>4. /etc/services
> test 1521/tcp
>
>
>5. /export/home/oracle/.profile
> ORACLE_HOME=/export/home/oracle
> ORACLE_SID=test
> export ORACLE_HOME ORACLE_SID
>
>
>Even the listener.ora and tnsnames.ora looks good.
> But I am still getting TNS unreachable ORA-12154
>
>When I start the test database like this
> $dbstart test
> It returns with
> Database "test" warm started
>
>But once I enter anything like sqlplus or svrmgrl or svrmgrlO nothing will
>come-up except prompt.
>
>Will anyone from the group please help me out.
>
>In past, the group solved my problems whenever I am in trouble.
>
>Thanks
>
>--
>-----------------------------------------------------
>Click here for Free Video!!
>http://www.gohip.com/free_video/
>
>
>

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net