AutoSys Workload Automation

  • Private Community
Back to discussions
Expand all | Collapse all

Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

  • 1.  Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Posted Aug 07, 2018 11:22 AM

     Database Tests 
    Warnings or errors occurred during the database connection test. Make sure that the database is active and that the connection information is specified correctly.
    Click Back to specify different connection information. Click Cancel to cancel the setup program.
    ─────────────────
     The specified database port is not valid. Specify another port.

     

    We have sourced oracle environment variables.

    We have the required permissions on the user from which we are trying to install.

    We have checked the connectivity from client to database using sqlplus and it is working fine.

    tnsnames.ora and tnsping command everything is in place and working fine

    Operating system : Linux t01lap00615 3.12.74-60.64.96-default #1 SMP Thu Jun 14 16:47:00 UTC 2018 (a8fda5a) x86_64 x86_64 x86_64 GNU/Linux , Distribution : SUSE

    Database version : 12.1.0.2.0 (Oracle)



  • 2.  Re: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Broadcom Employee
    Posted Aug 07, 2018 11:33 AM

    Hi Sunish,

     

    The encountered problem could be related to your "tnsnames.ora" file format.

     

    The formatting of this file is very important.

    • Use Oracle Net Manager to make any updates to tnsnames.ora (Recommended)
    • Each sub-line requires a two-space indention
    • The Alias should NOT have any periods
    • If an “Internal Exception: IO Error: could not resolve” message is seen, there is a likely formatting issue and the JDBC driver is not able to connect to the database.

    Example: tnsnames.ora

    $TNS_ADMIN/tnsnames.ora

    HA1136 =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = win-db2)(PORT = 1521))

        (CONNECT_DATA =

          (SERVER = DEDICATED)

          (SERVICE_NAME = HA1136)

        )

      )

     

    I hope this can help.

     

    Thanks,

    Roya



  • 3.  Re: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Broadcom Employee
    Posted Aug 07, 2018 11:37 AM

    Hi Sunish,

     

    You can consult the following KB000042154 KB document for more information:

     

    https://comm.support.ca.com/kb/how-autosys-configures-the-oracle-database-connection-properties/kb000042154 

     

    Thanks,

    Roya



  • 4.  Re: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Posted Aug 07, 2018 08:45 PM

    Hi Sunish,

     

    The WAAE instaler executes the following sqlplus command to verify the DB connectivity.

     

    sqlplus user/password@ServerName:PortNumber/ServiceName as SYSDBA


    For example:
    sqlplus sys/autosys@test-205309:1521/ORCL as SYSDBA

     

    If it is not successful then it prints error:  The specified database port is not valid. Specify another port.

     

    Try the aforementioned sqlplus syntax and see if it comes back successful. A couple more things to try:

    1) Ensure the sqlplus the installer uses is the same as you try in case there are multiple version of Oracle clients installed.

    2) If the password has special characters such as $,!,@,#, etc., then try with a simple password.

    3) I found this article related to sqlplus on SuSE 12, it may be relevant.

     

    Thanks,

    Chandru

     

     



  • 5.  Re: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Posted Aug 11, 2018 09:58 PM

    Sunish, Do you still need assistance on this? Share the resolution if it's already addressed so others in the community may benefit. Thanks!



  • 6.  Re: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation
    Best Answer

    Posted Aug 13, 2018 06:36 AM

    Hi Chandru,

     

    With the help of CA support executive (Murali, Venkat) we are able to address & resolve the issue.

    Issue is autosys related ID doesnt have sufficient DBA access,

     

    so we bypass the DB check from the installer. & then manually run the CreateAEDB.pl script 



  • 7.  Re: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Posted Aug 24, 2018 09:15 AM

    Sunish,

    I get the same problem for another customer. How do you bypass the DB check from the installer?

    Thanks



  • 8.  RE: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Posted Jul 12, 2019 11:14 AM

    Hi Sunish,

    Do you know how to resolve this issue ? I'm able to connect with sqlplus as chandru suggested. I'm installing scheduler R11.3.6 sp8  on linux 7.6, DB 18c RAC.

    │ Database Tests │
    └───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

    Warnings or errors occurred during the database connection test. Make sure that the database is active and that the connection information is specified correctly. Click Back to specify
    different connection information. Click Cancel to cancel the setup program.
    ┌───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
    │ The specified database port is not valid. Specify another port.
    Original Message


  • 9.  RE: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Broadcom Employee
    Posted Jul 14, 2019 11:55 PM
    Hi Karthik,

    These are some of the places you could go wrong.

    1. Oracle 32 bit client needs to be installed and set in the LD_LIBRARY_PATH and PATH variables
    2. TNS_ADMIN path needs to contain tnsnames.ora  file. Verify the autosys user has permission to read the tnsnames.ora file.
    3.  verify if firewall is active on the scheduler machine. Stop the frewalld service and try the install again.



    Original Message


  • 10.  RE: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Posted Jul 24, 2020 06:41 PM
    Hi,


    Even i am facing the same issue for installing AE 11.3.6 SP8 on linux machine
    manually sqplus connectivity and port is good but installer is giving error  to check the port.

    #below is working fine
    sqlplus SYS/sys@10.43.61.41:1531/autosydb as SYSDBA
    ​

    Regards,
    Rajani
    Original Message


  • 11.  RE: Error :The specified database port is not valid during autosys r11.3.6 sp7 installation

    Posted Jul 27, 2020 09:14 AM

    Check the tnsnames.ora file and ensure that the connection details provided is all correct.

     

    Ensure oracle 32 bit client is installed on the server.

    Ensure that the TNS_ADMIN and Oracle home directory is correct.

     

    Regards,

    Sandeep Veetil

     




    Original Message