Strict Standards: Declaration of BB_Walker_Blank::start_lvl() should be compatible with BB_Walker::start_lvl($output) in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/classes.php on line 1127

Strict Standards: Declaration of BB_Walker_Blank::end_lvl() should be compatible with BB_Walker::end_lvl($output) in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/classes.php on line 1127

Strict Standards: Declaration of BB_Walker_Blank::start_el() should be compatible with BB_Walker::start_el($output) in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/classes.php on line 1127

Strict Standards: Declaration of BB_Walker_Blank::end_el() should be compatible with BB_Walker::end_el($output) in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/classes.php on line 1127

Strict Standards: Redefining already defined constructor for class bbdb in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/db-mysql.php on line 12
Oracle 11g does not work « Support Forums

Support Forums » Issues

Oracle 11g does not work

(5 posts)
  • Started 10 years ago by gpolillo
  • Latest reply from richard
  1. gpolillo
    Member

    I am trying to connect in oracle 11g, but I failed.
    it was modified @oci_connect($u, $p, "{$h}/XE") TO @oci_connect($u,$p,"{$h}/dbname"), but the result is: (xml):

    <?xml version="1.0" encoding="utf-8" standalone="yes" ?>
    <response>
    <version>0.1.4</version>
    <authentication>failed</authentication>
    <authorization>succeeded</authorization>
    <request_action>select</request_action>
    <request_mode>get_norm</request_mode>
    <qid></qid>
    <query></query>
    <target_table></target_table>
    <target_id>0</target_id>
    <affected_id>0</affected_id>
    <affected_rows>0</affected_rows>
    <found_rows>0</found_rows>
    <insert_id>0</insert_id>
    <insert_offset>0</insert_offset>
    <offset>0</offset>
    <limit>0</limit>
    <rows>0</rows>
    <cols>0</cols>
    <firstpage>1</firstpage>
    <lastpage>1</lastpage>
    <debug_msg>
    $_POST
    Array
    (
    [_request_action_] => select
    [_request_mode_] => get_norm
    [_request_pid_] => login
    [_request_objective_] =>
    [_request_guidance_] =>
    [_request_limit_offset_] => 0
    [_request_show_response_] => true
    [_login_username_] => system
    [_login_password_] => *******
    [_request_qid_] =>
    [_request_appid_] => synapp2
    )
    </debug_msg>
    <debug_msg>db_connect('localhost', 'system') - attempt failed</debug_msg>
    </response>

    By simple connect script, I get to access my oracle 11g and other remote oracle 11g and 10g!, but by synapp2, I dont.

    sorry by my english, I am Brazilian.
    Thanks.

    Posted 10 years ago #

  2. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard

    Administrator

    olá É agradável encontrar a ti.

    Your English is a lot better than my Portuguese. I hope I said - Hello. It is nice to meet you.

    I think we need to discover the SERVICE_NAME for the instance of Oracle that you're running.

    Here's a link that discusses naming methods:

    http://download.oracle.com/docs/cd/B28359_01/network.111/b28316/naming.htm

    Assuming you're on a Linux system, use the locate or find command to find the file: tnsnames.ora. Try the command: locate tnsnames.ora

    That should show you where the file is.

    If you would, please post the file to the forum for reference.

    The service name should be listed. Use the service name in place of "dbname", in the oci_connect statement.

    Here is what my file looks like.

    # tnsnames.ora Network Configuration File:
    
    XE =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.localdomain)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = XE)
        )
      )
    
    EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
        )
        (CONNECT_DATA =
          (SID = PLSExtProc)
          (PRESENTATION = RO)
        )
      )
    Posted 10 years ago #

  3. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard

    Administrator

    The service name should also appear in the listener.ora file.

    Locate listener.ora and look for the line: DEFAULT_SERVICE_LISTENER = (XX)

    Use the XX value in place of XE in the oci_connect() statement.

    Posted 10 years ago #

  4. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard

    Administrator

    Login to the schema/database you want to generate an application for. The system user is a special case user and is not normally used as a login to SynApp2.

    Posted 10 years ago #

  5. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard


    Administrator

    Moved post from General Discussion to Issues.

    Posted 9 years ago #

RSS feed for this topic

Reply

You must log in to post.