Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unanswered: Problem in login from client

    Hello Oracle DBAs,
    I've created 4 databases(say A,B,C,D) on 4 diskpartitions(say /d1,/d2,/d3,/d4) on single ORACLE_HOME(/d1) on Linux AS 2.3.

    All the 4 databases are up and running from the local machine(i.e. server).
    But when I try to login from the client machine 3 out of 4 DBs gives me the following error.

    ORA-01034 : ORACLE not available.
    ORA-27123 : unable to attach to shared memory segment.
    Linux Error : 13 : Permission denied.

    The one DB from which partition I start the listener(Using LSNRCTL) ,is getting connected properly(either A or B or C or D).

    Other 3 databases giving me the above error stmt.

    tnsnames.ora configuration is fine.
    I checked and set the shmmax,shmall to max(2gb) and shared_pool_size to min.(small).
    when I start all 4 DBs from server, lsnrctl>status show the status ready....etc.,without errors.

    How do I login from the client machine.?
    Do I have to add ports to listerner.ora file..!
    Please help me in resolving the problem
    Thanking you.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Post your listerner.ora (server) and tnsnames.ora (client) files
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •