Database configuration issues - PeopleSoft OVM Templates

Hi,
I created an virtual machine from the database server template (OVM_EL5U2_X86_64_HCM91_PVM) and encountered the following marginal problems :
1. On the first boot of the machine I configured the database to be started on boot (default choice - +Do you want Oracle Database to be started on boot (y/n) [y]:+ ), unfortunately it looks like the database and listener do not start automatically on the virtual machine start.
2. The /etc/oratab does not contain the database name I gave during the first VM setting.
3. The database password given on the first VM boot are not taken in account, e.g. SYSTEM's password is manager, not the one I gave during the initialization ( Specify a password to be used for database accounts. Note that the same password will be used for SYS, SYSTEM and ADMIN for APEX )...
Nicolas.
Edited by: N. Gasparotto on Nov 7, 2009 11:17 AM 

Hi Nicolas,
Does the same occour if you elect to manually start the DB, instead?
Otherwise, since this seems more related to Oracle VM and the database, could you post it on the Oracle VM forum and let us know what response you receive?
Oracle VM and Virtualization
Oracle VM Server for x86
thanks
Greg 

Greg,
Greg Kelly (556137) wrote:
Hi Nicolas,
Does the same occour if you elect to manually start the DB, instead?I didn't test the other way around. I'll post it on the Oracle VM forum, and report the answer.
Nicolas. 

N Gasparotto wrote:
...
1. On the first boot of the machine I configured the database to be started on boot (default choice - +Do you want Oracle Database to be started on boot (y/n) [y]:+ ), unfortunately it looks like the database and listener do not start automatically on the virtual machine start.I know, that's a very very very old thread, and generally, I'm reluctant to resurect such old thread, but this is for the better and for those who are interested, the database is now restarted automatically within the latest PSOVM, Human Capital Management 9.1 Feature Pack 2 Peopletools 8.52.06 from July 2012 (unfortunately is does not with the latest FSCM9.1FP2 PTools 8.52.03 - July'12).
2. The /etc/oratab does not contain the database name I gave during the first VM setting.Interestingly, it is now in /etc/oratab, but like this :
<mydbname>:/u01/app/oracle/product/11.2.0.x/db_1/WI'm wondering what's that W means. It should be Y to launch dbstart script on boot or N otherwise.
Moreover, and that's also for the better, the AppServer, Batch Server and PIA are starting automatically on server boot (for PSOVM HCM91FP2 PT8.52.06, not for FSCM91FP2 PT8.52.03) ! Thanks to the PSOVM's team.
So, partially solved - I'll marked it as solved though, but I hope the next wave of PSOVMs will have all the consistent and proper configuration between the all set of PSOVMs.
Nicolas. 

Hi Nicolas,
I'm not sure if its documented anywhere else, but if you look at the dbstart script in $ORACLE_HOME/bin, it appears that the "W" flag in oratab means "wait for ASM".
>
W_ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
# DB instances with 'W' (wait state) have a dependency on ASM instances via CRS.
# Wait here for 'all' ASM instances to become available.
>
Regards,
Bob 

Hello Bob,
Nice catch. Honnestly, I did not had a look into the script you mentioned. Better late than never, I did not know, but the third parameter "W" seems to be a 10.2.0.2 new feature.
And here it is documented :
http://docs.oracle.com/cd/E14072_01/server.112/e10839/strt_stp.htm#CFAHAHGA
+"You can set dbstart to autostart a single-instance database that uses an Automatic Storage Management installation that is auto-started by Oracle Clusterware. This is the default behavior for an Automatic Storage Management cluster. To do this, you must change the oratab entry of the database and the Automatic Storage Management installation to use a third field with the value W and N, respectively. These values specify that dbstart auto-starts the database only after the Automatic Storage Management instance is started."+
Thanks again,
Nicolas.

Related

11g web access

New to Oracle-----
Installed 11g and everything was fine got web access to DB and to EM. Everything worked fine. After a reboot I cannot access anything no web pages at all I can get the Apache default page to load but only if I turn on Redhats httpd. I know that Oracle uses its own but all the docs I can find talk 10g and 9i. Any suggestions?
Thanks
Oracle 11g running on Redhat 5 nothing else is on the machine. 
On Linux/Unix Oracle does not start automatically at reboot, unless you configure some autostart script. See autostart Oracle 11g 
I have created the /etc/init.d files and used chkconfig to link them to the rc#.d files to autostart at boot but I still cant get any web connectivity. i can start and stop the db and the console but still no web access. 
The problem is because it is not configured to autostart once a reboot comes. I suggest you to read this guide: Automating Shutdown and Startup included here:
Oracle® Database Administrator's Reference
11g Release 1 (11.1) for Linux and UNIX-Based Operating Systems
Part Number B32009-03
~ Madrid 
the system is set up to have the dbstart run as a service via, chkconfig --add db start this make the necessary symlinks and creates the S and the K files needed to run as a service.  This is a *unix command that takes care of doing all of the linking and creates the files.  It is the same as doing it by hand as in the link to the doc but, way easier.  Check out :  http://linux.die.net/man/8/chkconfig   Some of the issues that are not that covered in the doc that I encountered are if you run Oracle as root it takes ownership of a few log files and then wont all the listener to start because of permission, root.sh not making permanent changes to ORACLE_HOME.... Those all addressed the easiest thing was just to rebuild OS and Oracle, not reboot, pull the keyboard and mouse, set tight permissions and hope karma loves me and doesnt kill the power until we can figure this out on a VM.  So far my experience with Oracle has been a kin to smashing my fingers with a hammer.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       

dbca - error before instance is built

Hello
I am new to this (as you might have guesed) and tried to install RAC 10g (10.2.01) several times but always receive the same errors (in german):
PRKR-1008
Instances [testdb11,testdb12] on node [ill_srac1,ill_srac2] on cluster databse "testdb1", PRKR-1008: Instance testdb12 on node ill_srac2 could not be added to cluster database testdb1. could not be added
after pressing OK
PRKR-1001: Cluster database tetdb1 is not present
then I am back in the last window (16 of 16) of dbca
How did I do it:
Installing according to
http://www.dbasupport.com/oracle/ora10g/RACingAhead0301.shtml (thaks by the way)
trying it with two win2k3 nodes
on VMWare ESX.
What was different
I dont have access to the vmx files so the disk caching is not deactivated (does that matter?)
While installing clusterware there is an error to copy the following files to c:\windows\system32\drivers:
ocfs.sys
orafencedrv.sys
orafenceservice.sys
got around that error by copying it manually from node1 to node2 and pressing retry
it says there should be a log in cfgtoollogs\dbca\testdb1, but nothing there.
Any Ideas, other logs?
Thanks 
just a bit more to add.
found this in windows event viewer, applications
Audit trail: ACTION : 'CONNECT' DATABASE USER: '/' PRIVILEGE :
SYSDBA CLIENT USER: ILL_SRAC1\Administrator CLIENT TERMINAL: ILL_SRAC1 STATUS: 0.
Any Ideas? 
And a bit more
As stated above I receive the following error while installing clusterware 10.2.01
OUI-35006: Error while copying the file 'C:\windows\system32\drivers\orafendedrv.sys' within the folder 'C:\windows\system32\drivers' on node 'ILL_SRAC2'. [PRKC-1080: File "C:\windows\system32\drivers\orafencedrv.sys" could not be transfered to given node "ILL_SRAC2". Error on node ILL_SRAC2:null]
before I
pinged all 3 ip's from both nodes
net use on both nodes
runcluvfy on node1 --> no errors
Any Ideas? Should I open a new topic for this one? 
Hello,
I have the same problem.
My Config (Testsystem):
Oracle 10gR2 (10.2.0.1)
VMWare Workstation 5.5 (Trial)
Windows Server 2003
1 Shared Disk with OCFS
2-Nodes RAC
I believe it doesn't matter if disk-caching is disabled or not (for a Testsystem).
I couldn't disable disk-caching too.
While I installed OCFS2 I faced the problem you described already. Manually I copied the files to Node2 (ocfs.sys, orafencedrv.sys, orafenceservice.sys). Everything ok.
Until I started the DBCA in order to install the database.
My error is ( in german too ;-) ):
Instances [racdb1] on Node [rac1] from Clusterdatabase [racdb]
PRKR-1008: Add Instances [racdb1] on Node [rac1] on Clusterdatabase [racdb] failed
CRS-0211: Resource [ora.racdb.racdb1.inst] is registered already. Adding resource failed.
By searching Metalink I found some hints.
They told, that the resource ora.[MyNode1].vip has not enough privileges.
So I used:
..\crs\bin\crs_getperm ora.MyNode1.vip
Name: ora.MyNode1.vip
owner:nt-autorit-t\system:rwx,prgrp::---,other::r--
Adding more privileges:
..\crs\bin\crs_setperm ora.MyNode1.vip -u user:administrator:rwx
I repeat these steps with ora.MyNode2.vip
Trying the DB-Installation again I received the same error.
Maybe it will help you or give you a clou for the next step.
Would be nice if you can tell me what kind of privileges your resources have. Cause, what I don't understand is that my primarygroup (prgrp) is empty? And there are no settings (rwx).
So, please tell me new ideas.
Thanks.
Best regards
Message was edited by:
a tempel 
What version are you trying to install? 9i? 10g? Standard? Enterprise? OCFS is not supported on anything less than Enterprise level install. Instead, you can try using ASM. Oracle has a good RAC install guide here:
http://www.oracle.com/technology/obe/obe10gdb/install/racinstallwin2k/racinstallwin2k.htm
They are working on one for 10gV2, but it is still in beta. You might be able to get it from support though.
I've installed 9i a couple of times, and am working on a 10g install now. The main keys are to make sure that the pre-install setup goes cleanly and that you resolve all errors on clustersetup prior to installing DB software. As long as I make sure that the drives are available to all nodes in Disk Manager with no drive letters or formatting, things usually go ok. Also check and make sure you can ping every interface and net use all local drives. 
Hello,
thanks for your answer.
I use 10gR2 Enterprise Version.
Your Idea to use ASM is good. I know some things about this new feature. I will try it next time.
Currently we use 2 RACs 9.2.0.7 EE on Windows 2003 SP1 with OCFS. Everything is OK. In some month we like to switch to 10G. That is the reason why I try it now.
I know this link already. Anyway, thanks again.
Like you I installed a lot of 9i and some 10g Standalone Databases. My experience is that a good preparation will end in a successful installation. So I check everything very carefully and sometimes twice. I ping the interfaces from each node one another. I tested the connectivity with the net use command too. Finally I backed up the crs.
The problem occurs when I start the installation for the database by the DBCA or the OUI. What I don't understand is, that after a clean installation with a fresh and empty crs will end in the error I described above.
Sorry but I have to ask again - new ideas?
Thanks in advance 
Hello,
I have exactly the same problem. I'm using 10.2.0.2, ASM and for the CRS and Voting Disk Raw Devices provided by SAN. Is there already a solution??
Regards
Frank Großheim 
Hm,
these posts are quite old but indeed I faced the same problem during the last days. What I found out is this:
DBCA can not add instances to the cluster, even when the cluster is perfectly healthy and running.
To examine what happens better I installed a standalone DB with DBCA and then went on to manually (or with OEM) prepare it for cluster availabilty - quite tedious :-)
After all this work was done the last steps were adding the database and instances to the cluster configuration by means of srvctl. Adding the database went fine but even srvctl could NOT add an instance to the cluster. I got the usual PKRK-1008-error but then a very interesting PKRA-2019-error:
"Error executing command C:\oracle\product\10.2.0\crs \bin\crs_profile.exe. File is missing".
Note the space between crs\ and bin, the path is broken. Even within srvctl.bat the environment-variable %CMD% is set to the correct path, so this comes within somewhere of the used java libraries, maybe from some .properties-file or the reason might be that portions of the path are wrongly concatenated.
The summary: My crs-installation is damaged. If srvctl can not add instances to the cluster then of course DBCA can not as well because he uses it. I will now reinstall the Clusterware and try again. If it still fails I will try to trace srvctl, maybe I can find the original command string to crs_profile there and do it manually.
What I am really surprised about: I downloaded the install-binaries let's say 2 months ago. If this is a bug and it is still present why can one find hardly anything about it anywhere?
Regards 
Are there any news on that problem? I'm facing this problem now, too, and have no idea how to solve it. It would be great if someone can help here :-)
Thanks in advance!

Oracle settings and configuration for PS

I am attempting to install PeopleSoft 9.0 CRM etc on an Oracle database. I have a new PC (IBM T41) 1 GB RAM 1.6MHZ CPU.
I have downloaded Oracle 10x, PS 9.0 apps, Tuxedo, BEA, IIS 6.0.
All, except PS has been installed successfully.
Question: What are the settings in Oracle that need to be configured in order to get PeopleSoft 9.0 running. [I am not a DBA and do not know the specifics to get Oracle configured properly]
Is there anyone out there who is able to guide me, either through documentation or a response to this post?
Charles Cohorst 
Try look at Nicolas Gasparotto's blog http://gasparotto.blogspot.com/
Hope that helps... 
Thank you, I looked at the post but it is not addressing the specific issues I need to deal with.
When setting up Oracle 10g do I go to Configuration and Migration tools to set things up or do I go to Warehouse Builder to Administration?
Net Configuration Assistant has me setting up 4 elements:
Listener Configuration
Naming Methods configuration
Local Net Service Name configuration, and
Directory Usage Configuration.
I expect these things are used to build the tnsnames.ora file as I have seen the details in that file from past oracle configuration I have used but I am not sure how to set them up for a unique instance of oracle in my local computer.
Please advise.
Charles Cohorst 
Network configuration assistant may have created at least two out of the four listed files at your ORACLE_HOME/network/admin directory:
tnsnames.ora
sqlnet.ora
It can configure, if required the listener.ora and ldap.ora files. Same issue at your ORACLE_HOME. It is important to make sure those files are properly located, otherwise you won't be able to connect to your instance, and if required, your listener won't be properly configured.
If you want further details on how to configure these files and what the required entries mean, you may want to read the Configuration and Administration of Oracle Net Services reference manual: http://download-west.oracle.com/docs/cd/B19306_01/network.102/b14212/part2.htm#i436475
~ Madrid. 
Hello,
I hope you have solved your problem, but I'll try to resume the main steps of a PS installation :
1. Install Oracle software
2. Install Tuxedo
3. Install BEA
4. Install Peoplesoft application for Oracle
5. Install Peoplesoft Peopletools for Oracle
6. In the deploy PS's directory, there are some scripts to create your Oracle database as well for a PS application, so run them in the order as well
7. Run some datamover to import the Peopletools data
8. If required, run some additional tasks (dms, project) to update your PS installation to the last patch.
Hope that help,
Nicolas.
PS : thanks for given the link Ivan, I have to update my blog more often ;-) 
Thanks for the assistance. For some reason the Oracle listener and naming conventions seem to be off target. I still cannot seem to get the database services to start.
any advice? 
Anyway please post output of following command
lsnrctl status
lsnrctl service
PS : Nicolas , Nice blog. 
Where to I run those commands? 
They are DOS command prompt.
Nicolas.
PS : Virag, thank you ;-) 
When I run the command the program is not found. It errors as "This is not recognized as an internal or external command. I do not have that executable on my machine. 
You should be able to see those commands from the command line, unless you don't have your environment variables properly set.
SET ORACLE_HOME=pathToYourOracleHome
SET ORACLE_SID=yourDefaultInstanceName
SET PATH=%ORACLE_HOME%\bin;%PATH%
retry.
~ Madrid 
I have set my environment variables as indicated but I think my oracle install did not work correctly. the lsnctrl command is still not being recognized. Is it a command file or is it an internal command within another program? 
lsnctrl command is still not being recognized. Is it
a command file or is it an internal command within another program?It is external command.
For example
C:\>cd %oracle_home%\bin
C:\oracle\oraclexe\app\oracle\product\10.2.0\server\BIN>dir lsnr*
Volume in drive C has no label.
Volume Serial Number is 0E54-13D7
Directory of C:\oracle\oraclexe\app\oracle\product\10.2.0\server\BIN
02/02/2006 12:49 AM 65,536 LSNRCTL.EXE 
file does not exist. I did the 10g install. Could it be a different file name? 
lsnrctl.exe is automatically installed along your rdbms installation. It is not optional. When you performed installation, did you have a listener installed too? Was your oracle instace, listener and enterprise manager console running? Then you had your files installed and most probably you are looking at the wrong oracle_home.
Where did you installed your rdbms?
Perform a full file search and take note on where your lsnrctl.exe command is.
Look for sqlplus.exe too.
Once you have found these commands, configure your Environment Variables accordingly.
~ Madrid.

Help regarding Oracle 10g R2 on Linux

Hello Guys,
Few days ago I was doing troubleshooting for one Oracle on Linux installation, I was startled by the following findings, probably installation guy had got something wrong while installation…
I just had few queries regarding this..
1. Can I have multiple Listeners running on my database server?
In our development server we have multiple listeners running, this causes the listener error, only when we have single listener up then things go right.
2. While installation of Oracle 10g, are these directories created by default,
D:\Oracle\product\10.2.0\db_1
D:\Oracle\product\10.2.0\db_2
D:\Oracle\product\10.2.0\dbs
As when I tried to solve the problem of installation of one of the Oracle servers, I could see all these directories created, but when asked to the installer, he said he didn’t create any directory these were created by Oracle.
3. Is it mandatory to create a init.ora file by name of init<db_name>.ora?
4. While trying to up the database got the following message – Unidentified listener,
When went to oracle home saw multiple listeners, one with default name and other with listener<db_name>
Had to set the listener name in init<db_name>.ora file – is this standard way?
5. While trying to up the database after installation – got message –
not enough shared pool size –
i. had to edit entry in init<db_name>.ora file, had to increase the size, is this standard way?
6. After rectifying above steps, and tried to issue STARTUP command, got message –
Control file version mismatch, control file version is 10.2.1.0 and database is of version 10.2.0.0
7. Where as on connecting by – conn /as sysdba, got message – connected to idle oracle instance – version 10.2.0.0
So why these versions mismatch must have occurred?
7. Gave fully qualified path in init<db_name>.ora file for control files as-
i. Control_files=”D:\oracle\product\10.2.0\oradata\control01.cntl”, ”D:\oracle\product\10.2.0\oradata\control01.cntl”
ii. And issued command on sqlplus – “sho parameter files;”
iii. Then it showed proper control files being used.
iv. Then created spfile from ora files, by issuing command,
“create spfile=….. from ….. .ora”
v. Then issued command,
startup pfile= ” fully qualified path .ora”
After doing all these steps, still the error of control files being version mismatched persisted, so ultimately had to give back the machine to installer guy for fresh installation.
I think this time he got things in proper way and things went all well. 
1. The number of listener depend on your specific needs. You can have as many listener as required, as long as each listener works on its own individual listening port.
2. It looks like there were several attempts to install the product, it should be clearly defined if the other oracle homes are required. Otherwise, proper deinstallation through OUI is advised.
3. You don't have to create an init...ora It is considered already obsolete since 9i, where the spfile is the preferred initialization file.
4. No, most probably you have seen some self-registration issues. It should be further clarified.
5. I suggest you to check the memory advisors. 10 g has the automatic instance tuning, so it is advisable to implement too.
6. You must be consistent with the initialization file and controlfile declaration, otherwise you probably referred to an obsolete version. It could prevent your database from starting if not properly managed.
7. Check the installed version.
7bis Just keep a consistent reference to the controlfiles. I strongly suggest you to keep your spfile updated, not the init.ora file.
~ Madrid. 
Hey Madrid,
Thanks for taking pains to answer my all queries,
Your help is really appreciated.
Thanks & Regards,
Avinash.
Pune.
India.

oracle and grid .bash_profile

some problems when config rac:
when create user oracle and grid for RAC related software installation,well, due to some reason, i am not properly config
.bash_profile for oracle and grid for each node,
but i successfully completed this rac installation , does the .bath_profile do some effect on the software installation,
if i want to change the configure of .bash_profile, should i need to re-install the software, 
but i successfully completed this rac installation , does the .bath_profile do some effect on the software installationIt depends on contents of .bash_profile
if i want to change the configure of .bash_profile, should i need to re-install the software,No, you don't need to re-install. 
Hi,
normally the user profile (e.g. bash_profile) is used to set environment variables etc.
Now in the installation guide it is best practices to not set any Oracle related environment variable during install (e.g. ORACLE_BASE, ORACLE_HOME etc.)
So if your error was not to have something set in the profile... no poblem, that is as it should be...
Now if something was set like TNS_ADMIN or ORACLE_CRS_HOME, then your installation could be messed up, because these things go into the configuration.
However if you had this set, you probably would have hit errors during installation.
After installation you can change the .profile(s) as much as you like.... This will not affect the installation.
Regards
Sebastian 
"Now if something was set like TNS_ADMIN or ORACLE_CRS_HOME, then your installation could be messed up, because these things go into the configuration.
However if you had this set, you probably would have hit errors during installation."
yes i do set tns_admin and oracle_crs_home, but this path was somewhat incorrect with my installation, well, my installation have nothing hit errors except for ntp error message whick can be ignored,
"these things go into the configuration." -- well, can i fixed it into correct path now and how?
in my .bash_profile on node 1 my oracle_sid=racdb1, node2 is racdb2
when i use sqlplus / as sysdba command on one node 1, and using startup to open the db, it raise initracdb1.ora not found, how can i fix it,
thanks in advance. 
Hi,
now it would help to know the version of Oracle you are using.
If TNS_ADMIN and ORACLE_CRS_HOME had been set during a 10g installation, then your setup is really messed up, and I would recommend reinstalling, since this could lead to further problems.
I had this one time, and it really gave me troubles finding all the entries where this was set. So the only possible method to remove this is to reinstall.
I have not tried the same with Oracle 11gR2. CLUVFY and the installer checks a lot more and it well may be that the new installer circumvents these problems, so that TNS_ADMIN will not have an effect on the installation.
Unfortunately you will never be 100% sure... except if you reinstall.
Regarding the last thing with sqlplus - this probably has nothing to do with your environemnt.
Again it would help to know which version you are using, and if this is a administrator managed (or pre 11.2 database) or a policy managed database.
So f you are using 11gR2 with a policy managed database, then there is not racdb1 instance... it would be racdb_1. Furthermore you cannot be sure on which node it will be started.
Hence you should always use srvctl to startup your database:
srvctl start database -d racdb
Then if the alert.log still complains about not able to find init file we can check further...
Regards
Sebastian 
hi Sebastian
first , thank you so much for your reply . my db version is 11gR2
your advise is not to config .bash_profile before installation, right? 
Hi Roy,
as Sabastian has stated it is best practise not to set the environment before the install.
I have however done a Grid install of 11gR2 where I had my .bash_profile setup before the install with parameters like:
ORACLE_SID, JAVA_HOME, ORACLE_BASE, ORACLE_HOME, TNS_ADMIN etc. where it did not cause any issues.
Regards.

Categories

Resources