1 2 Previous Next 28 Replies Latest reply: Nov 11, 2009 2:55 PM by 728539 Go to original post RSS
      • 15. Re: Unable to create new connection
        728539
        Am very sorry....but could you please tell me how to do that?

        thank you!
        • 16. Re: Unable to create new connection
          728539
          i did what you just told me...
          and now ive got another ERROR!!!!

          no more data to read from socket


          Is that difficult to create a new connection OR am I doing something wrong?
          • 17. Re: Unable to create new connection
            sb92075
            and now ive got another ERROR!!!!
            It would help us greatly if you shared EXACTLY what the error actually is.

            Did this ever work?

            If so, what changed?
            • 18. Re: Unable to create new connection
              728539
              no!!!
              this is my very first time am getting involved with oracle sql developer...

              i had a llok on the listener.ora file and find out that the SID is :PLSExtProc and so i changed it!

              Connection Name: PLSExtProc_test
              Username: test
              Password: test

              HostName: localhost
              Port: 1521
              SID: PLSExtProc


              am i doing something wrong? OR is that difficult to establish a connection?
              • 19. Re: Unable to create new connection
                728539
                am just keep trying for hour to sort it out and now have the error:

                io exception: Got minus one from read call

                help me please!!!
                • 20. Re: Unable to create new connection
                  Robert Geier
                  Your database instance is ORCL1, not PLSExtProc_test. There is no way to connect to PLSExtProc_test.

                  You can check your sqlnet listener by running "lsnrctl status" to find out if the listener is servicing the database.

                  You seem to have an Oracle 9i listener, and an Oracle 11g listener configured. Are you sure the right one is running ?

                  OracleOraDb11g_home1TNSListener
                  OracleOraHome9TNSListener
                  • 21. Re: Unable to create new connection
                    728539
                    i re-install the 11g and into the admin tool appears the following services:

                    Oracle OLAP 9.0.1.0.1

                    Oracle OLAP Agent

                    OracleDBConsoleorcl

                    OracleDBConsoleorcl1


                    OracleMTSRecoveryService



                    OracleOraDb11g_home1ClrAgent (Started)


                    OracleOraDb11g_home1CMAdmin

                    OracleOraDb11g_home1CMAN


                    OracleOraHome9Agent

                    OracleOraHome9ClientCache

                    OracleOraHome9CMAdmin

                    OracleOraHome9Man

                    OracleOraHome9HTTPServer

                    OracleOraHome9PagingServer

                    OracleOraHome9SNMPPeerEncapulator

                    OracleOraHome9SNMPPeerMasterAgent

                    OracleOraHome9TNSListener


                    Only OracleOraDb11g_home1ClrAgent is Started.
                    cannot really understand what am doing wrong!
                    please help me!!!!
                    • 22. Re: Unable to create new connection
                      728539
                      also, when i run the "lsnrctl status" :

                      TNS-12541: TNS: no listener
                      TNS-12560: TNS: protoclo adapter error
                      TNS-00511: No Listenet
                      32-bit window error: 61: unknow error

                      any clues?
                      • 23. Re: Unable to create new connection
                        728539
                        Ok... after a few tries i managed to

                        make OracleOraDb11g_home1ClrAgent is Started and OracleOraDb11g_home1TNSListenet started.
                        however when i try new connection, error appears saying connection reset!!!

                        pleasssseee help!!!!!
                        • 24. Re: Unable to create new connection
                          728539
                          guys could you please just tell me what to check?
                          am very frustrated with oracle and i have an assignment to complete
                          plsss HELP!!!!
                          • 25. Re: Unable to create new connection
                            sb92075
                            lsnrctl start
                            • 26. Re: Unable to create new connection
                              728539
                              i have already set this command...and the listener starts!
                              what is next?
                              • 27. Re: Unable to create new connection
                                728539
                                tnsnames.ora file
                                -----
                                <alias>= [ (DESCRIPTION_LIST =  # Optional depending on whether u have
                                                    # one or more descriptions
                                                    # If there is just one description, unnecessary ]
                                     (DESCRIPTION=
                                     [ (SDU=2048) ]     # Optional, defaults to 2048
                                                    # Can take values between 512 and 32K
                                     [ (ADDRESS_LIST=    # Optional depending on whether u have
                                                    # one or more addresses
                                                    # If there is just one address, unnecessary ]
                                     (ADDRESS=
                                          [ (COMMUNITY=<community_name>) ]
                                          (PROTOCOL=tcp)
                                          (HOST=<hostname>)
                                          (PORT=<portnumber (1521 is a standard port used)>)
                                     )
                                     [ (ADDRESS=
                                          (PROTOCOL=ipc)
                                          (KEY=<ipckey (PNPKEY is a standard key used)>)     
                                          )
                                     ]
                                     [ (ADDRESS=
                                          [ (COMMUNITY=<community_name>) ]
                                          (PROTOCOL=decnet)
                                          (NODE=<nodename>)
                                          (OBJECT=<objectname>)
                                          )
                                     ]
                                ... # More addresses
                                     [ ) ] # Optional depending on whether ADDRESS_LIST is used or not
                                     [ (CONNECT_DATA=
                                          (SID=<oracle_sid>)
                                          [ (GLOBAL_NAME=<global_database_name>) ]
                                     )
                                     ]
                                     [ (SOURCE_ROUTE=yes) ]
                                     )
                                     (DESCRIPTION=
                                     [ (SDU=2048) ]     # Optional, defaults to 2048
                                                    # Can take values between 512 and 32K
                                     [ (ADDRESS_LIST= ]     # Optional depending on whether u have more
                                                    # than one address or not
                                                    # If there is just one address, unnecessary
                                     (ADDRESS
                                          [ (COMMUNITY=<community_name>) ]
                                          (PROTOCOL=tcp)
                                          (HOST=<hostname>)
                                          (PORT=<portnumber (1521 is a standard port used)>)
                                     )
                                     [ (ADDRESS=
                                          (PROTOCOL=ipc)
                                          (KEY=<ipckey (PNPKEY is a standard key used)>)
                                     )
                                     ]
                                     ...           # More addresses
                                     [ ) ]           # Optional depending on whether ADDRESS_LIST
                                                    # is being used
                                     [ (CONNECT_DATA=
                                          (SID=<oracle_sid>)
                                          [ (GLOBAL_NAME=<global_database_name>) ]
                                     )
                                     ]
                                     [ (SOURCE_ROUTE=yes) ]
                                     )
                                     [ (CONNECT_DATA=
                                     (SID=<oracle_sid>)
                                     [ (GLOBAL_NAME=<global_database_name>) ]
                                     )
                                     ]
                                     ... # More descriptions
                                     [ ) ]     # Optional depending on whether DESCRIPTION_LIST is used or not

                                -----
                                listener.ora
                                -----

                                # copyright (c) 1997 by the Oracle Corporation
                                #
                                # NAME
                                # listener.ora
                                # FUNCTION
                                # Network Listener startup parameter file example
                                # NOTES
                                # This file contains all the parameters for listener.ora,
                                # and could be used to configure the listener by uncommenting
                                # and changing values. Multiple listeners can be configured
                                # in one listener.ora, so listener.ora parameters take the form
                                # of SID_LIST_<lsnr>, where <lsnr> is the name of the listener
                                # this parameter refers to. All parameters and values are
                                # case-insensitive.

                                # <lsnr>
                                # This parameter specifies both the name of the listener, and
                                # it listening address(es). Other parameters for this listener
                                # us this name in place of <lsnr>. When not specified,
                                # the name for <lsnr> defaults to "LISTENER", with the default
                                # address value as shown below.
                                #
                                # LISTENER =
                                # (ADDRESS_LIST=
                                #     (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
                                #     (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))     

                                # SID_LIST_<lsnr>
                                # List of services the listener knows about and can connect
                                # clients to. There is no default. See the Net8 Administrator's
                                # Guide for more information.
                                #
                                # SID_LIST_LISTENER=
                                # (SID_LIST=
                                #     (SID_DESC=
                                #               #BEQUEATH CONFIG
                                # (GLOBAL_DBNAME=salesdb.mycompany)
                                # (SID_NAME=sid1)               
                                # (ORACLE_HOME=/private/app/oracle/product/8.0.3)
                                #               #PRESPAWN CONFIG
                                # (PRESPAWN_MAX=20)
                                #     (PRESPAWN_LIST=
                                # (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
                                # )
                                # )
                                # )
                                     
                                # PASSWORDS_<lsnr>
                                # Specifies a password to authenticate stopping the listener.
                                # Both encrypted and plain-text values can be set. Encrypted passwords
                                # can be set and stored using lsnrctl.
                                # LSNRCTL> change_password
                                # Will prompt for old and new passwords, and use encryption both
                                # to match the old password and to set the new one.
                                # LSNRCTL> set password
                                #     Will prompt for the new password, for authentication with
                                # the listener. The password must be set before running the next
                                # command.
                                # LSNRCTL> save_config
                                # Will save the changed password to listener.ora. These last two
                                # steps are not necessary if SAVE_CONFIG_ON_STOP_<lsnr> is ON.
                                # See below.
                                #
                                # Default: NONE
                                #
                                # PASSWORDS_LISTENER = 20A22647832FB454 # "foobar"

                                # SAVE_CONFIG_ON_STOP_<lsnr>
                                # Tells the listener to save configuration changes to listener.ora when
                                # it shuts down. Changed parameter values will be written to the file,
                                # while preserving formatting and comments.
                                # Default: OFF
                                # Values: ON/OFF
                                #
                                # SAVE_CONFIG_ON_STOP_LISTENER = ON

                                # USE_PLUG_AND_PLAY_<lsnr>
                                # Tells the listener to contact an Onames server and register itself
                                # and its services with Onames.
                                # Values: ON/OFF
                                # Default: OFF
                                #
                                # USE_PLUG_AND_PLAY_LISTENER = ON

                                # LOG_FILE_<lsnr>
                                # Sets the name of the listener's log file. The .log extension
                                # is added automatically.
                                # Default=<lsnr>
                                #
                                # LOG_FILE_LISTENER = lsnr

                                # LOG_DIRECTORY_<lsnr>
                                # Sets the directory for the listener's log file.
                                # Default: <oracle_home>/network/log
                                #
                                # LOG_DIRECTORY_LISTENER = /private/app/oracle/product/8.0.3/network/log

                                # TRACE_LEVEL_<lsnr>
                                # Specifies desired tracing level.
                                # Default: OFF
                                # Values: OFF/USER/ADMIN/SUPPORT/0-16
                                #
                                # TRACE_LEVEL_LISTENER = SUPPORT

                                # TRACE_FILE_<lsnr>
                                # Sets the name of the listener's trace file. The .trc extension
                                # is added automatically.
                                # Default: <lsnr>
                                #
                                # TRACE_FILE_LISTENER = lsnr

                                # TRACE_DIRECTORY_<lsnr>
                                # Sets the directory for the listener's trace file.
                                # Default: <oracle_home>/network/trace
                                #
                                # TRACE_DIRECTORY_LISTENER=/private/app/oracle/product/8.0.3/network/trace
                                # CONNECT_TIMEOUT_<lsnr>
                                # Sets the number of seconds that the listener waits to get a
                                # valid database query after it has been started.
                                # Default: 10
                                #
                                # CONNECT_TIMEOUT_LISTENER=10
                                -----
                                am sure there is a problem with them files...
                                could anyone please tell what am doing wrong fillining this:


                                Connection Name: NewDatabase
                                Username: test
                                Password: test

                                HostName: localhost
                                Port: 1521
                                SID: xe

                                thank you!
                                • 28. Re: Unable to create new connection
                                  728539
                                  could anyone please tell me what is SID?
                                  how can i see the available SID?
                                  am using this command lsnrctl services and then the name of the SID to find out if exist or not
                                  could anyone please tell me how to see the available SID?
                                  1 2 Previous Next