Got a problem while configuring Oralce 9iAS portal, help me.. I would have given more than 500 points, but it wont allow to give more than 300 points...
Operating system - Windows 2000
I have installed 9i database successfully
I have installed 9iAS 1.0.2.2.1 successfully
While configuring Oracle 9iAS Portal , it prompts to enter password for SYS user and connection.
I have given entered password as change_on_install ( I have not changed the default password).
And I have entered connection as <hostname>:1521:SID as required, for ex: raj:1521:orcl
Note: As from oracle 9i onwards, connecting to SYS user is only allowed as SYSDBA only allowed, when it prompts to enter password and connection, I don't know how to do same.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi Sudip,
I have done the things specified in your comment.
now i ma facing another problem, after reaching 47 % of portal configuration, it stops. I have looked at install.log, in this after STEP 14, it is giving the message unable to allocate 40762 bytes of memory(large pool)..
i tried no of times.. it is stopping at the same place..
shared pool is 200MB, large pool 32MB and java pool is 32 MB.
What am i doing wrong or what am i missing out.
Thanks,
Since you are having so many problems with the Oracle Portal Configuration Assistant wizard, I am outlining the procedure to install the Portal Repository from the command prompt.
First ensure that your database server is running and that you have a working TNS Alias in your 9iAS HOME that points to your database. You can test your connection with SQL*Plus.
With a text editor, open catload.sql which is located in the following directory:
<ORACLE_HOME>\portal30\adm
Comment out the following line:
REM spool ..\..\portal30\admin\plsql
Then add a new line to indicate the correct location of catldscr.sql for your manual installation:
spool catldscr.sql
Save and close the file.
With a text editor, open owacomm.sql which is located in the following directory:
<ORACLE_HOME>\portal30\adm
Comment out the following line:
REM spool ..\..\portal30\admin\plsql
Then add a new line to indicate the correct location of owaldscr.sql for a your manual installation:
spool owaldscr.sql
Save and close the file.
From the <ORACLE_HOME>\portal30\adm
set ORACLE_HOME=E:\Oracle\iSui
cd %ORACLE_HOME%\portal30\adm
onetime.cmd -p <SYS_Password> -l onetime.log -c <connect_string>
Then, run the Oracle9iAS Portal installation script, <ORACLE_HOME>\portal30\adm
winstall.cmd -s portal30 -p <SYS_Password> -u users -t temp -d users -l users -o portal30_sso -i portal30_sso_ps -r 12345 -c <connect_string> > winstall.log
The syntax for the winstall command is:
winstall.cmd <-s portal_schema> <-p sys_password> <-u default_tablespace> <-t temporary_tablespace> <-d document_tablespace> <-l logging_tablespace> <-o sso_schema> <-i pstore_password> <-r random_seed> <-c connect_string>
In case of any errors in the execution of "winstall.cmd", before you re-run the winstall script, you will need to drop all Oracle9iAS Portal schemas that were created by winstall. For example, enter:
SQLPLUS > drop user <schema> cascade;
Next, run the <ORACLE_HOME>\portal30\adm
ssodatan.cmd -w http://portal-svr/pls/port
The syntax of the ssodatan.cmd script is:
ssodatan <-w portal_url> <-l login_server_url> <-s portal_schema> <-p portal_password> <-o sso_schema> <-d sso_password> <-e pstore_schema> <-c portal_connect_string>
portal_url
==========
URL that points to the Oracle9iAS Portal node DAD. Include the full domain name with the host, http://prefix in your URL, and end the URL with a forward slash (/).
Note: If you are not using the default port number (for example, 80), specify it in the Oracle9iAS Portal URL.
login_server_url
================
URL that points to the Login Server host and DAD. Include the full domain name with the host, http:// prefix in your URL, and end the URL with a forward slash (/).
Note: If you are not using the default port number (for example, 443), specify it in the Login Server URL.
Stop and restart the Oracle HTTP Server powered by Apache:
net stop OracleiSuitesHTTPServer
net start OracleiSuitesHTTPServer
The Oracle9iAS Portal Online Help Content Area contains conceptual, getting started, procedural, and troubleshooting Help topics.
Complete these steps to set up the Oracle Portal Online Help Content Area to display within Oracle9iAS Portal:
To install the Oracle9iAS Portal Online Help, from the <ORACLE_HOME>\portal30\adm
run the contimp.cmd script:
cd wwu
contimp.cmd -s portal309 -p portal30 -o portal_help -m reuse -u database_user -d ..\..\..\doc\site\hlp30ca.
Again, stop and restart the Oracle HTTP Server powered by Apache:
net stop OracleiSuitesHTTPServer
net start OracleiSuitesHTTPServer
Point your browser to your Oracle9iAS Portal installation at:
http://<hostname>:<port_nu
Click the ?Login? link at the top-right of the page. By default, the login credentials are:
Username: portal30
Password: portal30
All the best!
The Oracle9iAS Portal login mentioned in my earlier post should read:
http://<machine-name>:<por
The login credentials are:
Username = portal30
Password = portal30
Ciao!
Sudip.
Hi Sudip,
I have ran the scripts manually..
onetime.cmd - ran successfully
winstall.cmd - When i see the log file, it has plenty of ORA-01422 errors.
Then I have dropped the users and repeated the process once again, onetime.cmd and winstall.cmd, It is the same case lot of ORA-01422 errors.
Am i missing anything more. Or shall i try reinstalling Oracle9iAS software?
Regards,
Dear Renuraj,
I am not aware of your email id so I am including mine. Could you send me the logs of your Portal Configuration Assistant's repository building process. My e-mail id is
sudip_dg@yahoo.com
I would also like to see your Oracle init.ora file. From what you have listed of your initialization parameters, there is no problem in the sizes of the SHARED_POOL_SIZE or the JAVA_POOL_SIZE. I have created my Oracle9iAS Portal repository on a database server with a smaller configuration. However, my 9i database server is running in the dedicated server mode and has a LARGE_POOL_SIZE=0 and db_cache_size=33554432.
I shall be able to give you some more definite information then.
Regards,
Sudip Dasgupta.
Dear Renuraj,
I found an alternative for using the Portal Configuration wizard.
Problem Description
-------------------
It is recommended to install the Portal 3.0.9 release into an Oracle8i (8.1.7) Database. This note will help to identify the known issues with installing into an Oracle9i Database.
A server parameter file (SPFILE) is a new feature introduced in Oracle9i. When a 9.0.1 database owns a server parameter file (SPFILE), the init.ora file for the instance is not read during database startup.
At instance startup, the rule of precedence is the following:
1. spfile<SID>.ora
2. spfile.ora if the spfile<SID>.ora does not exist
3. init<SID>.ora if the spfile.ora does not exist
Please keep this fact in mind when implementing the solution listed here.
Solution Description
--------------------
Step 1. Install the Oracle9i Database version 9.0.1
Step 2. Modify the init.ora settings for the database per the Portal Configuration Guide. Increase the large_pool_size parameter in the init.ora file to around 83886080 (80 Mb). This is a new requirement for Portal installation for 9i database. Reference Bug:2055243
Step 3. Add the O7_DICTIONARY_ACCESSIBILIT
O7_DICTIONARY_ACCESSIBILIT
Please note, that this is the letter "O" not the number zero.
To test this step, you should attempt to connect to the database by connecting as sys from SQL*Plus. For example:
sqlplus sys/change_on_install
After the portal installation is complete you can once again remove this parameter. It is only required for the installation.
Step 4. Comment out the MTS Dispatchers init.ora setting
##################
# MTS
##################
#dispatchers="..."
This step works around a problem with the large pool. In many installations, if the Multithreaded Server settings are used during the installation it will complain that it cannot allocate bytes from the large pool, even if it is set very large.
Step 5. Install the Oracle9i Application Server (9iAS) version 1.0.2.2, but cancel the Portal Configuration Assistant.
Step 6. Apply the JDBC Driver Patch Required to use Oracle9i Database.
This patch must be applied to the 9iAS home, not the database home. The patch allows the 9iAS home to make a JDBC connection to the 9i database.
To apply this patch for Unix please use these instructions:
A. Login to Oracle Metalink (http://metalink.oracle.co
B. Select the Patches link
C. Enter 1725012 for the patch number, and your platform
D. Download the patch and follow the Readme instructions to install to the 9iAS Home
To apply this patch for win32 platforms (WinNT/2000), please use these instructions:
A. Login to Oracle Metalink (http://metalink.oracle.co
B. Select the Patches link
C. Enter 1711240 for the patch number and the platform as WinNT/2000. (This is patch 8.1.7.1.1, please download)
D. Use the Universal Installer to apply 8.1.7.1.1 to the 9iAS Home
E. Repeat steps A & B
F. Enter 1887405 for the patch number and the platform as WinNT/2000. (This is patch 8.1.7.1.5, please download)
G. Follow the client side instructions for 8.1.7.1.5 to install to the 9iAS Home
If this patch is not applied, ora-600 errors will be raised in the install.log. In addition, the portal configuration assistant will complain that the shared pool is too small even though it meets requirements. This is caused since the tool cannot login to the database to check the settings.
Step 7. Start the Portal Configuration Assistant, and install portal
References
-------------
Oracle9iAS Portal Configuration Guide Release 3.0.9
Oracle9i Application Server Documentation, Release 1(v1.0.2.2)
Oracle9i Application Server Release Notes, Release 1.0.2.2
Oracle9i Database Documentation
Regards,
Sudip.
Hi renuraj,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept sudipdg's comment(s) as an answer.
renuraj, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will followup.
EXPERTS: Your input for closing recommendations are REQUESTED.
==========
DanRollins -- EE database cleanup volunteer
Business Accounts
Answer for Membership
by: sudipdgPosted on 2001-11-21 at 22:15:11ID: 6649361
I faced exactly the same problem, and was finally able to get around it after a long time.
What you first need to do is change the Oracle9i database initialization parameters to include the following line:
o7_dictionary_accessibilit
Then shutdown and restart the database. After that Oracle9i will allow you to connect as SYS (not necessarily as SYSDBA).
I believe you will come across another problem soon after. There Portal Configuration Assistant may produce a recurring error message stating that the SHARED POOL SIZE is less than 30MB even though when you query the Data Dictionary with:
select value from v$parameter where name like 'shared_pool_size' ;
you get a value that is larger than the minimum value (30MB). The reason for this error is actually the Oracle JDBC driver that is shipped along with the Oracle9i database (release 9.0.1). Visit the Oracle Technology Network and search for Oracle9i JDBC drivers. Download the "classes12.zip" file listed for the Solaris platform (there were no Oracle9i JDBC drivers listed for Windows NT/2000 when I checked last.) Rename the "classes12.zip" file you have downloaded to say, "classes12_9i.zip" and move it to your ORACLE_HOME\jdbc\lib directory. (My ORACLE_HOME for example is E:\Oracle\iSuites).
Next, edit the Portal Configuration Assistant batch file (E:\Oracle\iSuites\assista
Finally, save the "launch.bat" script and run it. Now enter the SYS password when prompted for it and proceed through with the creation of the Portal Repository.
Best of Luck!
Sudip.