Installation of Oracle 10g
I have installed the Oracle 10g at the following location : -
C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
But I was trying to ping Oracle Client from Command Prompt. See Below : -
c:\Oracle>tnsping SONIA
ERROR IS COMING no listener
MINE tnsnames.ora File : -
Code:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SONIA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sonia)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SONIA)
)
)
What this error means??? Help me in connecting to the ORACLE 10g.
I have studied on the net that for Oracle to connect three ora files need to be there. But in my ADMIN Folder two files are created by Oracle Configuration Tools names SqlNet.ORA , TNSNAMES.ORA. LISTENER.ORA file is not created.
Re: Installation of Oracle 10g
The listener.ora is present on the oracle server.
you have listed the contents of your client directory.
C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
Re: Installation of Oracle 10g
Ask your dba to start the listener on the database server.
Re: Installation of Oracle 10g
I have installed the oracle 11g database server. Now when I am tryygin to PING, See Below : -
Code:
C:\Oracle>tnsping SONIA
I get the following message.
Use HOSTNAME Adapter to resolve the alias.
Attempting tp contact <DESCRIPTION - <CONNECT_DATA_<SERVICE NAME ->><ADDRESS-<PROTOCOL=TCP><HOST=127.0.0.1><PORT=1521>
OK <20 msec>
I think so, oracle is working Now, If I am not wrong. But I am not getting where to write the QUERY to CREATE TABLE.
Re: Installation of Oracle 10g
Quote:
Originally Posted by
sonia.sardana
I have installed the oracle 11g database server. Now when I am tryygin to PING, See Below : -
Code:
C:\Oracle>tnsping SONIA
I get the following message.
Use HOSTNAME Adapter to resolve the alias.
Attempting tp contact <DESCRIPTION - <CONNECT_DATA_<SERVICE NAME ->><ADDRESS-<PROTOCOL=TCP><HOST=127.0.0.1><PORT=1521>
OK <20 msec>
I think so, oracle is working Now, If I am not wrong. But I am not getting where to write the QUERY to CREATE TABLE.
Have you tried to fire up sqlplus? If you installed the oracle client, you should have also got sqlplus installed. How are you connecting using sqlplus?
You need to write your create table statements in sqlplus.
Re: Installation of Oracle 10g
I have installed SQL Plus .
In SQL Plus User Name :- SYS . What is the Default Password & Host String to get into the database?
Re: Installation of Oracle 10g
Quote:
Originally Posted by
sonia.sardana
I have installed SQL Plus .
In SQL Plus User Name :- SYS . What is the Default Password & Host String to get into the database?
The host-string would depend on your entry in the tnsnames.ora file.
To give you an example, the entry in my tnsnames.ora looks like this.
PHP Code:
designdev=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP)(HOST=oracledb.unixmac.com)(PORT=1522))
(CONNECT_DATA= (SID=designdev)))
For this particular entry, I use designdev as my host.
Also from what I recall, there is no password setup for sys and system, when you do a fresh install. I could be wrong and things could have changed since Oracle 8i.
