I've just migrated from 8i to 9i and I wonder, how I
prevent the tnslistener from providing me a webserver
on port 8080.
I can't find a config-file or else, where I can tell the
listener which port he has to listen.
Usually in version 8i the listener only used port 1521.
Now, it uses 1081, 1521, 2100 and 8080...
But I need 8080 for other purposes!
I would be very glad, if someone tells me how to stop
this beast... ; )
Thanx
hth
santosh sharma
"Ralf Allar" <Ralf....@netcologne.de> wrote in message
news:3d3301a0$1...@news.piro.net...
Hi Santosh,
following problem occurs:
Benutzernamen eingeben: sys
Kennwort eingeben:
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
But I can't find those accounts in the docs nor one password.
It's driving me nuts...
Those aren't accounts, they are privileges.
Connect sys/something AS SYSDBA
It means... connect me as SYS with the SYSDBA privilege (ie, the ability to
startup, shutdown, backup, recover or create a database).
In 9i it becomes (by default) impossible to connect as SYS *without* that
privilege. You *MUST* have "AS SYSDBA" somewhere in the connect string.
If you are going to start messing around with the ports that the listener
uses, it is to be hoped that you know the basics about how to connect to the
database and the privileges that are available for a connection.
Regards
HJR
try this ;
sqlplus sys/password as sysdba
Alternatively, if your Unix command line rejects the command, try double
quotes, if that doesn't work, try
sqlplus sys/password
SQL> connect sys/password as sysdba
and that should get you into sys as sysdba.
Cheers,
Norman.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
OK, that worked... (in quotes)...
The next problem is, that the method Santosh suggest me,
doesn't work. I receive an error ORA-06576 (no guilty function)
or ORA-00972 (name of object is too long), where I translated
the german errors in the brackets.
Error 1 occured, as I exactly copied Santosh line and error2
appeared after changing the quoates with double quotes.
Any hints? ; )
I'm afraid I have no idea - not being part of an installation that runs
the web stuff, however, maybe using 'execute' rather tahan 'call' will
work - unless it is some Java thing that you have to be running :o)
Cheers,
Norman.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Ralf Allar [mailto:Ralf....@netcologne.de]
Posted At: Tuesday, July 16, 2002 11:28 AM
Posted To: server
Conversation: tnslistener and port 8080
Subject: Re: tnslistener and port 8080
1. If you want to remove OSE completely from your database. Note this may
break other things in yoyr case if you are using any EJB/CORBA/servlets.
cd e:\oracle\ora90\jis\install
sess_sh -u "sys as sysdba" -p change_on_install -s
jdbc:oracle:thin:@hostname:1521:orcl
you will het $ prompt which is a shell with very limited commands available,
type help to see more on that.
isssue these command now:
rmendpoint admin main
rmendpoint admin ssl
rmendpoint admin mod8i
exit
2. If you just want ot change ports:
cd e:\oracle\ora90\jis\install
sess_sh -u "sys as sysdba" -p change_on_install -s
jdbc:oracle:thin:@hostname:1521:orcl
@e:\oracle\ora90\jis\install\serverendp.ssh admin 8089 9099 -register
exit
I tested both on my 9R1 database.
good luck
santosh sharma
"Norman Dunbar" <Norman...@lfs.co.uk> wrote in message
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...