oracle service restart
happytoday
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
nelson....@gmail.com
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 :)
happytoday
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
#
hume.sp...@bofh.ca
> # /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/
nelson....@gmail.com
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.
happytoday
Yes . that worked fine but I got that message when I login as scott :
Error
ERROR - ORA-12541: TNS:no listener
hume.sp...@bofh.ca
> 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.
Stefaan A Eeckels
happytoday <ehabaz...@gmail.com> wrote:
> On May 22, 1:10 am, nelson.bens...@gmail.com wrote:
> > 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):
>
> 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 listener
// 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-2009 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 = (ADDRESS = (PROTOCOL = TCP)(HOST = uxora-pre)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = 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.
-- Winston Churchill
happytoday
> On Fri, 22 May 2009 04:17:42 -0700 (PDT)
>
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
#
happytoday
>
# ./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=(CONNECT_DATA=
(SERVICE_NAME=test.linkdsl.net))(ADDRESS=(PROTOCOL=TCP)
(HOST=69.64.155.121)(PORT=1521)))
TNS-12541: TNS:no listener
#
Stefaan A Eeckels
happytoday <ehabaz...@gmail.com> wrote:
> On May 22, 4:19 pm, 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
> >
>
> # ./lsnrctl start
Have you checked the configuration file?
>
> 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
> #
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 operation.
// *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.
--
Stefaan A Eeckels
--
"Shun those who say we have eyes in order to see, and instead say we
see because we happen to have eyes."