iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

IMPORTANT-READ CAREFULLY  

Why I get this error message " FRM-10142 the HTTP Listener is not running on xxxx at port 8888. Please start the listener or check your runtime preferences,” when I try to run my FORMS.

 

You only get this error message if you either install Oracle 9iAS Release 2 or Oracle 9iDS on your windows machine.

 

Unlike Forms 6i, Forms 9i does not support client-server. A "FMB" run from the Forms Builder is a 'web deployed form.' To do this Forms 9i Builder needs to integrate with some form of HTTP Listener. This is provided by another component of the Oracle 9iDS Release 2 install - the OC4J (Oracle Container For J2EE).

 

If there is no HTTP Listener started FRM- 10142 occurs Once an OC4J instance has been started it acts as lightweight HTTP Listener enabling the developer to test the forms / reports application modules in a true web (even if only intranet) architecture.

 

If you install Oracle9iAS Release 2, then you are using the HTTP listener. Make sure that the HTTP server is on and test the listener. To test the HTTP listener, open your browser and type: http://machine_name.your_domain:port where the port number is either 8888 or one of the 777n ports.

 

If you install Oracle9iDS, then you are not using the HTTP server. You will be using an OC4J instance which will act as a listener. In order to start the OC4J instance (listener) do the following:

 

Click on Start > Program > Oracle9i Developer Suite > FORMS Developer > Start OC4J Instance or you can find and run the "startinst.bat" file in the Developer 9i home.

 

Good Luck!

 

Oracle Installation Issues on Windows:

 

Oracle9i is not supported on Windows 95. Ignore occurrences of support for Windows 95 in the Oracle9i documentation library.

 

ME installation problem:

Notice that although our products work under ME, you should know that if you buy Oracle8i or Oracle9i from Oracle Corp. to install on ME, these Oracle products are not certified on ME and you may not be able to install them on your machine successfully in order to follow the Hands-On exercises.

What is the difference between the Oracle Developer 9i and 6i version?

It is very confusing. The Oracle9iDS (Internet Developer Suite) includes both Reports and Forms for the Client and Server. The Forms and Reports Clients are the same as the Oracle Developer 6i version. Those that want to learn how to develop an application using the Oracle Forms and Reports; need to install only the Client part. Don’t install the Oracle Server component into your machine. Also, Oracle has another product called the Oracle9iAS (Internet Application Server). Don’t use that because it contains only the Reports and Forms Server part.

Installation Issues

·        If you have any Oracle-related jar files in your CLASSPATH system variable, remove them prior to an Oracle9i installation and restore them afterwards. Oracle Universal Installer hangs at the Configuration Types window if you do not remove them.

 

·        Installation of Oracle9i may fail on Windows computers that have Novell NetWare client installed. The workaround is to temporarily de-install the Novell NetWare client.

 

·        When installing Oracle9i on dual boot systems, the software uses the same physical space on both operating systems. Therefore, any tasks done on one operating system are also done on the other operating system, including de-installation.

 

This situation can be avoided by performing the following steps:

Install Oracle9i into the first environment.

Before installing in the second environment, provide a different location than the default when Oracle Universal Installer prompts you on where to create the Oracle Universal Installer inventory. The second environment inventory is independent of the first, and products can be installed or de-installed separately on both systems.

 

·        For installations with a response file, the path to the response file must be the full path on the computer. Oracle Universal Installer does not properly handle relative paths.

 

·        Due to a JRE bug an MS-DOS command prompt window appears whenever a configuration tool is launched. Leave this window open until the configuration tool finishes. Closing the window kills the process and causes the configuration tool to fail.

 

Restriction Migrating a Release 7.3.4 Database

Direct migration from Release 7.3.4 or prior releases of Personal Edition on Windows 98 to this release is not supported, since operating system authentication is not available on Windows 98. If you want to migrate from the 7.3.4 release to this release, please migrate first to 8.1.7 release and then migrate to this release.

 

Oracle Data Migration Assistant

When migrating an Oracle database to Oracle9i, the Database Password and INIT.ORA File window of Oracle Data Migration Assistant prompts you for the SYS password. You must enter a password that is valid for the following connection:

SYS/password AS SYSDBA

where password is your pre-Oracle9i INTERNAL user account password (oracle by default, unless you changed it). 

 

Before you migrate an Oracle database with Oracle Data Migration Assistant, ensure the init.ora file does not contain any initialization parameter with a value defined using environment variables. For example:

background_dump_dest=%ORACLE_HOME%\trace

Substitute the environment variable value before starting the migration process. For example:

background_dump_dest=c:\oracle\orahome8\rdbms\trace

 

Ignore Error ORA-00604: During Upgrade

Ignore the following error when upgrading from Release 8.0.x to 9.0.1. Despite the error message, the upgrade has completed successfully. Note that the error does not occur during upgrade from 8.1.x to 9.0.1.

ORA-00604: error occurred at recursive SQL level 1

 

Oracle9i Network Issues

Listener does not support the IPC Protocol in this release. In order for the listener to work correctly, the IPC protocol information must be removed manually from the listener.ora file in ORACLE_HOME/network/admin folder. Please remove the IPC related lines or comment them out as shown below:

## Sample Listener.ora showing the IPC connect string commented out (in BOLD letters)

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

#      (ADDRESS_LIST =

#        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

#      )

      (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = your_computer_name)(PORT = 1521)

      )

    )

  )

 

If you have migrated listener.ora from a prior release as part of doing a database migration, please remember to modify the migrated listener.ora as specified above.

Please note that the listener may fail to start up properly if the IPC related lines are present in listener.ora.

 

SQL*Plus

SQL*Plus does not run and you cannot install the database successfully without the DLLs wininet.dll and shlwapi.dll

If these DLLs are not present on the computer, you can get them from another computer, the MSDN Web site, or the Windows NT 4.0 installation CD-ROM. Copy the DLLs to C:\WINNT\system32\ before installing Oracle9i.

 

Developer & Oracle Personal Edition on Windows (standalone)

The following will need to be done to establish a connection from Developer to Oracle Personal Edition.

  • 1. Install Oracle. Default Oracle_Home is as follows: (oracle/oraxx - xx is version number for example Oracle 8i xx=81 or 82 and for Oracle 9i xx=90, 91 or 92) If you do not have a Domain name or are unsure of - use default selections (REMEMBER: your SID for step 3) 

  • 2.Install Developer into a seperate Oracle_Home from the Oracle database. Default Oracle_Home: ORAWIN95.  Change the Developer Home name to: (oradevxx - xx is version number) and the Developer Home location to: (oracle/devxx - xx is version number)  

  • 3.Create a Net8 service name using the Net8 Easy config utility (start -> programs -> Oracle ->network administration -> net8 easy config)  

  •     Enter the following information:

  • Select "create"

  • Name the service name - any name can be used. (this name must be the same as SID name on the step 1.

  • Select TCP/IP as the protocol adapter

  • Enter your PC name as your host (as found in your TCP/IP

  • properties of the control panel or 127.0.0.1)

  • Select the second radio button to change your database instance to equal the SID created during your installation or leave the default as ORCL.

  • Bypass the test and remaining screens by clicking next.

  • 4.Go to the following location (using Windows Explorer): (oracle/oraxx/network/admin/)  (where Oracle/Oraxx is the location of your Oracle_Home) then copy the tnsnames.ora file to the following location:  (oracle/oradevxx/net80/admin) (where oracle/oradevxx is the location of your Developer Oracle_Home)

  • 5.Rename the sqlnet.ora file to sqlnet.old.  These files can be found in the following locations:  

     a.oracle/oraxx/network/admin/

     b.oracle/oradevxx/net80/admin

Some installations will not create the above files in both locations, rename only the files that are found. Now reboot.

  • 6.Start your listener:

At the DOS prompt type: LSNRCTL START

NOTE: if you have an internet connection that uses TCP/IP as a protocol you may recieve a dial-up connection box when starting the listener.  Press cancel to bypass this connection.

  • 7.Start your database:  (Start -> Oracle - OraHomexx -> Database Administration -> Start

     Login to any developer’s tools and make a connection using:

     username: scott

     password: tiger

     database: <enter the service name created in step #3>

 What is the Username/Password Needed for Login

The Oracle8i starter database comes with some default user names and user passwords, which are shown in the following table.  Use these default values until you establish your own user name and user password. 

         User Name/Password

Scott/tiger

System/manager

Sys/change_on_install

Internal/oracle

Demo/demo

To connect to your local database from SQL*Plus, you may be asked for the host string, database, connect descriptor, or some similar label, depending on the application. You can leave this field blank.  If you are trying to connect from an Oracle tool (Developer, Discoverer, Designer, etc) then you will need to create a connect descriptor using the Net8 configuration tool.

 

Google
 
Web web site