listener port in AS java usage type

[Former Member]

Hi all,

I have two questions.

How to check the ports used in AS java usage type.Database is oracle.with which port does it get connected to java database.The problem we are facing is that we are not able to connect to database.Is the port maintained at SAP level.One more question is that does the schema user id SAPSR3DB get locked.If yes how do we unlock it.Thanks in advance.

[former_member227283 · Accepted solution]

Hi,

How to check the ports used in AS java usage type.Database is oracle.with which port does it get connected to java database

1. Start Config tool

2. connect to database

3. there will option called as SECURE STORE click on that

4. the will be parameter starting from

jdbc:oracle:thin@.....

which contain listner port , change the same as per you scenario.

One more question is that does the schema user id SAPSR3DB get locked.

yes , it mey get lock.

goto to sqlplus and run follosing command

alter user SAPSR3DB account unlock;

Thanks

Anil

[Former Member]

Hi Ambarish,

See if this doc can help you, check out under RDBMS section in this doc.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/4e515a43-0e01-0010-2da1-9bcc452c280b&override...

Also to unlock the user try from sqlplus

Alter user < > account unlock

Regards,

Sumit