Hello,

Currently my PeopleSoft signon page is displaying error message. I
am not understanding the reason for that I could able to

connect using the DataMover (2-tier) and Application Designer (3-
tier). But while typing URL

(http://serverIP/psp/Domain/?cmd=login) and running in browser it's
giving the following error message:

Your URL must contain domain ".ps.peoplesoft.com"

Click Sign in to PeopleSoft to try again.

If the error persists, please contact your System Administrator for
assistance.

So, I started my WL from command mode. In the command line interface
it's displaying:

<Thread "ListenThread.Default" listening on port 80, ip address *.*>
SchedulerTransfer, authentication failed
SchedulerTransfer, authentication failed
SchedulerTransfer, authentication failed
SchedulerTransfer, authentication failed

What are these last 4 lines refer to?

Any suggestions please...

--Pavan.

Has anyone come across this before?  This is very intermittent and as
far as I can determine only happens in one database.  The user clicks
on the Save and Submit button (so far when creating a new job or trying
to hire someone) and gets an ORA-00030: User session ID does not exist
error.  Then gets ORA-00022:invalid session ID; access denied then gets
a long peoplecode error. I can see how the other two errors would occur
if the session id was dropped.

I don't have any errors in the database alert log.  The ORA-
00022:invalid session ID shows up on the appserver sql trace.

Sounds like the web server is trying to reuse a connection that no
longer exists. Did the database get bounced without bouncing the web
server. Or perhaps is their a profile set up in Oracle to disconnect
idle sessions? Maybe a session got disconnected without the web server
knowing about it.


kellykday wrote:

>Has anyone come across this before?  This is very intermittent and as
>far as I can determine only happens in one database.  The user clicks
>on the Save and Submit button (so far when creating a new job or trying
>to hire someone) and gets an ORA-00030: User session ID does not exist
>error.  Then gets ORA-00022:invalid session ID; access denied then gets
>a long peoplecode error. I can see how the other two errors would occur
>if the session id was dropped.
>
>I don't have any errors in the database alert log.  The ORA-
>00022:invalid session ID shows up on the appserver sql trace.
>
>
>
>
>
>
>PeopleSoft for the Oracle DBA is published by Apress - see
http://www.psftdba.com.
>The PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk.
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>

I agree.  The overwhelming majority of PT8.4x users use BEA weblogic (in the
early days of PT8.1x there was a preference for Apache).  I have only been
on one Websphere site, and I have lost count of the number of Weblogic
sites.

From the little that I have seen of Websphere, I am not impressed.  If you
use the IBM HTTP server, then there appears to be no access logging!

However, I think the trend was established largely a matter of history!
Originally, PT8.1 was certified with Apache 1.3 and Weblogic.  PT8.4 was
certified with Weblogic and Websphere.  A lot of customers who took 8.1 when
8.4 was on the horizon decided to go Weblogic because they wouldn't have to
change servers when they upgraded.

I sometimes think that the only reason that PeopleSoft even considered
Websphere was that they were busy schmoozing up to IBM, and so they liked to
suggest that IBM websphere was a good thing.

Of course now there are other options.  Tomcat is certfied, and from PT8.47
so is Oracle Application Server (sorry - that should now be referred to as
Oracle Fusion Middleware).

regards
(Sorry for delay in response - I've been away for the last week.)
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf
> Of Wolfgang Breitling
> Sent: 28 December 2005 14:57
> To: psftdba@yahoogroups.com
> Subject: [*SUSPECTED SPAM*] Re: PeopleSoft DBA Forum Peoplesoft
> implementations with WebLogic or Websphere? Blocked - see
> http://www.spamcop.net/bl.shtml?216.155.203.223
>
>
> I can cast 3 votes for weblogic, 1 each for 3 different clients. At the
> university of Calgary, where I currently am, we had started out with
> websphere because the university operates a portal implemented on
> websphere.
> But after an initial websphere implementation we switched to weblogic.
> Raised some eyebrows but weblogic has a smaller resource footprint, is
> easier to administer and there are more people around how CAN administer
> it.And judging from the number of weblogic-related vs websphere-related
> presentations at Peoplesoft-related conferences (a lot of relationships in
> this sentence) weblogic seems far more prevalent so you are more likely to
> find answers and tips for it in the user community.
>
> ----- Original Message -----
> From: <shirley.mcgregor@...>
> To: <psftdba@yahoogroups.com>
> Sent: Wednesday, December 28, 2005 12:02 AM
> Subject: PeopleSoft DBA Forum Peoplesoft implementations with WebLogic or
> Websphere?
>
>
> >
> > I'm just curious and this is not really the place to ask.......however
> >
> > What percentage of forum participants use Weblogic in the PIA vs
> Websphere?
> >
> > In the reply please include client (numbers) and product.   eg.
> Peoplesoft
> > Financials, 200 users, Weblogic.
> >
> > David K.  - I know you have many clients, do you know a rough overall
> > percentage?
> >
> >
> >
> > Thanks and Happy New Year to all of the psftdba's out there!
> >
> > Shirley
> >
> > -----
> >
> >
> >
> >

I agree.  The overwhelming majority of PT8.4x users use BEA weblogic (in the
early days of PT8.1x there was a preference for Apache).  I have only been
on one Websphere site, and I have lost count of the number of Weblogic
sites.

From the little that I have seen of Websphere, I am not impressed.  If you
use the IBM HTTP server, then there appears to be no access logging!

However, I think the trend was established largely a matter of history!
Originally, PT8.1 was certified with Apache 1.3 and Weblogic.  PT8.4 was
certified with Weblogic and Websphere.  A lot of customers who took 8.1 when
8.4 was on the horizon decided to go Weblogic because they wouldn't have to
change servers when they upgraded.

I sometimes think that the only reason that PeopleSoft even considered
Websphere was that they were busy schmoozing up to IBM, and so they liked to
suggest that IBM websphere was a good thing.

Of course now there are other options.  Tomcat is certfied, and from PT8.47
so is Oracle Application Server (sorry - that should now be referred to as
Oracle Fusion Middleware).

regards
(Sorry for delay in response - I've been away for the last week.)
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf
> Of Wolfgang Breitling
> Sent: 28 December 2005 14:57
> To: psftdba@yahoogroups.com
> Subject: [*SUSPECTED SPAM*] Re: PeopleSoft DBA Forum Peoplesoft
> implementations with WebLogic or Websphere? Blocked - see
> http://www.spamcop.net/bl.shtml?216.155.203.223
>
>
> I can cast 3 votes for weblogic, 1 each for 3 different clients. At the
> university of Calgary, where I currently am, we had started out with
> websphere because the university operates a portal implemented on
> websphere.
> But after an initial websphere implementation we switched to weblogic.
> Raised some eyebrows but weblogic has a smaller resource footprint, is
> easier to administer and there are more people around how CAN administer
> it.And judging from the number of weblogic-related vs websphere-related
> presentations at Peoplesoft-related conferences (a lot of relationships in
> this sentence) weblogic seems far more prevalent so you are more likely to
> find answers and tips for it in the user community.
>
> ----- Original Message -----
> From: <shirley.mcgregor@...>
> To: <psftdba@yahoogroups.com>
> Sent: Wednesday, December 28, 2005 12:02 AM
> Subject: PeopleSoft DBA Forum Peoplesoft implementations with WebLogic or
> Websphere?
>
>
> >
> > I'm just curious and this is not really the place to ask.......however
> >
> > What percentage of forum participants use Weblogic in the PIA vs
> Websphere?
> >
> > In the reply please include client (numbers) and product.   eg.
> Peoplesoft
> > Financials, 200 users, Weblogic.
> >
> > David K.  - I know you have many clients, do you know a rough overall
> > percentage?
> >
> >
> >
> > Thanks and Happy New Year to all of the psftdba's out there!
> >
> > Shirley
> >
> > -----
> >
> >
> >
> >

---

YAHOO! GROUPS LINKS

•  Visit your group "psftdba" on the web.
   
•  To unsubscribe from this group, send an email to:
   psftdba-unsubscribe@yahoogroups.com
   
•  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of satya seelam
Sent: 09 January 2006 18:43
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Threads and Thread Tasks

Hi,
I am working on Performance and Tuning.

 

 

Presently my system having MAXTHRADTASKS(3000)

 

and MAXTHREADS(5000)

 

 

If i increase no. Of tasks like 5000 and MaxThreads like 10000.

 

Is it the performance will increase or decrease of the overall system?

 

 

Thanks,

 

satya
David Kurtz <info2@...> wrote:

I agree.  The overwhelming majority of PT8.4x users use BEA weblogic (in the
early days of PT8.1x there was a preference for Apache).  I have only been
on one Websphere site, and I have lost count of the number of Weblogic
sites.

From the little that I have seen of Websphere, I am not impressed.  If you
use the IBM HTTP server, then there appears to be no access logging!

However, I think the trend was established largely a matter of history!
Originally, PT8.1 was certified with Apache 1.3 and Weblogic.  PT8.4 was
certified with Weblogic and Websphere.  A lot of customers who took 8.1 when
8.4 was on the horizon decided to go Weblogic because they wouldn't have to
change servers when they upgraded.

I sometimes think that the only reason that PeopleSoft even considered
Websphere was that they were busy schmoozing up to IBM, and so they liked to
suggest that IBM websphere was a good thing.

Of course now there are other options.  Tomcat is certfied, and from PT8.47
so is Oracle Application Server (sorry - that should now be referred to as
Oracle Fusion Middleware).

regards
(Sorry for delay in response - I've been away for the last week.)
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf
> Of Wolfgang Breitling
> Sent: 28 December 2005 14:57
> To: psftdba@yahoogroups.com
> Subject: [*SUSPECTED SPAM*] Re: PeopleSoft DBA Forum Peoplesoft
> implementations with WebLogic or Websphere? Blocked - see
> http://www.spamcop.net/bl.shtml?216.155.203.223
>
>
> I can cast 3 votes for weblogic, 1 each for 3 different clients. At the
> university of Calgary, where I currently am, we had started out with
> websphere because the university operates a portal implemented on
> websphere.
> But after an initial websphere implementation we switched to weblogic.
> Raised some eyebrows but weblogic has a smaller resource footprint, is
> easier to administer and there are more people around how CAN administer
> it.And judging from the number of weblogic-related vs websphere-related
> presentations at Peoplesoft-related conferences (a lot of relationships in
> this sentence) weblogic seems far more prevalent so you are more likely to
> find answers and tips for it in the user community.
>
> ----- Original Message -----
> From: <shirley.mcgregor@...>
> To: <psftdba@yahoogroups.com>
> Sent: Wednesday, December 28, 2005 12:02 AM
> Subject: PeopleSoft DBA Forum Peoplesoft implementations with WebLogic or
> Websphere?
>
>
> >
> > I'm just curious and this is not really the place to ask.......however
> >
> > What percentage of forum participants use Weblogic in the PIA vs
> Websphere?
> >
> > In the reply please include client (numbers) and product.   eg.
> Peoplesoft
> > Financials, 200 users, Weblogic.
> >
> > David K.  - I know you have many clients, do you know a rough overall
> > percentage?
> >
> >
> >
> > Thanks and Happy New Year to all of the psftdba's out there!
> >
> > Shirley
> >
> > -----
> >
> >
> >
> >

What leads you to suspect that the number of JVM threads has any bearing on performance?

Are you getting any related error messages?

 

>  Is it the performance will increase or decrease of the overall system?

The flippant answer to question is: maybe - but maybe not because it might stay the same!

If you change parameters randomly you are likely to get random results!

 

A well known author once wrote 'Performance tuning is a search for lost time'.  

 

You should be looking for the amount of time spent doing a transaction, and as far a possible break it down so that you can quantify how much time was spent in which tier or opperation within that transaction.  Then start to attack the thing that took the most time.  If you know exactly what took the most time, then you will have a better idea of what might be causing the poor performance, and possibly more importantly what is not contributing to your problem.  Then you will know whether to leave it alone.

 

 

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of satya seelam
Sent: 09 January 2006 18:43
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Threads and Thread Tasks

Hi,
I am working on Performance and Tuning.

 

 

Presently my system having MAXTHRADTASKS(3000)

 

and MAXTHREADS(5000)

 

 

If i increase no. Of tasks like 5000 and MaxThreads like 10000.

 

Is it the performance will increase or decrease of the overall system?

 

 

Thanks,

 

satya
David Kurtz <info2@...> wrote:

I agree.  The overwhelming majority of PT8.4x users use BEA weblogic (in the
early days of PT8.1x there was a preference for Apache).  I have only been
on one Websphere site, and I have lost count of the number of Weblogic
sites.

From the little that I have seen of Websphere, I am not impressed.  If you
use the IBM HTTP server, then there appears to be no access logging!

However, I think the trend was established largely a matter of history!
Originally, PT8.1 was certified with Apache 1.3 and Weblogic.  PT8.4 was
certified with Weblogic and Websphere.  A lot of customers who took 8.1 when
8.4 was on the horizon decided to go Weblogic because they wouldn't have to
change servers when they upgraded.

I sometimes think that the only reason that PeopleSoft even considered
Websphere was that they were busy schmoozing up to IBM, and so they liked to
suggest that IBM websphere was a good thing.

Of course now there are other options.  Tomcat is certfied, and from PT8.47
so is Oracle Application Server (sorry - that should now be referred to as
Oracle Fusion Middleware).

regards
(Sorry for delay in response - I've been away for the last week.)
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf
> Of Wolfgang Breitling
> Sent: 28 December 2005 14:57
> To: psftdba@yahoogroups.com
> Subject: [*SUSPECTED SPAM*] Re: PeopleSoft DBA Forum Peoplesoft
> implementations with WebLogic or Websphere? Blocked - see
> http://www.spamcop.net/bl.shtml?216.155.203.223
>
>
> I can cast 3 votes for weblogic, 1 each for 3 different clients. At the
> university of Calgary, where I currently am, we had started out with
> websphere because the university operates a portal implemented on
> websphere.
> But after an initial websphere implementation we switched to weblogic.
> Raised some eyebrows but weblogic has a smaller resource footprint, is
> easier to administer and there are more people around how CAN administer
> it.And judging from the number of weblogic-related vs websphere-related
> presentations at Peoplesoft-related conferences (a lot of relationships in
> this sentence) weblogic seems far more prevalent so you are more likely to
> find answers and tips for it in the user community.
>
> ----- Original Message -----
> From: <shirley.mcgregor@...>
> To: <psftdba@yahoogroups.com>
> Sent: Wednesday, December 28, 2005 12:02 AM
> Subject: PeopleSoft DBA Forum Peoplesoft implementations with WebLogic or
> Websphere?
>
>
> >
> > I'm just curious and this is not really the place to ask.......however
> >
> > What percentage of forum participants use Weblogic in the PIA vs
> Websphere?
> >
> > In the reply please include client (numbers) and product.   eg.
> Peoplesoft
> > Financials, 200 users, Weblogic.
> >
> > David K.  - I know you have many clients, do you know a rough overall
> > percentage?
> >
> >
> >
> > Thanks and Happy New Year to all of the psftdba's out there!
> >
> > Shirley
> >
> > -----
> >
> >
> >
> >

Send instant messages to your online friends http://in.messenger.yahoo.com

Send instant messages to your online friends http://in.messenger.yahoo.com

Can anyone please tell us why our Process Scheduler view log/trace
files are empty for all processes run on one of our instances?  What
have we not configured/switched on/checked? Other instances are showing
log messages as normal.
Thanks,
Ben

Your report repository isn't defined????  Is the output being created on
your server?

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul. Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you
can determine how it will be spent. Be careful lest you let other people
spend it for you."

Carl Sandburg
(1878 - 1967)


----Original Message Follows----

Can anyone please tell us why our Process Scheduler view log/trace
files are empty for all processes run on one of our instances?  What
have we not configured/switched on/checked? Other instances are showing
log messages as normal.
Thanks,
Ben

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement

I am checking Stored procedure performance using SQL Server 2005 profiler.....sometimes the number of read and writes and the duration of SP execution has big difference....can u tell me why and wht are the better ways to use the tool....

Regards

Ghanshyam

David Kurtz <info2@...> wrote:

What leads you to suspect that the number of JVM threads has any bearing on performance?

Are you getting any related error messages?

 

>  Is it the performance will increase or decrease of the overall system?

The flippant answer to question is: maybe - but maybe not because it might stay the same!

If you change parameters randomly you are likely to get random results!

 

A well known author once wrote 'Performance tuning is a search for lost time'.  

 

You should be looking for the amount of time spent doing a transaction, and as far a possible break it down so that you can quantify how much time was spent in which tier or opperation within that transaction.  Then start to attack the thing that took the most time.  If you know exactly what took the most time, then you will have a better idea of what might be causing the poor performance, and possibly more importantly what is not contributing to your problem.  Then you will know whether to leave it alone.

 

 

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of satya seelam
Sent: 09 January 2006 18:43
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Threads and Thread Tasks

Hi,
I am working on Performance and Tuning.

 

 

Presently my system having MAXTHRADTASKS(3000)

 

and MAXTHREADS(5000)

 

 

If i increase no. Of tasks like 5000 and MaxThreads like 10000.

 

Is it the performance will increase or decrease of the overall system?

 

 

Thanks,

 

satya
David Kurtz <info2@...> wrote:

I agree.  The overwhelming majority of PT8.4x users use BEA weblogic (in the
early days of PT8.1x there was a preference for Apache).  I have only been
on one Websphere site, and I have lost count of the number of Weblogic
sites.

From the little that I have seen of Websphere, I am not impressed.  If you
use the IBM HTTP server, then there appears to be no access logging!

However, I think the trend was established largely a matter of history!
Originally, PT8.1 was certified with Apache 1.3 and Weblogic.  PT8.4 was
certified with Weblogic and Websphere.  A lot of customers who took 8.1 when
8.4 was on the horizon decided to go Weblogic because they wouldn't have to
change servers when they upgraded.

I sometimes think that the only reason that PeopleSoft even considered
Websphere was that they were busy schmoozing up to IBM, and so they liked to
suggest that IBM websphere was a good thing.

Of course now there are other options.  Tomcat is certfied, and from PT8.47
so is Oracle Application Server (sorry - that should now be referred to as
Oracle Fusion Middleware).

regards
(Sorry for delay in response - I've been away for the last week.)
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf
> Of Wolfgang Breitling
> Sent: 28 December 2005 14:57
> To: psftdba@yahoogroups.com
> Subject: [*SUSPECTED SPAM*] Re: PeopleSoft DBA Forum Peoplesoft
> implementations with WebLogic or Websphere? Blocked - see
> http://www.spamcop.net/bl.shtml?216.155.203.223
>
>
> I can cast 3 votes for weblogic, 1 each for 3 different clients. At the
> university of Calgary, where I currently am, we had started out with
> websphere because the university operates a portal implemented on
> websphere.
> But after an initial websphere implementation we switched to weblogic.
> Raised some eyebrows but weblogic has a smaller resource footprint, is
> easier to administer and there are more people around how CAN administer
> it.And judging from the number of weblogic-related vs websphere-related
> presentations at Peoplesoft-related conferences (a lot of relationships in
> this sentence) weblogic seems far more prevalent so you are more likely to
> find answers and tips for it in the user community.
>
> ----- Original Message -----
> From: <shirley.mcgregor@...>
> To: <psftdba@yahoogroups.com>
> Sent: Wednesday, December 28, 2005 12:02 AM
> Subject: PeopleSoft DBA Forum Peoplesoft implementations with WebLogic or
> Websphere?
>
>
> >
> > I'm just curious and this is not really the place to ask.......however
> >
> > What percentage of forum participants use Weblogic in the PIA vs
> Websphere?
> >
> > In the reply please include client (numbers) and product.   eg.
> Peoplesoft
> > Financials, 200 users, Weblogic.
> >
> > David K.  - I know you have many clients, do you know a rough overall
> > percentage?
> >
> >
> >
> > Thanks and Happy New Year to all of the psftdba's out there!
> >
> > Shirley
> >
> > -----
> >
> >
> >
> >

Send instant messages to your online friends http://in.messenger.yahoo.com

Send instant messages to your online friends http://in.messenger.yahoo.com

Can anyone please tell us why our Process Scheduler view log/trace
files are empty for all processes run on one of our instances?  What
have we not configured/switched on/checked? Other instances are showing
log messages as normal.
Thanks,
Ben

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of Piyush Agarwal
Sent: 13 January 2006 04:22
To: psftdba@yahoogroups.com
Subject: [*SUSPECTED SPAM*] PeopleSoft DBA Forum Using PeopleSoft Schema in one environment to create another environment Blocked - see http://www.spamcop.net/bl.shtml?66.94.237.54

How can a PeopleSoft Schema in one Oracle database environment be used to create another Oracle database environment? What is the best approach and what steps would be necessary. Can Oracle Export/Import be used? With export/import the import errors out due to constraints.

---

Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.

Quite a lot of potential mistakes here, not sure where to start…

 

You’ve obviously run at least some of the scripts as SYSTEM or alternatively run the scripts without having first created the PeopleSoft Tablespaces (hrddl.sql=.  PSSTATUS should be owned by the PeopleSoft owner you used in psadmin.sql – usually SYSADM.  Did you create the PeopleSoft connect user, usually PEOPLE?  The grant.sql script grants this user read access to SYSADM.PSSTATUS.  You also seem to be confusing schemas / users with tablespaces?  Have you imported the PeopleSoft database using datamover – you won’t be able to login in as PS until you have a database to login in to.

 

 If I were you I’d start with the install manual and follow it step by step.

 

 

Robert Ellis

PSE Data Security GmbH

http://www.psedatasecurity.com

---

From: Manoj Negi [mailto:negi2u@...]
Sent: 13 January 2006 10:37
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Unable to login into the Application Designer.

 

Dear All,

 

I am trying to create a demo database in oracle 9i but not able to login into the Application Designer.

 

I have manually created the HCM 8.8 database and run all the data mover scripts that exist in “scripts\nt” folder (as per the installation guide.). I also run the connect.sql to grant the necessary access to people connect id. I have also granted PSADMIN role to PS in order to connect to the database successfully.

 

I can logon into the data mover in bootstrap mode but not able to login into the Application Designer using PS userid. I am sure that I have run all the scripts but don't know why I am not able to login into the Application Designer. Prior experiment with the MSSQL server 2000 is all successful but the problem is only with the Oracle 9i.

 

When I run the Application Designer trace I came to know that system is looking for PS.PSSTATUS instead of SYSTEM.PSSTATUS because PSSTATUS table exists in the SYSTEM tablespace not PS tablespace. I am out of choice now.

 

Can anybody help me in this issue and let me know how I can login into the Application Designer.

 

Thanks,

 

Manoj

---

Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!

SPONSORED LINKS

Peoplesoft software

Oracle dba

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of Manoj Negi
Sent: 13 January 2006 10:24
To: psftdba@yahoogroups.com
Subject: [*SUSPECTED SPAM*] RE: PeopleSoft DBA Forum Unable to login into the Application Designer. Blocked - see http://www.spamcop.net/bl.shtml?66.94.237.35

Thanks Robert,

 

Let me rephrase what I did before starting the data mover script.

 

Step-1) I have created a service called HR88DEMO using the oradim utility (I want to create the database manually not through the DBCA). Create an initHR88DEMO.ora file and set all the parameters i.e CONTROL_FILES, UNDO_TABLEPSPACE, Block size and SGA, PGA memory parameters. Place this file into the ORACLE_HOME\database folder. Start the HR88DEMO service using the oradim utility.

 

Step-2) Open the command prompt and issued the following commands:

 

set oracle_sid=HR88DEMO

connect / as sysdba

startup database nomount pfile=ORACLE_HOME\database\initHR88DEMO.ora

create database HR88DEMO......

 

Step-3) After that I run the utlspace.sql -> ptddl.sql ->hcddl.sql -> rollback.sql (though I am using the UNDO tablespace but still I run this sql) -> create user PS ->

psadmin.sql -> psdbowner.sql -> connect.sql. I run this script as per installation guide instruction except createdb.sql. I create everything using SYSTEM as sysdba or without sysdba (where sysdba is not written).

 

Step-4) I create a database setup script and using the following settings.

 

Database:           HR88DEMO

Access ID:          SYSADMA

Symbolic ID:       PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Symbolic PWD:  PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Connect ID:        people

 

After running the data mover script, I am not able to login into the Application Designer.  You are right that I am confusing but only for schema not for the tablespace and user. I know what is user and tablespace but don't know what's meaning of schema and where it's used in PeopleSoft terminology. I also did installation in SQL Server and it's successful but with oracle this is second time and again it’s in failure stage... :-)

 

Let me know if you have any further suggestions.

 

Thanks,

 

Manoj

Robert Ellis <robert.ellis@...> wrote:

Quite a lot of potential mistakes here, not sure where to start…

 

You’ve obviously run at least some of the scripts as SYSTEM or alternatively run the scripts without having first created the PeopleSoft Tablespaces (hrddl.sql=.  PSSTATUS should be owned by the PeopleSoft owner you used in psadmin.sql – usually SYSADM.  Did you create the PeopleSoft connect user, usually PEOPLE?  The grant.sql script grants this user read access to SYSADM.PSSTATUS.  You also seem to be confusing schemas / users with tablespaces?  Have you imported the PeopleSoft database using datamover – you won’t be able to login in as PS until you have a database to login in to.

 

 If I were you I’d start with the install manual and follow it step by step.

 

 

Robert Ellis

PSE Data Security GmbH

http://www.psedatasecurity.com

---

From: Manoj Negi [mailto:negi2u@...]
Sent: 13 January 2006 10:37
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Unable to login into the Application Designer.

 

Dear All,

 

I am trying to create a demo database in oracle 9i but not able to login into the Application Designer.

 

I have manually created the HCM 8.8 database and run all the data mover scripts that exist in “scripts\nt” folder (as per the installation guide.). I also run the connect.sql to grant the necessary access to people connect id. I have also granted PSADMIN role to PS in order to connect to the database successfully.

 

I can logon into the data mover in bootstrap mode but not able to login into the Application Designer using PS userid. I am sure that I have run all the scripts but don't know why I am not able to login into the Application Designer. Prior experiment with the MSSQL server 2000 is all successful but the problem is only with the Oracle 9i.

 

When I run the Application Designer trace I came to know that system is looking for PS.PSSTATUS instead of SYSTEM.PSSTATUS because PSSTATUS table exists in the SYSTEM tablespace not PS tablespace. I am out of choice now.

 

Can anybody help me in this issue and let me know how I can login into the Application Designer.

 

Thanks,

 

Manoj

---

Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!

SPONSORED LINKS

Peoplesoft software

Oracle dba

---

Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.

Have you granted access to connect id to the three PeopleTools tables by running grant.sql?

 

 

 

-- ******************************************************************
--
--   SourceSafe Information:
--
--   $Header:: /pt843/SCRIPTS/ORA/grant.sql 9     2/19/03 11: $
--
-- ******************************************************************

 

-- This script grants select privileges to the PeopleSoft Connect ID.
-- An Oracle DBA is required to run this script logged in as the PSOFT
-- Schema Owner(ie ACCESSID).
--
-- Before running this script, modify the following parameters
-- people
--

 

-- Grant select on Psoft Security Tables to Connect ID

 

grant select on PSSTATUS to people;
grant select on PSOPRDEFN to people;
grant select on PSACCESSPRFL to people;

 

commit;

 

 

 

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of Manoj Negi
Sent: 13 January 2006 10:24
To: psftdba@yahoogroups.com
Subject: [*SUSPECTED SPAM*] RE: PeopleSoft DBA Forum Unable to login into the Application Designer. Blocked - see http://www.spamcop.net/bl.shtml?66.94.237.35

Thanks Robert,

 

Let me rephrase what I did before starting the data mover script.

 

Step-1) I have created a service called HR88DEMO using the oradim utility (I want to create the database manually not through the DBCA). Create an initHR88DEMO.ora file and set all the parameters i.e CONTROL_FILES, UNDO_TABLEPSPACE, Block size and SGA, PGA memory parameters. Place this file into the ORACLE_HOME\database folder. Start the HR88DEMO service using the oradim utility.

 

Step-2) Open the command prompt and issued the following commands:

 

set oracle_sid=HR88DEMO

connect / as sysdba

startup database nomount pfile=ORACLE_HOME\database\initHR88DEMO.ora

create database HR88DEMO......

 

Step-3) After that I run the utlspace.sql -> ptddl.sql ->hcddl.sql -> rollback.sql (though I am using the UNDO tablespace but still I run this sql) -> create user PS ->

psadmin.sql -> psdbowner.sql -> connect.sql. I run this script as per installation guide instruction except createdb.sql. I create everything using SYSTEM as sysdba or without sysdba (where sysdba is not written).

 

Step-4) I create a database setup script and using the following settings.

 

Database:           HR88DEMO

Access ID:          SYSADMA

Symbolic ID:       PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Symbolic PWD:  PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Connect ID:        people

 

After running the data mover script, I am not able to login into the Application Designer.  You are right that I am confusing but only for schema not for the tablespace and user. I know what is user and tablespace but don't know what's meaning of schema and where it's used in PeopleSoft terminology. I also did installation in SQL Server and it's successful but with oracle this is second time and again it’s in failure stage... :-)

 

Let me know if you have any further suggestions.

 

Thanks,

 

Manoj

Robert Ellis <robert.ellis@...> wrote:

Quite a lot of potential mistakes here, not sure where to start…

 

You’ve obviously run at least some of the scripts as SYSTEM or alternatively run the scripts without having first created the PeopleSoft Tablespaces (hrddl.sql=.  PSSTATUS should be owned by the PeopleSoft owner you used in psadmin.sql – usually SYSADM.  Did you create the PeopleSoft connect user, usually PEOPLE?  The grant.sql script grants this user read access to SYSADM.PSSTATUS.  You also seem to be confusing schemas / users with tablespaces?  Have you imported the PeopleSoft database using datamover – you won’t be able to login in as PS until you have a database to login in to.

 

 If I were you I’d start with the install manual and follow it step by step.

 

 

Robert Ellis

PSE Data Security GmbH

http://www.psedatasecurity.com

---

From: Manoj Negi [mailto:negi2u@...]
Sent: 13 January 2006 10:37
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Unable to login into the Application Designer.

 

Dear All,

 

I am trying to create a demo database in oracle 9i but not able to login into the Application Designer.

 

I have manually created the HCM 8.8 database and run all the data mover scripts that exist in “scripts\nt” folder (as per the installation guide.). I also run the connect.sql to grant the necessary access to people connect id. I have also granted PSADMIN role to PS in order to connect to the database successfully.

 

I can logon into the data mover in bootstrap mode but not able to login into the Application Designer using PS userid. I am sure that I have run all the scripts but don't know why I am not able to login into the Application Designer. Prior experiment with the MSSQL server 2000 is all successful but the problem is only with the Oracle 9i.

 

When I run the Application Designer trace I came to know that system is looking for PS.PSSTATUS instead of SYSTEM.PSSTATUS because PSSTATUS table exists in the SYSTEM tablespace not PS tablespace. I am out of choice now.

 

Can anybody help me in this issue and let me know how I can login into the Application Designer.

 

Thanks,

 

Manoj

---

Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!

SPONSORED LINKS

Peoplesoft software

Oracle dba

---

Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of Manoj Negi
Sent: 13 January 2006 11:12
To: psftdba@yahoogroups.com
Subject: RE: PeopleSoft DBA Forum Unable to login into the Application Designer

Yes, I have run the grant.sql and also manually run all the three sql to ensure that it does not show give any error.

 

Don't know why it's looking for PS.PSSTATUS. Can you tell me why it's looking for PS.PSSTAUS. If I manually copy this table with data from SYSTEM user to PS user then will other user also able to login into the database i.e Can I able to boot my application server with PSADMIN?

 

Thanks,

 

Manoj

David Kurtz <info2@...> wrote:

Have you granted access to connect id to the three PeopleTools tables by running grant.sql?

 

 

 

-- ******************************************************************
--
--   SourceSafe Information:
--
--   $Header:: /pt843/SCRIPTS/ORA/grant.sql 9     2/19/03 11: $
--
-- ******************************************************************

 

-- This script grants select privileges to the PeopleSoft Connect ID.
-- An Oracle DBA is required to run this script logged in as the PSOFT
-- Schema Owner(ie ACCESSID).
--
-- Before running this script, modify the following parameters
-- people
--

 

-- Grant select on Psoft Security Tables to Connect ID

 

grant select on PSSTATUS to people;
grant select on PSOPRDEFN to people;
grant select on PSACCESSPRFL to people;

 

commit;

 

 

 

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of Manoj Negi
Sent: 13 January 2006 10:24
To: psftdba@yahoogroups.com
Subject: [*SUSPECTED SPAM*] RE: PeopleSoft DBA Forum Unable to login into the Application Designer. Blocked - see http://www.spamcop.net/bl.shtml?66.94.237.35

Thanks Robert,

 

Let me rephrase what I did before starting the data mover script.

 

Step-1) I have created a service called HR88DEMO using the oradim utility (I want to create the database manually not through the DBCA). Create an initHR88DEMO.ora file and set all the parameters i.e CONTROL_FILES, UNDO_TABLEPSPACE, Block size and SGA, PGA memory parameters. Place this file into the ORACLE_HOME\database folder. Start the HR88DEMO service using the oradim utility.

 

Step-2) Open the command prompt and issued the following commands:

 

set oracle_sid=HR88DEMO

connect / as sysdba

startup database nomount pfile=ORACLE_HOME\database\initHR88DEMO.ora

create database HR88DEMO......

 

Step-3) After that I run the utlspace.sql -> ptddl.sql ->hcddl.sql -> rollback.sql (though I am using the UNDO tablespace but still I run this sql) -> create user PS ->

psadmin.sql -> psdbowner.sql -> connect.sql. I run this script as per installation guide instruction except createdb.sql. I create everything using SYSTEM as sysdba or without sysdba (where sysdba is not written).

 

Step-4) I create a database setup script and using the following settings.

 

Database:           HR88DEMO

Access ID:          SYSADMA

Symbolic ID:       PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Symbolic PWD:  PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Connect ID:        people

 

After running the data mover script, I am not able to login into the Application Designer.  You are right that I am confusing but only for schema not for the tablespace and user. I know what is user and tablespace but don't know what's meaning of schema and where it's used in PeopleSoft terminology. I also did installation in SQL Server and it's successful but with oracle this is second time and again it’s in failure stage... :-)

 

Let me know if you have any further suggestions.

 

Thanks,

 

Manoj

Robert Ellis <robert.ellis@...> wrote:

Quite a lot of potential mistakes here, not sure where to start…

 

You’ve obviously run at least some of the scripts as SYSTEM or alternatively run the scripts without having first created the PeopleSoft Tablespaces (hrddl.sql=.  PSSTATUS should be owned by the PeopleSoft owner you used in psadmin.sql – usually SYSADM.  Did you create the PeopleSoft connect user, usually PEOPLE?  The grant.sql script grants this user read access to SYSADM.PSSTATUS.  You also seem to be confusing schemas / users with tablespaces?  Have you imported the PeopleSoft database using datamover – you won’t be able to login in as PS until you have a database to login in to.

 

 If I were you I’d start with the install manual and follow it step by step.

 

 

Robert Ellis

PSE Data Security GmbH

http://www.psedatasecurity.com

---

From: Manoj Negi [mailto:negi2u@...]
Sent: 13 January 2006 10:37
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Unable to login into the Application Designer.

 

Dear All,

 

I am trying to create a demo database in oracle 9i but not able to login into the Application Designer.

 

I have manually created the HCM 8.8 database and run all the data mover scripts that exist in “scripts\nt” folder (as per the installation guide.). I also run the connect.sql to grant the necessary access to people connect id. I have also granted PSADMIN role to PS in order to connect to the database successfully.

 

I can logon into the data mover in bootstrap mode but not able to login into the Application Designer using PS userid. I am sure that I have run all the scripts but don't know why I am not able to login into the Application Designer. Prior experiment with the MSSQL server 2000 is all successful but the problem is only with the Oracle 9i.

 

When I run the Application Designer trace I came to know that system is looking for PS.PSSTATUS instead of SYSTEM.PSSTATUS because PSSTATUS table exists in the SYSTEM tablespace not PS tablespace. I am out of choice now.

 

Can anybody help me in this issue and let me know how I can login into the Application Designer.

 

Thanks,

 

Manoj

---

Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!

SPONSORED LINKS

Peoplesoft software

Oracle dba

---

Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.

---

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

Enter your vote today!  A new poll has been created for the
psftdba group:

What webserver (serverlet container) do you use for PeopleTools 8.4x?  (Tick all
that apply).

   o Weblogic
   o Websphere
   o Tomcat
   o Oracle Application Server (Fusion Middleware)
   o Other


To vote, please visit the following web page:
http://groups.yahoo.com/group/psftdba/surveys?id=1875879

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!

What's in PS.PSDBOWNER?  This is where the database name is mapped to the OWNERID.

 

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of Manoj Negi
Sent: 13 January 2006 11:12
To: psftdba@yahoogroups.com
Subject: RE: PeopleSoft DBA Forum Unable to login into the Application Designer

Yes, I have run the grant.sql and also manually run all the three sql to ensure that it does not show give any error.

 

Don't know why it's looking for PS.PSSTATUS. Can you tell me why it's looking for PS.PSSTAUS. If I manually copy this table with data from SYSTEM user to PS user then will other user also able to login into the database i.e Can I able to boot my application server with PSADMIN?

 

Thanks,

 

Manoj

David Kurtz <info2@...> wrote:

Have you granted access to connect id to the three PeopleTools tables by running grant.sql?

 

 

 

-- ******************************************************************
--
--   SourceSafe Information:
--
--   $Header:: /pt843/SCRIPTS/ORA/grant.sql 9     2/19/03 11: $
--
-- ******************************************************************

 

-- This script grants select privileges to the PeopleSoft Connect ID.
-- An Oracle DBA is required to run this script logged in as the PSOFT
-- Schema Owner(ie ACCESSID).
--
-- Before running this script, modify the following parameters
-- people
--

 

-- Grant select on Psoft Security Tables to Connect ID

 

grant select on PSSTATUS to people;
grant select on PSOPRDEFN to people;
grant select on PSACCESSPRFL to people;

 

commit;

 

 

 

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of Manoj Negi
Sent: 13 January 2006 10:24
To: psftdba@yahoogroups.com
Subject: [*SUSPECTED SPAM*] RE: PeopleSoft DBA Forum Unable to login into the Application Designer. Blocked - see http://www.spamcop.net/bl.shtml?66.94.237.35

Thanks Robert,

 

Let me rephrase what I did before starting the data mover script.

 

Step-1) I have created a service called HR88DEMO using the oradim utility (I want to create the database manually not through the DBCA). Create an initHR88DEMO.ora file and set all the parameters i.e CONTROL_FILES, UNDO_TABLEPSPACE, Block size and SGA, PGA memory parameters. Place this file into the ORACLE_HOME\database folder. Start the HR88DEMO service using the oradim utility.

 

Step-2) Open the command prompt and issued the following commands:

 

set oracle_sid=HR88DEMO

connect / as sysdba

startup database nomount pfile=ORACLE_HOME\database\initHR88DEMO.ora

create database HR88DEMO......

 

Step-3) After that I run the utlspace.sql -> ptddl.sql ->hcddl.sql -> rollback.sql (though I am using the UNDO tablespace but still I run this sql) -> create user PS ->

psadmin.sql -> psdbowner.sql -> connect.sql. I run this script as per installation guide instruction except createdb.sql. I create everything using SYSTEM as sysdba or without sysdba (where sysdba is not written).

 

Step-4) I create a database setup script and using the following settings.

 

Database:           HR88DEMO

Access ID:          SYSADMA

Symbolic ID:       PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Symbolic PWD:  PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Connect ID:        people

 

After running the data mover script, I am not able to login into the Application Designer.  You are right that I am confusing but only for schema not for the tablespace and user. I know what is user and tablespace but don't know what's meaning of schema and where it's used in PeopleSoft terminology. I also did installation in SQL Server and it's successful but with oracle this is second time and again it’s in failure stage... :-)

 

Let me know if you have any further suggestions.

 

Thanks,

 

Manoj

Robert Ellis <robert.ellis@...> wrote:

Quite a lot of potential mistakes here, not sure where to start…

 

You’ve obviously run at least some of the scripts as SYSTEM or alternatively run the scripts without having first created the PeopleSoft Tablespaces (hrddl.sql=.  PSSTATUS should be owned by the PeopleSoft owner you used in psadmin.sql – usually SYSADM.  Did you create the PeopleSoft connect user, usually PEOPLE?  The grant.sql script grants this user read access to SYSADM.PSSTATUS.  You also seem to be confusing schemas / users with tablespaces?  Have you imported the PeopleSoft database using datamover – you won’t be able to login in as PS until you have a database to login in to.

 

 If I were you I’d start with the install manual and follow it step by step.

 

 

Robert Ellis

PSE Data Security GmbH

http://www.psedatasecurity.com

---

From: Manoj Negi [mailto:negi2u@...]
Sent: 13 January 2006 10:37
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Unable to login into the Application Designer.

 

Dear All,

 

I am trying to create a demo database in oracle 9i but not able to login into the Application Designer.

 

I have manually created the HCM 8.8 database and run all the data mover scripts that exist in “scripts\nt” folder (as per the installation guide.). I also run the connect.sql to grant the necessary access to people connect id. I have also granted PSADMIN role to PS in order to connect to the database successfully.

 

I can logon into the data mover in bootstrap mode but not able to login into the Application Designer using PS userid. I am sure that I have run all the scripts but don't know why I am not able to login into the Application Designer. Prior experiment with the MSSQL server 2000 is all successful but the problem is only with the Oracle 9i.

 

When I run the Application Designer trace I came to know that system is looking for PS.PSSTATUS instead of SYSTEM.PSSTATUS because PSSTATUS table exists in the SYSTEM tablespace not PS tablespace. I am out of choice now.

 

Can anybody help me in this issue and let me know how I can login into the Application Designer.

 

Thanks,

 

Manoj

---

Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!

SPONSORED LINKS

Peoplesoft software

Oracle dba

---

Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.

---

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

This is an excellent place to ask this question (see below).
So I have created a Poll on the forum which will run for 2 weeks.

I asked the same question back in 2003 when we had recently created this
forum and everyone used PT8.1x.
A very small sample produced the result: 75% weblogic, 25% apache.
I am intrigued to see what the answer is today!

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf
> Of shirley.mcgregor@...
> Sent: 28 December 2005 07:02
> To: psftdba@yahoogroups.com
> Subject: PeopleSoft DBA Forum Peoplesoft implementations with WebLogic
> or Websphere?
>
>
>
> I'm just curious and this is not really the place to ask.......however
>
> What percentage of forum participants use Weblogic in the PIA vs
> Websphere?
>
> In the reply please include client (numbers) and product.   eg.
> Peoplesoft
> Financials, 200 users, Weblogic.
>
> David K.  - I know you have many clients, do you know a rough overall
> percentage?
>
>
>
> Thanks and Happy New Year to all of the psftdba's out there!
>
> Shirley
>
> -----
>
>
>
>
> "The information contained in this email and any attached files
> ("Email") is strictly private and confidential.  This Email
> should be read by the intended recipient only.  If you are not
> the intended recipient of this Email or if you believe this is an
> unsolicited email, please immediately notify the sender by
> replying to this email or contact a representative from the Aon
> Group of Companies  ("Aon") on +61 2 9253 7000 and promptly
> destroy this Email and any copies of this Email.
>
> Only the intended recipient of this Email may use, reproduce,
> disclose or distribute the information contained in this Email
> with Aon's permission.  If you are not the intended recipient,
> you are strictly prohibited from using, reproducing, disclosing
> or distributing the information contained in this Email.
>
> Aon does not represent, warrant or guarantee that the integrity
> of this Email has been maintained or that the communication is
> free of errors, virus or interference. Aon advises that this
> Email should be scanned to detect viruses.  Aon accepts no
> liability for loss or damage (whether caused by negligence or
> not) resulting from the use of this Email.
>
> Unless the sender is expressly providing you with personal
> advice, any advice contained in this Email has been prepared
> without taking into account your objectives, financial situation
> or needs. Before acting on any advice in this Email, you should
> consider whether that advice is appropriate for your personal
> circumstances. If this Email contains reference to any specific
> financial product(s), Aon recommends you consider the relevant
> product disclosure statement or other disclosure document(s)
> before making any decision regarding that product."
>
>
>
>
> PeopleSoft for the Oracle DBA is published by Apress - see
http://www.psftdba.com.
The PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk.

Yahoo! Groups Links

Don’t do that, this table should be owned by SYSADMA so create it in that schema instead.

 

Can you post the contents of the following tables then you’ll get better advice:

 

PSDBOWNER

PSSTATUS

PSACCESSPRFL

PSOPRDEFN (just for OPRID=’PS’)

 

 

Robert Ellis

PSE Data Security GmbH

http://www.psedatasecurity.com

---

From: Manoj Negi [mailto:negi2u@...]
Sent: 13 January 2006 12:12
To: psftdba@yahoogroups.com
Subject: RE: PeopleSoft DBA Forum Unable to login into the Application Designer

 

Yes, I have run the grant.sql and also manually run all the three sql to ensure that it does not show give any error.

 

Don't know why it's looking for PS.PSSTATUS. Can you tell me why it's looking for PS.PSSTAUS. If I manually copy this table with data from SYSTEM user to PS user then will other user also able to login into the database i.e Can I able to boot my application server with PSADMIN?

 

Thanks,

 

Manoj

David Kurtz <info2@...> wrote:

Have you granted access to connect id to the three PeopleTools tables by running grant.sql?

 

 

 

-- ******************************************************************
--
--   SourceSafe Information:
--
--   $Header:: /pt843/SCRIPTS/ORA/grant.sql 9     2/19/03 11: $
--
-- ******************************************************************

 

-- This script grants select privileges to the PeopleSoft Connect ID.
-- An Oracle DBA is required to run this script logged in as the PSOFT
-- Schema Owner(ie ACCESSID).
--
-- Before running this script, modify the following parameters
-- people
--

 

-- Grant select on Psoft Security Tables to Connect ID

 

grant select on PSSTATUS to people;
grant select on PSOPRDEFN to people;
grant select on PSACCESSPRFL to people;

 

commit;

 

 

 

regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@...
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of Manoj Negi
Sent: 13 January 2006 10:24
To: psftdba@yahoogroups.com
Subject: [*SUSPECTED SPAM*] RE: PeopleSoft DBA Forum Unable to login into the Application Designer. Blocked - see http://www.spamcop.net/bl.shtml?66.94.237.35

Thanks Robert,

 

Let me rephrase what I did before starting the data mover script.

 

Step-1) I have created a service called HR88DEMO using the oradim utility (I want to create the database manually not through the DBCA). Create an initHR88DEMO.ora file and set all the parameters i.e CONTROL_FILES, UNDO_TABLEPSPACE, Block size and SGA, PGA memory parameters. Place this file into the ORACLE_HOME\database folder. Start the HR88DEMO service using the oradim utility.

 

Step-2) Open the command prompt and issued the following commands:

 

set oracle_sid=HR88DEMO

connect / as sysdba

startup database nomount pfile=ORACLE_HOME\database\initHR88DEMO.ora

create database HR88DEMO......

 

Step-3) After that I run the utlspace.sql -> ptddl.sql ->hcddl.sql -> rollback.sql (though I am using the UNDO tablespace but still I run this sql) -> create user PS ->

psadmin.sql -> psdbowner.sql -> connect.sql. I run this script as per installation guide instruction except createdb.sql. I create everything using SYSTEM as sysdba or without sysdba (where sysdba is not written).

 

Step-4) I create a database setup script and using the following settings.

 

Database:           HR88DEMO

Access ID:          SYSADMA

Symbolic ID:       PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Symbolic PWD:  PS  (in another database i.e i am running two installation simultanously i used the SYSADMA)

Connect ID:        people

 

After running the data mover script, I am not able to login into the Application Designer.  You are right that I am confusing but only for schema not for the tablespace and user. I know what is user and tablespace but don't know what's meaning of schema and where it's used in PeopleSoft terminology. I also did installation in SQL Server and it's successful but with oracle this is second time and again it’s in failure stage... :-)

 

Let me know if you have any further suggestions.

 

Thanks,

 

Manoj

Robert Ellis <robert.ellis@...> wrote:

Quite a lot of potential mistakes here, not sure where to start…

 

You’ve obviously run at least some of the scripts as SYSTEM or alternatively run the scripts without having first created the PeopleSoft Tablespaces (hrddl.sql=.  PSSTATUS should be owned by the PeopleSoft owner you used in psadmin.sql – usually SYSADM.  Did you create the PeopleSoft connect user, usually PEOPLE?  The grant.sql script grants this user read access to SYSADM.PSSTATUS.  You also seem to be confusing schemas / users with tablespaces?  Have you imported the PeopleSoft database using datamover – you won’t be able to login in as PS until you have a database to login in to.

 

 If I were you I’d start with the install manual and follow it step by step.

 

 

Robert Ellis

PSE Data Security GmbH

http://www.psedatasecurity.com

---

From: Manoj Negi [mailto:negi2u@...]
Sent: 13 January 2006 10:37
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Unable to login into the Application Designer.

 

Dear All,

 

I am trying to create a demo database in oracle 9i but not able to login into the Application Designer.

 

I have manually created the HCM 8.8 database and run all the data mover scripts that exist in “scripts\nt” folder (as per the installation guide.). I also run the connect.sql to grant the necessary access to people connect id. I have also granted PSADMIN role to PS in order to connect to the database successfully.

 

I can logon into the data mover in bootstrap mode but not able to login into the Application Designer using PS userid. I am sure that I have run all the scripts but don't know why I am not able to login into the Application Designer. Prior experiment with the MSSQL server 2000 is all successful but the problem is only with the Oracle 9i.

 

When I run the Application Designer trace I came to know that system is looking for PS.PSSTATUS instead of SYSTEM.PSSTATUS because PSSTATUS table exists in the SYSTEM tablespace not PS tablespace. I am out of choice now.

 

Can anybody help me in this issue and let me know how I can login into the Application Designer.

 

Thanks,

 

Manoj

---

Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!

SPONSORED LINKS

Peoplesoft software

Oracle dba

 

---

Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.

 

---

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.