You will need a TNSNAMES.ora file for the Star Schema to function properly:
If it exists, you can continue to the next section.
If it does not exist, you will need to create it.
STARDW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <portnumber>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <ServiceName>)
)
)
where hostname is the IP address or name where the Star database is installed, portnumber is the port number where the Star database is installed, and ServiceName is the service name you used when you installed the Star database
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014