Run installer error while doing homogenous system copy

[Former Member]

Hello All,

I am doing Homogenous system copy on AIX with oracle 11g.

In the phase of oracle db software installtion .

I have installed the the same what mentioned going to stage.../SAP directory.

There are 2 folders are created 11203 and 112_64.

After doing this If I continue still getting the same error message.

It seems oracle db software not installed .. but in folders /oracle/<SID>11203 all the files are created.

Kindly suggest is any thing need to do further.

Thanks

Sri

[madasamy_arunachalam]

Hi

Sometime SWPM/SAPInst tool doesn't know the newly installed database software or its location.

To resolve this,

1)  just come out of SWPM/SAPInst. tool, means just exit it.

2) From the same telnet session,  set  below env. variables for the newly installed DB/software

export DB_SID=SID 
export ORACLE_SID=SID
export ORACLE_HOME=OracleHomeDirectory

3) then, Re-Start SWPM/SAPInst tool

Now, SWPM/SAPInst able to recognize the db and its software location, so installation tool can be continued from its earlier phase..

regards

Swami

[Mofizur]

Hi Sri,

Below notes can give you some directions..

1524205 - Oracle 11.2.0: Database Software Installation

1778431 - SAP Installations using Shared Oracle Homes

Thanks,

Mofizur

[former_member182657]

Hi Sri,

Could you share tnsnames.ora file or try to check the correct host name / IP address of the server in it.Additionally maintain the host entries as like

127.0.0.1  localhost.localdomain  localhost
<Server IP Address >  <Host Name>

Please confirm.

Regards,

[Former Member]

Hi Rana,

Please find below , hostname is already there in HOST

# Filename......: tnsnames.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/TNSNAMES.ORA#1 $

################

PRD.WORLD=

  (DESCRIPTION =

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = <hostname>)

          (PORT = 1527)

        )

    )

    (CONNECT_DATA =

       (SID = PRD)

       (GLOBAL_NAME = PRD.WORLD)

    )

  )

[Former Member]

Hostname is also maintained in /etc/hosts

[Former Member]

Hi Sri,

Have you tried to set up oracle_HOME with /oracle/PRD/11203 your oracle version.

and LD_LIBRARY path with /usr/sap/PRD/DVBM*/SYS/exe:/oracle/PRD/11203/

And re-tried sapinst/SWPM.

Regards,

Ram

[former_member182657]

Hi,

Not able to access the file shared by you,kindly provide the access to fetch the same or attach it with your thread.

Regards,

[Former Member]

Hi All,

Sorry for the delay..

Listener is not running.

We have installed Database successfully.

Also please find the output, it seems all are set properly.

Please let us know how to start the listener.

Thanks

Sri

[Former Member]

Hi ,

When I ping the 1527

oraprd> ping <hostname>  1527 below is the result

telnet <hostname> 1527

Trying...

telnet: connect: A remote host refused an attempted connect operation.

Thanks

Sri

[Brindavan_M]

Hi ,

If listener is not running  then you need to start and then try..

[Former Member]

Hi

Thanks for the response

1. As mentioned by brindavan i have changed the  oracle filsystem owner"112_64"  from root to oraSID :dba

even the installation is unable to proceed, the issue is still same. could  you please suggest me what should  i better to check further steps

2.as mentioned by  james here am enclosed the link of sapinst_dev.log, kindly check the log Please guide me how to proceed further.

https://drive.google.com/open?id=0Bzf2lXnFaKOlZGZKTFNPNzdDNG8

Thanks sri

[JamesZ]

Hi Sri,

Can you attach sapisnt_dev.log? I do not have google email id.

Best regards,
James

[Brindavan_M]

Hi ,

Cross check once again all the oracle file in directories 11203 inside, all the files should be ora<SID>:dba. check the listener running or not. check the oracle is not idle.

. check the "/oracle/SID/oraInventory ".

let me know the result for the below commands

ORASID> echo $ ORACLE_HOME

ORASID> echo $ ORACLE_BASE

ORASID> echo $ ORACLE_SID

Thanks,

[Former Member]

Hi ,

Below are the details.

1. softlink is created , sending screen shot kindly validate it.

2. Able to login as /sqlplus nolog

3. Attaching sapinst dev log file.

Please guide me how to proceed further.

Thanks

Sri

[JamesZ]

Hi Sri,

You have to attach complete sapinst_dev.log, because I need to how sapinst get oracle_home, how the oracle_home environment variable was set in sapinst session.

Best regards,
James

[Brindavan_M]

Hi Sri,

I am able to see that the  oracle filsystem owner"112_64"  is roor? change the ownership of the file oraSID :dba than try to execute.  Let me know the same.

Thanks,

BM

[Former Member]

Hello Sri,

Do check as mentioned by brindavan for the permission. also can you please update us with below environment variables.

ORACLE_HOME & ORACLE_BASE.

Do check those. also you can try to set the oracle_home to /oracle/PRD/112_64 or /oracle/PRD/11203.

And try to re-run the installer again.

also hope your running installed with prdadm and all the environment variables are set correctly.

Do verify your LD_LIBRARY path and oracle environments(oracle_HOME, TNSADMIN).

Do let us know the status.

regards,

Ram

[Brindavan_M]

Hello Sri,

Are you getting this error while doing import ? 11203 is the soft-link for 112_64.  if oracle database is install than try to login the oracle is working or not. kindly give more details on this issue.

Thanks,

BM

[former_member182657]

Hi Sri,

Could you share sapinst_dev.log file to support you for the issue.In addition could you share result for command

sqlplus /nolog

Regards,

[JamesZ]

Hi Sri,

Please check the environment variables of user sidadm. Also please attach sapinst_dev.log to this discussion.

best regards,
James