I installed Oracle enterprise edition but when I tried : http://inhome:5560/isqlplus
for first time I got the database login.
But when for second time when I tried : http://inhome:5560/isqlplus I
did not get the database login.
In windows I restart the oracle service but what I should do about
oracle under Solaris.
Thanks

depends on the version doesn't it?  from memory since it's been more
than a little while, 9i uses apache for this but 10g+ uses oc4j.

i'd personally think this is more a question for an oracle user group
but maybe (depending on versions) something like 'isqlplusctl start'
would work or "$ORACLE_HOME/Apache/Apache/bin/apachectl start"

out of interest did you try a web search for isql start?  my daughter
would ask me if i'd googled it :)

On May 21, 1:12=A0pm, nelson.bens...@gmail.com wrote:
> depends on the version doesn't it? =A0from memory since it's been more
> than a little while, 9i uses apache for this but 10g+ uses oc4j.
>
> i'd personally think this is more a question for an oracle user group
> but maybe (depending on versions) something like 'isqlplusctl start'
> would work or "$ORACLE_HOME/Apache/Apache/bin/apachectl start"
>
> out of interest did you try a web search for isql start? =A0my daughter
> would ask me if i'd googled it :)

I installed Oracle 10G enterprise edition :

I tried :

# /usr/apache/bin/apachectl start
fopen: No such file or directory
httpd: could not open document config file /etc/apache/httpd.conf
/usr/apache/bin/apachectl start: httpd could not be started
#

In comp.unix.solaris happytoday <ehabaziz2001@gmail.com> wrote:
> # /usr/apache/bin/apachectl start
> fopen: No such file or directory
> httpd: could not open document config file /etc/apache/httpd.conf
> /usr/apache/bin/apachectl start: httpd could not be started

This error is incredibly obvious in what it means.

I've never installed Oracle 10... last time I did an Oracle install was
back in the Oracle 7 days.  However... why would you be trying to start
the system Apache, when it's obvious you haven't even attempted to
configure it?  Does Oracle 10 come with its own Apache?  Should you be
trying to start that one?

-- 
Brandon Hume    - hume -> BOFH.Ca, http://WWW.BOFH.Ca/

as Brandon quite rightly pointed out that's solaris's apache.  not
oracle's.  since you've said it's 10g perhaps you should try the
'isqlplusctl' command since (this is from a 10.2.0.3 ee install):

$ head ${ORACLE_HOME}/bin/isqlplusctl
#!/bin/sh -f
#++
# Copyright (c) 2003, 2005, Oracle. All rights reserved.
#
#   NAME
#     isqlplusctl - Start and Stop iSQL*Plus.
#
#   DESCRIPTION
#
#     This is the script to start and stop iSQL*Plus.

On May 22, 1:10=A0am, nelson.bens...@gmail.com wrote:
> as Brandon quite rightly pointed out that's solaris's apache. =A0not
> oracle's. =A0since you've said it's 10g perhaps you should try the
> 'isqlplusctl' command since (this is from a 10.2.0.3 ee install):
>
> $ head ${ORACLE_HOME}/bin/isqlplusctl
> #!/bin/sh -f
> #++
> # Copyright (c) 2003, 2005, Oracle. All rights reserved.
> #
> # =A0 NAME
> # =A0 =A0 isqlplusctl - Start and Stop iSQL*Plus.
> #
> # =A0 DESCRIPTION
> #
> # =A0 =A0 This is the script to start and stop iSQL*Plus.

Yes . that worked fine but I got that message when I login as scott :


Error
ERROR - ORA-12541: TNS:no listener

In comp.unix.solaris happytoday <ehabaziz2001@gmail.com> wrote:
> Error
> ERROR - ORA-12541: TNS:no listener

tnslsnr is probably not running.  I can't say for sure, because I'm a 
Solaris person, not an Oracle person.

I'm told Oracle people know Oracle things.  Have you tried asking Oracle 
people Oracle questions?  I'm told Oracle people hang out on Oracle groups,
where they discuss Oracle things.

-- 
Brandon Hume    - hume -> BOFH.Ca, http://WWW.BOFH.Ca/

On Fri, 22 May 2009 04:17:42 -0700 (PDT)
happytoday <ehabaziz2001@gmail.com> wrote:

> On May 22, 1:10=A0am, nelson.bens...@gmail.com wrote:
> > as Brandon quite rightly pointed out that's solaris's apache. =A0not
> > oracle's. =A0since you've said it's 10g perhaps you should try the
> > 'isqlplusctl' command since (this is from a 10.2.0.3 ee install):
>=20
> Yes . that worked fine but I got that message when I login as scott :
>=20
>=20
> Error
> ERROR - ORA-12541: TNS:no listener

As Brandon says, you need to configure and start the listener. Try

$ lsnrctl start

after checking (and completing) its configuration file:

$ vi $ORACLE_HOME/network/admin/listener.ora

(if ORACLE_HOME isn't set you've got more fundamental issues than
starting the listener).

There is a handy utility called oerr that gives details on the errors
generated by Oracle:

$ oerr ora 12541
12541, 00000, "TNS:no listener"
// *Cause: The connection request could not be completed because the listen=
er
// is not running.
// *Action: Ensure that the supplied destination address matches one of
// the addresses used by the listener - compare the TNSNAMES.ORA entry with
// the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
// go by way of an Interchange). Start the listener on the remote machine.

If things are set up correctly, you should be able to do a tnsping and
see your database:

$ tnsping test

TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 22-MAY-200=
9 15:15:28

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
/home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION =3D (ADDRESS =3D (PROTOCOL =3D TCP)(HOST=
 =3D uxora-pre)(PORT =3D 1521)) (CONNECT_DATA =3D (SERVER =3D DEDICATED) (S=
ERVICE_NAME =3D test.preprod.lan)))
OK (0 msec)

I suggest you spend some time with the Oracle manuals. They are
actually quite good (if not always easy to read).

Take care,

--=20
Stefaan A Eeckels
--=20
The only statistics you can trust are those you falsified yourself.
                                               -- Winston Churchill

On May 22, 4:19=A0pm, Stefaan A Eeckels <hoend...@ecc.lu> wrote:
> On Fri, 22 May 2009 04:17:42 -0700 (PDT)
>
> happytoday <ehabaziz2...@gmail.com> wrote:
> > On May 22, 1:10=A0am, nelson.bens...@gmail.com wrote:
> > > as Brandon quite rightly pointed out that's solaris's apache. =A0not
> > > oracle's. =A0since you've said it's 10g perhaps you should try the
> > > 'isqlplusctl' command since (this is from a 10.2.0.3 ee install):
>
> > Yes . that worked fine but I got that message when I login as scott :
>
> > Error
> > ERROR - ORA-12541: TNS:no listener
>
> As Brandon says, you need to configure and start the listener. Try
>
> $ lsnrctl start
>
> after checking (and completing) its configuration file:
>
> $ vi $ORACLE_HOME/network/admin/listener.ora
>
> (if ORACLE_HOME isn't set you've got more fundamental issues than
> starting the listener).
>
> There is a handy utility called oerr that gives details on the errors
> generated by Oracle:
>
> $ oerr ora 12541
> 12541, 00000, "TNS:no listener"
> // *Cause: The connection request could not be completed because the list=
ener
> // is not running.
> // *Action: Ensure that the supplied destination address matches one of
> // the addresses used by the listener - compare the TNSNAMES.ORA entry wi=
th
> // the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is =
to
> // go by way of an Interchange). Start the listener on the remote machine=
..
>
> If things are set up correctly, you should be able to do a tnsping and
> see your database:
>
> $ tnsping test
>
> TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 22-MAY-2=
009 15:15:28
>
> Copyright (c) 1997, 2005, Oracle. =A0All rights reserved.
>
> Used parameter files:
> /home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION =3D (ADDRESS =3D (PROTOCOL =3D TCP)(HO=
ST =3D uxora-pre)(PORT =3D 1521)) (CONNECT_DATA =3D (SERVER =3D DEDICATED) =
(SERVICE_NAME =3D test.preprod.lan)))
> OK (0 msec)
>
> I suggest you spend some time with the Oracle manuals. They are
> actually quite good (if not always easy to read).
>
> Take care,
>
> --
> Stefaan A Eeckels
> --
> The only statistics you can trust are those you falsified yourself.
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0-- Winston Churchill

I did not login screen after I tried : ./isqlplusctl , ./lsnrctl :

# ./isqlplusctl start
iSQL*Plus 10.2.0.2.0
Copyright (c) 2003, 2005, Oracle.  All Rights Reserved.
Starting iSQL*Plus ...
iSQL*Plus started.


# ./lsnrctl start

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 26-MAY-2009
17:03:09

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /oracle/product/102/bin/tnslsnr: please wait...

TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Solaris Error: 13: Permission denied
#

On May 22, 4:19=A0pm, Stefaan A Eeckels <hoend...@ecc.lu> wrote:
> On Fri, 22 May 2009 04:17:42 -0700 (PDT)
>
> happytoday <ehabaziz2...@gmail.com> wrote:
> > On May 22, 1:10=A0am, nelson.bens...@gmail.com wrote:
> > > as Brandon quite rightly pointed out that's solaris's apache. =A0not
> > > oracle's. =A0since you've said it's 10g perhaps you should try the
> > > 'isqlplusctl' command since (this is from a 10.2.0.3 ee install):
>
> > Yes . that worked fine but I got that message when I login as scott :
>
> > Error
> > ERROR - ORA-12541: TNS:no listener
>
> As Brandon says, you need to configure and start the listener. Try
>
> $ lsnrctl start
>
> after checking (and completing) its configuration file:
>
> $ vi $ORACLE_HOME/network/admin/listener.ora
>
> (if ORACLE_HOME isn't set you've got more fundamental issues than
> starting the listener).
>
> There is a handy utility called oerr that gives details on the errors
> generated by Oracle:
>
> $ oerr ora 12541
> 12541, 00000, "TNS:no listener"
> // *Cause: The connection request could not be completed because the list=
ener
> // is not running.
> // *Action: Ensure that the supplied destination address matches one of
> // the addresses used by the listener - compare the TNSNAMES.ORA entry wi=
th
> // the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is =
to
> // go by way of an Interchange). Start the listener on the remote machine=
..
>
> If things are set up correctly, you should be able to do a tnsping and
> see your database:
>
> $ tnsping test
>
> TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 22-MAY-2=
009 15:15:28
>
> Copyright (c) 1997, 2005, Oracle. =A0All rights reserved.
>
> Used parameter files:
> /home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION =3D (ADDRESS =3D (PROTOCOL =3D TCP)(HO=
ST =3D uxora-pre)(PORT =3D 1521)) (CONNECT_DATA =3D (SERVER =3D DEDICATED) =
(SERVICE_NAME =3D test.preprod.lan)))
> OK (0 msec)
>
> I suggest you spend some time with the Oracle manuals. They are
> actually quite good (if not always easy to read).
>
> Take care,
>
> --
> Stefaan A Eeckels
> --
> The only statistics you can trust are those you falsified yourself.
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0-- Winston Churchill

# ./tnsping test

TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 26-
MAY-2009 17:30:02

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
/oracle/product/102/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=3D(CONNECT_DATA=3D
(SERVICE_NAME=3Dtest.linkdsl.net))(ADDRESS=3D(PROTOCOL=3DTCP)
(HOST=3D69.64.155.121)(PORT=3D1521)))
TNS-12541: TNS:no listener
#

On Tue, 26 May 2009 07:04:47 -0700 (PDT)
happytoday <ehabaziz2001@gmail.com> wrote:

> On May 22, 4:19=A0pm, Stefaan A Eeckels <hoend...@ecc.lu> wrote:
> > On Fri, 22 May 2009 04:17:42 -0700 (PDT)
> >
> >
> > As Brandon says, you need to configure and start the listener. Try
> >
> > $ lsnrctl start
> >
> > after checking (and completing) its configuration file:
> >
> > $ vi $ORACLE_HOME/network/admin/listener.ora
> >
>=20
> # ./lsnrctl start

Have you checked the configuration file?=20

>=20
> LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 26-MAY-2009
> 17:03:09
>=20
> Copyright (c) 1991, 2005, Oracle.  All rights reserved.
>=20
> Starting /oracle/product/102/bin/tnslsnr: please wait...
>=20
> TNS-12546: TNS:permission denied
>  TNS-12560: TNS:protocol adapter error
>   TNS-00516: Permission denied
>    Solaris Error: 13: Permission denied
> #

You seem to be using root to start the listener. Using root to manage
Oracle is a very bad idea (read the Oracle documentation), and the
cause of your problems:

: [oracle@uxoradb01-p:ncaprod ~]; oerr TNS 12546
12546, 00000, "TNS:permission denied"
// *Cause: User has insufficient privileges to perform the requested operat=
ion.
// *Action: Acquire necessary privileges and try again.

You do not know the fundamentals of Unix and Oracle, and do not
seem to want to read the documentation. This is a recipe for
disaster. Please spend enough time with the documentation; there
are no shortcuts and you need to know and understand the basics.

--=20
Stefaan A Eeckels
--=20
"Shun those who say we have eyes in order to see, and instead say we
 see because we happen to have eyes."=20