ORACLE-BASE - Basic Enterprise Manager Troubleshooting

ORACLE-BASE - Basic Enterprise Manager Troubleshooting:

'via Blog this'

Read More

how to check linux kernel is 32 bit or 64 bit

how to check linux kernel is 32 bit or 64 bit:

'via Blog this'

Read More

Application Designer on Linux | Blog

Application Designer on Linux | Blog:

'via Blog this'

Read More

MySandbox: Moving the control, data and redo log file of an Oracle 11g R2 database to a new location

MySandbox: Moving the control, data and redo log file of an Oracle 11g R2 database to a new location:

'via Blog this'

Read More

Difference between the creation of Demo and System Databases « PeopleSoft

Difference between the creation of Demo and System Databases « PeopleSoft:

'via Blog this'

Read More

ORA-00022: invalid session ID; access denied Process ID: 10610 Session ID

This is related to Second DB Connection, and can be worked around.  In the  psappsrv.cfg & psprcs.cfg make the DbFlags=4, to disable Second DB Connection.

Read More

Missing or Invalid Version of SQL Library libpsora

Taken from customer connection..

E:AS Missing or Invalid Version of SQL Library libpsora PeopleTools 8.48+ on Oracle 10g and 11i [ID 650409.1]
		Modified 30-MAR-2012     Type PROBLEM     Status ARCHIVED

In this Document
  Symptoms
  Cause
  Solution

---

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version: 8.48 to 8.51   [Release: 8.4 to 8.4]
Generic Linux
***Checked for relevance on 23-Aug-2011***

Symptoms

Application server can't start because of bad link.  The application server is looking for a library that does not exist: dlopen in libpscompat failed for libpsora.sl: ld.so.1: PSAPPSRV: fatal: libclntsh.sl.9.0: open failed: No such file or directory

stderr file has errors similar to:

/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.9.0'.

stdout file has the error:

shl_load in libpscompat failed for libpsora.sl

Cause

Not Applicable

Solution

PeopleSoft now supports 64 bit Oracle for PeopleTools 8.48 and later. The library libclntsh.so.10.1 (Oracle 10g) libclntsh.so.11.1 (Oracle 11i) must be linked in the 64 bit lib directory.

NOTE: On Linux platforms for PeopleTools 8.48 and 8.49 we are still using the 32 bit libraries for the application server. Starting with PeopleTools 8.50 Linux now uses the 64 bit libraries. Make sure you are linking the libclntsh.sl.9.0 file from the $ORACLE_HOME/lib32 directory if running 64 bit Linux prior to PeopleTools 8.50. If you have only installed the Oracle 32 bit client on Linux you may only have the lib directory and not lib32, so do the link from the lib directory in this case.

If stderr error reports an error with libclntsh.sl.9.0, run the link command in the $ORACLE_HOME/lib directory as the oracle user :

     ln -s $ORACLE_HOME/lib/libclntsh.sl.10.1 libclntsh.sl.9.0    (Oracle 10g)

     ln -s $ORACLE_HOME/lib/libclntsh.so.11.1 libclntsh.sl.9.0    (Oracle 11i)

If stderr error reports an error with libclntsh.so.9.0, run the link command in the $ORACLE_HOME/lib directory as the oracle user :

     ln -s $ORACLE_HOME/lib/libclntsh.so.10.1  libclntsh.so.9.0   (Oracle 10g)
     
     ln -s $ORACLE_HOME/lib/libclntsh.so.11.1 libclntsh.so.9.0 (Oracle 11i)

** NOTE ** Check your library name in the $ORACLE_HOME/lib directory to make sure it it the exact name above. It the name differs replace above name with yours.

Make sure your LIBPATH, SHLIB_PATH or LD_LIBRARY_PATH references the $ORACLE_HOME 64 bit libraries ($ORACLE_HOME/lib).

Check your $PS_HOME/install/psdb.sh script and make sure the PATH's in there points to the 64 bit libraries for Oracle.

On PeopleTools 8.48+ the location of psdb.sh is $PS_HOME/setup

After fixing this, re-logon as the psoft account to reset your environment. Make sure you reconfigure your domain so it picks up the new changes. Check your $PS_HOME/appserv/DomainName/psappsrv.env file to ensure that your environment has the Oracle 64 bit libraries in your LIBPATH, SHLIB_PATH or LD_LIBRARY_PATH and not $ORACLE_HOME/lib32.

Read More

Changing hostname – The UNIX way!

While the /etc/hosts file is generally the first to come to mind when you think about changing the name of a Unix system, modifying this file is only one step in the process. The other files that need to be changed depend on which particular version of “*nix” you are running.

The following is a list of UNIX flavors and methods of changing hostname permanently on each system.

Solaris

On Solaris, there are three files that you need to edit. These include /etc/hosts, /etc/hostname. and /etc/nodename.

- Edit /etc/hosts with vi and update to the new hostname.
- Similarly update /etc/nodename using an editor or “echo newhost > /etc/nodename”
- Lastly, edit /etc/hostname.. The should be replaced by the name of the particular network interface on your server. For example, a common name is /etc/hostname.hme0. If you’re not sure about the interface name, simply do an ‘ifconfig -a’, this’ll display the network interface name.

Once you’ve updated the above 3 files, best thing is to reboot your system or if can’t reboot right away, you can execute ‘uname -S ‘ command to assign the new hostname immediately.

Redhat Linux (Fedora, Mandriva, PCLos)

On Redhat based Linux systems, the primary setting for the system hostname is included in the /etc/sysconfig/network file.

- Open this file in editor, you should see something like this:
—————————————————-
NETWORKING=yes
HOSTNAME=abc.example.com
—————————————————-
- and of course the /etc/hosts file.

Debian/Ubuntu Linux

Debian based systems use the file /etc/hostname to read the hostname of the system at boot time and set it up using the init script /etc/init.d/hostname.sh.

- Edit /etc/hostname and update to your new hostname, you can then run /etc/init.d/hostname.sh to activiate the change.
- Update your /etc/hosts file to refelect new hostname

You can also use sysctl to change the hostname:

- sysctl kernel.hostname (To read the current hostname)
- sysctl kernel.hostname=NEW_HOSTNAME (to change it)

To change in gui in Ubuntu you can click to:

- System > Administration > Networking > General tab > Host name field

Slackware Linux

Similar to Debian except the it is uppercase HOSTNAME.

- Edit /etc/HOSTNAME and update to new value
- Update /etc/hosts to new hostname value as well

SuSE Linux

To change hostname permanently on SuSE Linux

- Edit the file /etc/HOSTNAME and change the value in it, Save and exit
- Update /etc/hosts to new hostname value

Mac OSX

To change hostname on a Mac OSX server…

- Edit /etc/hostconfig and update to your new hostname
- And of course the /etc/hosts file needs to be adjusted to your new host

You can also execute the following command:

- sudo scutil –set HostName abc.example.com

OpenBSD

Very similar to Solaris operating system.

- Update to new hostname in /etc/hosts file
- Make appropriate change in /etc/myname
- Lastly, /etc/hostname.. Similar to Solaris, you’ll need to identify system interface and update this file appropriately.

HP-UX

The script /sbin/set_parms changes system parameters including hostname and IP address.

- /sbin/set_parms

Digital Unix

- Edit /etc/hostname.driver

- As well as /etc/hosts file

FreeBSD

To change hostname do:

- Edit /etc/rc.conf and update to new hostname value

- Edit /etc/hosts

AIX

AIX stores all its information in ODM (Object Database Manager) including hostname value. There are a couple ways of doing it:

- chdev -l inet0 -a hostname=thomas

Or you can use smitty as well.

NetBSD

- Edit /etc/myname

- And of course edit /etc/hosts file 

SCO Unix

I don’t know who in their right mind would run SCO these days. But anyhow the way to change hostname permanently is:

- sys-unconfig

IRIX

I can understand why IRIX may still be used. To change hostname:

- Edit /etc/sys_id and update to new host value

- Edit /etc/hosts as well

Then reboot your workstation/server for changes to take affect.

Finally, some general facts about all Linux distros. The following are commands that are unique to all flavors of Linux:

To print current system hostname on the system:

- hostname
- uname -n
- cat /etc/hosts | grep 127.0.0.1

To print the fully qualified domain name of the system:

- hostname -fqd

To temporarily update the system to new hostname:

- hostname new_hostname
- echo “new hostname” > /proc/sys/kernel/hostname

On most Linux flavors, you can also execute the command:

- netconfig

Read More

The Application has Failed to Start Because its Side-by-side Configuration is Incorrect

Issue: The Application has Failed to Start Because its Side-by-side Configuration is Incorrect

If any time you face issue like this when you open any executable of peopletools, it means VC++ compiler is not installed. you can install it from PSHOME/setup/vcr directory.

Thanks,

Praveen Joshi

Read More

On The Peoplesoft Road: Troubleshooting : process scheduler and distribution

On The Peoplesoft Road: Troubleshooting : process scheduler and distribution:

'via Blog this'

Read More

PeopleSoft Process Scheduler

Processes Stuck at Queued 

There are a number of reasons why a process might be stuck at queued. The most obvious is that the process scheduler is down (check the Servers tab in the process monitor). Beyond this, there are some useful troubleshooting that apply:
Check the following tables:

• PSPRCSRQST 
• PSPRCSQUE 
• PSPRCSPARMS

The row count should be the same in both tables. If one is out of sync with the other, then it can help to remove orphaned instances in of the tables. Restarting the process scheduler and clearing the process scheduler cache will also fix a number of issues.

Run status

In the PeopleTools 8.4x look at the translates on the field RUNSTATUS or use the query.

select FIELDVALUE, XLATLONGNAME 
from PSXLATITEM 
where FIELDNAME = 'RUNSTATUS'

Here's a summary of the run status translates (from PeopleTools 8.49). Note that not all of these are active.





















Value
Status
1
Cancel
2
Delete
3
Error
4
Hold
5
Queued
6
Initiated
7
Processing
8
Cancelled
9
Success
10
Not Successful
11
Posted
12
Unable to Post
13
resend
14
Posting
15
Content Generated
16
Pending
17
Success with Warning
18
Blocked
19
Restart

The following query will give you a summary of the process run statuses in your process request table:


select     
    RUNSTATUS,
    (
        select  XLATSHORTNAME
        from    PSXLATITEM
        where   FIELDNAME = 'RUNSTATUS'
        and     FIELDVALUE = RUNSTATUS
    ) as RUNSTATUS_DESCR,
    count(PRCSINSTANCE)
from  
    PSPRCSRQST
group by 
    RUNSTATUS
order by 
    RUNSTATUS;

Summary of requested processes by process status.


The following query will give you a summary of the requested processes by process status.



select
    RQST.RUNSTATUS,
    RQST.PRCSTYPE,
    (
        select XLAT.XLATLONGNAME
        from PSXLATITEM XLAT
        where XLAT.EFFDT = (
            select max(XLAT_ED.EFFDT)
            from PSXLATITEM XLAT_ED
            where XLAT_ED.FIELDNAME = XLAT.FIELDNAME
            and XLAT_ED.FIELDVALUE = XLAT.FIELDVALUE
        ) and XLAT.FIELDNAME = 'RUNSTATUS'
        and XLAT.FIELDVALUE = RQST.RUNSTATUS
    ) as RUNSTATUS_XLAT,
    count(RQST.PRCSINSTANCE) as TOTAL_PROCESSES,
    min(RUNDTTM) as FIRST_OCCURRED,
    max(RUNDTTM) as LAST_OCCURRED
from PSPRCSRQST RQST
group by RQST.RUNSTATUS, RQST.PRCSTYPE
order by RUNSTATUS_XLAT, RQST.PRCSTYPE

Distribution

The following tables store information about the distribution of process scheduler output to users or roles.

PS_PRCSDEFNCNTDIST
Distribution settings for process definitions.

PS_PRCSJOBCNTDIST
Distribution settings for jobs.

PS_PRCSRQSTDIST
Distribution settings by process instance. Join to PS_CDM_FILE_LIST on the process instance to get the file names.

PS_PRCSRUNCNTLDIST
Distribution by operator ID and run control.

Taken from http://peoplesoft.wikidot.com

Read More