Cant connect to database on my home network

[mcowen]

Hi,

I have 2 machines, one running win98 and the other running win2k. I am trying to connect to a database on the win2k machine but all I ever get is TNS error: no listener.
I have Oracle Personal Edition 8.1.5 and Net8 installed on both machines. The parameters in the Listener seem correct; protocol is NMP (i have also tried TCP/IP) but no joy. Any pointers would be appreciated.

Thanks.

 

[rcurva]

Did you check if the listener is started? Make sure that the listener is running forst before you proceed to tns connection. Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[mcowen]

Hi Robbie,

Still got problems....

Because I have been trying to connect in both directions I have started LSNRCTL on both machines. Neither see each other - either I get TNS no listener or protocol adapter error. I have checked the network and tried different protocols.
Fifi to Greg:
The connection on FIFI would be TCP/IP, HOST: GREG, PORT 1521, service name gregdb.greg
My listener on Greg should be TCP/IP HOST: GREG, PORT 1521

What am I missing?

Regards
Matt

 

[lfoata]

I believe (not 100 % sure) that you cannot connect remote with personal Oracle. It is meant to be installed and used on a single machine (thats why it is called personal). Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA

 

[mcowen]

I have successfully done this before but not this way round.

After some keyword searching I have been able to tweak things to such an extent that I now get the following when I tnsping:
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521))
TNS-12535: TNSperation timed out

Neither direction between my 2 machines will except this TNS. Am I missing something with my net protocols?

Thanks

 

[rcurva]

To solve your current problem, update your listener.ora parameter CONNECT_TIMEOUT_LISTENER=0 to make it unlimited.
Restart your listeners again.

If this does not work, then there might be truth about lfoata's post.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[rcurva]

I checked this one from Metalink, it doesn't hurt if you try this one too.

1. Remove the following entry from the registry:

HKEY_LOCAL\SOFTWARE\ORACLE\LOCAL

2. Also check the following optional Windows NT Registry entry and make sure that if it exists it is set to ORACLE (the default password for Personal Oracle):

LOCAL\SOFTWARE\ORACLE\DBA_AUTHORIZATION


Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[oracle8]

Check your tnsnames.ora on your workstation your connect string should have this parameters:

SAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.7 or
host computer name)
( PORT = 1521))
(CONNECT_DATA = (SID = Database Name))

Hope this help.

 

[mcowen]

Thanks all,

I have tried all of Robbies pointers but no luck so far. The SID in the previous post is no longer required after 8.1.x dbs. Instead it has an Instance name and Service parameters. Does anyone have an example of what theirs looks like.

Cheers
Matt

 

[jee]

I too run Personal Oracle (8.1.7) on Windows 2000. There is no reason you cannot connect to PO remotely - it is just a license thing. According to the license, administrators can connect to PO remotely for administration tasks. However, nothing in PO prevents any user from connecting remotely - I do it all the time.

The entry for PO in the TNSNAMES.ORA file on my client looks like this (I am using TCP protocol):

GRAFIC-JANE.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = GABYJE)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = GRAF)
    )
  )
[\code]

This LISTENER.ORA file on my "server" looks like this:
[code]
PASSWORDS_LISTENER= (oracle)

STARTUP_WAIT_TIME_LISTENER = 0

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = GABYJE)(PORT = 1521))
      )
    )
  )

CONNECT_TIMEOUT_LISTENER = 0

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = graf)
      (ORACLE_HOME = C:\Oracle\ora81)
      (SID_NAME = graf)
    )
    (SID_DESC =
      (SID_NAME = EXTPROC)
      (PROGRAM = EXTPROC)
    )
  )

TRACE_LEVEL_LISTENER = off
[\code]

Finally, you may need a SQLNET.ORA file on your client. Mine looks like this:
[code]
LOG_DIRECTORY_SERVER = C:/ORACLE/ORA81/NETWORK/LOG
AUTOMATIC_IPC = ON
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
NAMES.DIRECTORY_PATH = (TNSNAMES)
SQLNET.CRYPTO_SEED = "-14816753241163784956"
SQLNET.EXPIRE_TIME = 15
TRACE_LEVEL_CLIENT = OFF
[\code]