Re: listener problem

From: <mjain_at_my-dejanews.com>
Date: Fri, 30 Oct 1998 02:46:59 GMT
Message-ID: <71b9b4$me$1@nnrp1.dejanews.com>

Your second question about the warning is answered here.

---

Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM

---

To correct above warning message I suggest the following:- 1. Find out the Oracle ready made script called PUPBLD.SQL

   in one of the directories below your ORACLE_HOME on your    database server machine. You can use NT Find utility. 2. Connect to the database as SYSTEM user using SQLPLUS ( You

   can use PLUS80W.exe, which you said is working in your case ). 3. Run the script file PUPBLD.SQL as follows:-

Prompt-SQL> @<directory-containing-pupbbld>\pupbld.sql

Specify proper directory where you found pupbld.sql using NT Find utility.

The above command will run the script for you,

4. Exit and reconnect to Oracle then you will see the warning is

   gone for future connections.

Hope this helps,

Manoj Jain
Oracle Certified Professional - OCP DBA Chauncey Certified Oracle7 DBA

In article <3638AEE7.8C66A46D_at_sybrandb.demon.nl>,
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
> The password that has been set in listener.ora. If you don't want it,
> just delete the line password_listener = <some string>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Fei Sha wrote:
>
> > Hi,
> >
> > I'm trying oracle 8 enterprise 8.0.3.0.2 on NT 4.0 SP3.
> >
> > I can connect to the database from Oracle Navigater and
> > Oracle JDBC. When I connect with PLUS80W.exe, it works but with
> > a warning msg :
> >
> > Error accessing PRODUCT_USER_PROFILE
> > Warning: Product user profile information not loaded!
> > You may need to run PUPBLD.SQL as SYSTEM
> >
> > I don't really understand this but np.
> >
> > When I use PLUS80.exe to connect then:
> >
> > ERROR:
> > ORA-12203: TNS:unable to connect to destination
> >
> > LSNRCTL -status
> >
> > LSNRCTL> status
> > Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world))
> > STATUS of the LISTENER
> > ------------------------
> > Alias LISTENER
> > Version TNSLSNR80 for 32-bit Windows: Version
> > 8.0.3.0.0 - Prod
> > uction
> > Start Date 28-OCT-98 23:27:14
> > Uptime 0 days 12 hr. 14 min. 8 sec
> > Trace Level off
> > Security ON
> > SNMP OFF
> > Listener Parameter File C:\O8SERVER\NET80\admin\listener.ora
> > Listener Log File C:\O8SERVER\NET80\log\listener.log
> > Services Summary...
> > OEM has 1 service handler(s)
> > extproc has 1 service handler(s)
> > The command completed successfully
> >
> > LSNRCTL> start
> > Starting tnslsnr80: please wait...
> >
> > TNS-01106: Listener using listener name LISTENER has already been
> > started
> >
> > LSNRCTL> stop
> > Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world))
> > TNS-01169: The listener has not recognized the password
> > Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=OEM))
> > TNS-01169: The listener has not recognized the password
> > Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=nora)(Port=1521))
> > TNS-01169: The listener has not recognized the password
> > Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=nora)(Port=1526))
> > TNS-01169: The listener has not recognized the password
> > Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))
> > TNS-01169: The listener has not recognized the password
> >
> > What password it talks about?
> >
> > Thanks!
> >
> > Fei
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 29 1998 - 20:46:59 CST