Skip to Content
avatar image
Former Member

TNS error

When I trying to start sap getting following problem ..

TNS-12535: TNS:operation timed out

V2 connect is not available. Terminating

/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 14

Listner is taking time to start but starting successfully.

Thanks and Regards,

Kalyan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 21, 2009 at 10:38 AM

    Hello Kalyan,

    which database version?

    Normally you receive a TNS-12535, if your network is too slow or you have a firewall between your database and application servers. Please post the output of the following files and commands:

    shell> tnsping PRD
    shell> cat $ORACLE_HOME/network/admin/listener.ora
    shell> cat $ORACLE_HOME/network/admin/sqlnet.ora
    

    How many application servers (with the amount of WPs) are starting in parallel and trying to connect to the database?

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Kalyan,

      give Log file: /home/prdadm/startdb.log

      Check your database in mount stat or Open stat u can check through sql prompt

      select open_mode from v$database;

      is it READ WRITE or Mount ???

      Surendra Jain