Home » SQL & PL/SQL » SQL & PL/SQL » Unique ID for a server
Unique ID for a server [message #319] Tue, 05 February 2002 11:47 Go to next message
Ron Olshavsky
Messages: 1
Registered: February 2002
Junior Member
Hey There,

Im in the process of designing a licensing system for a product using an ORACLE backend, and need a way to uniquely identify the machine that Oracle is running on from within an ORACLE trigger/proecedure.

Cant seem to find anything online, and hope that someone here might know of a way...

Doesnt need to be Mac address level or anything...just some way to derive a unique ID signature that cant be duplicated if the system is installed on another box..

Thanks for any input
Ron Olshavsky
Integrated Chipware
Re: Unique ID for a server [message #320 is a reply to message #319] Tue, 05 February 2002 12:03 Go to previous message
Messages: 417
Registered: September 1998
Senior Member
Have a look in the tnsnames.ora file and you will see how your DB is identified.
It's often the server name, the port number and the database name which identifies the database over the network.

Previous Topic: Tune This Simple SQL
Next Topic: Stored Procedure Problems
Goto Forum:

Current Time: Fri Sep 22 13:53:48 CDT 2023