"no start profiles found" error

[Former Member]

Hi All,

I am using EP6.DB is oracle 9. OS is AIX 5.3

AIX team was trying to upgrade OS level to AIX 5.7.

It got some problem and we had restored it back to 5.3 through "mksysb" backup.

So the OS level is same as before.

But when i am trying to start sap. it is not starting.

I am able to start listener and saposcol.

But when i do startsap it gives me error "no start profiles found"

I am doing su - <SID>adm and profiles are also there in /sapmnt/<EPP>/profiles.

Their permissions are also ok.

All the filesystems have been mounted too.

I cant find where the problem is.

I would appreciate any help in this.

Thanks

Tajinder.

[stefan_koehler · Accepted solution]

Hello Tajinder,

as you already said that the mksysb was restored... have the /usr/sap directory also be restored? (maybe it was excluded by the mksysb).

The profiles are "soft linked" into the /usr/sap directory.

For example the profile directory is linked under /usr/sap/<SID>/SYS

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

Yes that has also been restored.

/usr/sap/<SID>/SYS/profile is linked to /sapmnt/<SID>/profile

These both are there.

DB is starting manually and configtool is also getting started.

Kindly suggest any solutions.

I would appreciate any help

Thanks

Tajinder.

[stefan_koehler · Accepted solution]

Hello,

>> DB is starting manually and configtool is also getting started.

ok.. this information was missed by the inital post.

Please post the following output:

> shell> hostname

> shell> uname -n

> shell> lsattr -EH -l inet0

Maybe the hostname has changed (to full qualified for example).

Regards

Stefan

[Former Member · Accepted solution]

Hi stefan,

Yes hostname got wrong.

we corrected taht and it is up now.

Thanks for your help.

I m happ y to award you points.

Thanks

Tajinder

[Former Member · Accepted solution]

Please tell me of where did u change the host name

[Former Member · Accepted solution]

Hi,

As i am using AIX here. So i changed hostname through "smitty" application. I changed the OS hostname.

Actually in /etc/hosts, all the entries were there for the diff. hostnames.

But when i did startsap "hostname".... that particular hostname. it started.

As we have 3 diff. entries for hostnames in /etc/hosts

But for SAP EP it was one of them. And whe i used it with startsap., it worked. So i changed hostname through smitty.

And the i need not to write hostname with startsap

Thanks

Tajinder

[Former Member · Accepted solution]

Hi Stefan,

Really thanks for ur help,

My Backup team changed the global host name,

Even after changing the name in hostentries i could not solve the problem, But when

I changed the hostname via smitty tool, Ur post helpled for a lot

Thanks

Harikrishna

[Former Member]

In the <SID>adm home directory create two files hostname and hostname_default with following values and after that try which should work

vi hostname

#!/bin/bash

if [ ! -z "$VHOSTNAME" ]

then echo $VHOSTNAME

else ~/hostname_default

fi

vi hostname_default

echo <hostname>

create the two files and then SAVE them and try which will really help me too.