Oracle

I have oracle 9i running at home. How do i connect from Access 2003 to get the sample data. I want to know all the tables in my oracle.
ittechlabLinux SupportAsked:
Who is Participating?
 
hardikbeitConnect With a Mentor Commented:
If u want to use sys login then
From command prompt:
userid: sys as sysdba
password: ***
Host string: computername

From sql*plus:
username: sys/password@hostString as sysdba

If u didn't change your system password after installation then it is: system/manager@hostString..
0
 
oaksongCommented:
YOU MUST HAVE A TNSNAMES FILE in the Orcale Network/admin directory it should use 127.0.0.1 as the address. Use the name of the Orcale database.

Create an Accesss MDB File.
Right click in the tables window and select LINK
In the selection dialog scroll to the bottom of the list of file types and select ODBC.
Select SYSTEM DNS
Locate the ORACLE driver in the list of available connectors. And click OK
Enter a name for the DSN. Select the TNS name from that you created earlier from the drop down.
Click OK.
You'll need to provide your Oracle admin ID  and password.
Select the tables you want to LINK to and click the REMEMBER PASSWORD box.

Done
0
 
ittechlabLinux SupportAuthor Commented:
This is what i see.

# TNSNAMES.ORA Network Configuration File: I:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lanka01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ittech)
    )
  )

ITTECHLAB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lanka01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ittech)
    )
  )
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
oaksongCommented:
Then you should see ITTECHLAB in the drop down list in the dialog in ODBC mentioned earlier.
Have you tried the process I outlined?
0
 
hardikbeitCommented:
Your tnsname.ora file contains the entries to connect the databases which you want.

As per your tnsnames.ora file,
Please check:
ITTECHLAB = --this is your dblink or host name
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lanka01)(PORT = 1521)) --please check hostname/port is correct?
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ittech) --this is your Database name which must be same as init.ora's DBName parameter.
    )
  )

You can connect your database if all the entries are correct..
ex: connect scott/tiger@ittechlab from SQL*Plus --this '@ittechlab' is your dblink name.
0
 
ittechlabLinux SupportAuthor Commented:
i am trying to login to sqlplus and i typed the following info.

userid : system
password : ****
host string: computername

i am getting the following error .
invalid password or username.

if i type the following username

sys
***
then i get ORA-28009: connection to sys should be as sysdba or sysoper. can someone advice. I even change the Password from oem gui. still same error.
0
 
ittechlabLinux SupportAuthor Commented:
i am trying to login to sqlplus and i typed the following info.

userid : system
password : ****
host string: computername

i am getting the following error .
invalid password or username.

if i type the following username

sys
***
then i get ORA-28009: connection to sys should be as sysdba or sysoper. can someone advice. I even change the Password from oem gui. still same error.
0
 
ittechlabLinux SupportAuthor Commented:
Thanks for all your answers. Its works now. I want to know if someone can advice if theres any site or document for oracle administration. I am looking sql command which shows certain admin stuff. For examples if i want to see who is currently logged in? , what is the parameter files contains. Reading the control file from sql? can someone advice thaanks.
0
 
oaksongCommented:
If you're just messing around, I'd download the latest edition of Oracle from their web site and use the new browser interface to access the database. It takes a much smaller learning curve than getting up to speed on the command line interface. The download is free.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.