Oracle 10.2.0.2 with Solution Manager 4

[Former Member]

Hi,

I have finished installing solution manager 4 on kernel 7 with Oracle 10.2.0.2.0 (central instance). All the environment variables have been set as per notes 602843 and 830578. The problem is that i think the listener is listening on a different port whereas when i start sap it seems to be trying to get to the listener on a different port which is not registered in the services file under UNIX. There are the listener.ora and tnsnames.ora files which i had a look at but anyone know which file the startsap refers to, to get the port number for the listener, as it seems its not refering to the services file in UNIX nor the ora files mentioned above?

thanks

Mani

[markus_doehr2 · Accepted solution]

> I have finished installing solution manager 4 on kernel 7 with Oracle 10.2.0.2.0 (central instance). All the environment variables have been set as per notes 602843 and 830578.

Usually all that is done automatically by sapinst. How did you set up the instance? Manually?

Markus

[fidel_vales]

Hi,

SAP (ABAP) looks for the tnsnames.ora

Where, it depends on the OS and environment variables

Note 562403 point 5 has an explanation:

 5.  Where can I find the Oracle Net configuration files?                                                                                
The configuration files are found in the following sequence:                                                                                
a) The path that is specified in the environment variable TNS_ADMIN  
        (R/3 3.1I or lower: TNS_ADMIN = /usr/sap/trans; R/3 4.0B or       
        higher: TNS_ADMIN is no longer set; as of Oracle 10g:  TNS_ADMIN  
        on application servers on the TNS files path)                                                                                
b) The directory /etc and in individual cases /var/opt/oracle (UNIX  
        only)                                                                                
c) The directory $ORACLE_HOME/network/admin                          

[Former Member]

Hi,

We have overcome this problem now but I have been used to using an old version of SAP and at the moment i think the ops$ users need to be initialized and have passwords setup for them. I used to use chdbpass to do this but it seems there isn't a program like this in nw2004s. i found out on oss note 562863 that brconnect could be used to consistently change passwords so can this be used to change the ops$ users or is there a newer version of chdbpass?

thanks

Mani

[fidel_vales]

Hi,

there is no newer tool.

Note 361641 has the steps to follow in order to create OPS$ and change the passwords

SAP BASIS >= Release 6.10:                                                                                
Use the oradbusr.sql script. This script is attached to the note 50088.  
The script is valid for Oracle and Unix. Use the following syntax                                                                                
sqlplus /NOLOG @oradbusr.sql SCHEMAOWNER UNIX SAP_SID x                                                                                
The SCHEMAOWNER is either SAPR3 or has to start with SAP followed by the 
three digit schema id (example: SAPPRD).                                 
On Unix x is a dummy parameter and may e. g. be set to  X.                                                                                
To change the password for the SAPR3 or SAP<SID> user you have to use    
the following command:                                                                                
brconnect -u system/<syst_pwd> -f chpass -o SAPR3 -p <new_sap_pwd>                                                     
or                                                                                
brconnect -u system/<syst_pwd> -f chpass -o sap<sid> -p
       <new_sap_pwd>