Home » RDBMS Server » Networking and Gateways » Connect to remote database
Connect to remote database [message #66408] Sat, 25 May 2002 20:06 Go to next message
Tibor Bata
Messages: 2
Registered: May 2002
Junior Member
Hi,
I can connect to remote database with java : URL=jdbc:oracle:thin@host:1521:service_name. It works properly.
I can't connect with sqlplus. I tried create a new section in tnsnames.ora with service_name and host and connect : sqlplus username/passwd@service_name but it isn't work. The error message is : ORA-12154: TNS:could not resolve service name.
What do I make wrong?
Please help me.

regads
bata
control file [message #66409 is a reply to message #66408] Sun, 26 May 2002 21:08 Go to previous messageGo to next message
shailesh
Messages: 22
Registered: October 2000
Junior Member
as I am new in oracle pl let me know where is control files & database is stored
i required this because iwe are going to install oracle agent for external backup on dat drive

waiting for your valuable reply

shailesh
Re: Connect to remote database [message #66411 is a reply to message #66408] Mon, 27 May 2002 23:09 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
SIR,

THERE MAY BE A PROBLEM IN YOUR TNSNAMES.ORA OR
SQLNET.ORA FILE.THEN ONLY THIS PROBLEM WILL RISE.PLEASE
SEND THE TNSNAMES.ORA AND SQLNET.ORA FILE TO ME.

WAITING....

K.SREENIVASAN
Re: control file [message #66412 is a reply to message #66408] Mon, 27 May 2002 23:23 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
SIR,

ORACLE USING FOLLOWING FILES

1.PARAMETER FILE
2.CONTROL FILE
3.DATA FILE
4.LOG FILE(REDO LOG FILE,ARCHIVE LOG FILE)

THESE FILES ARE NECESSARY TO RUN A DATABASE

1.PARAMETER FILE
THIS IS THE FIRST FILE WHICH IS READ BY THE ORACLE DURING STARTUP.USING THE PARAMETERS IN THE FILE,IT WILL CREATE THE SGA FOR THE DATABASE.I.E WE HAVE TO SPECIFY THE SIZE OF THE SGA IN THE PARAMETER FILE.THAT FILE ALSO CONTAINS LOCATION OF THE CONTROL FILE

2.CONTROL FILE:
THIS IS VERY IMPORTANT FILE FOR ANY DATABASE.IT CONTAINS WHOLE STRUCTURE OF THE DATABASE LIKE NO OF DATAFILES,NO OF LOGFILES AND THEIR LOCATIONS AND DETAILS OF THE TABLESPACES,ROLLBACK SEGMENTS ETC.

3.DATAFILE:
ACTUALLY YOUR TABLES ARE STORED IN THIS FILE

4.LOG FILE:
THERE ARE TWO FILE
1.REDO LOG FILE
2.ARCHIVE LOG FILE

DURING ANY THNG HAPPENED IN THE DATABASE,THAT EVENT IS MARKED IN THE REDO LOG FILE.IT IS VERY USEFUL FOR THE HOT BACKUP PROCESS

IF YOU ARE GOING FOR THE HOT BACKUP,THEN YOU HAVE TO TAKE THE FOLLOWING FILE

1.PARAMETER FILE
2.CONTROL FILE ( AND ALSO GET ONE TRACE COPY I.E COMMAND TO CREATE THAT CONTROL FILE)
3.DATA FILE
4.ARCHIVE LOG FILE

ANY PROBLEM MAIL TO ME

K.SREENIVASAN
Re: Connect to remote database [message #66473 is a reply to message #66411] Thu, 27 June 2002 19:47 Go to previous messageGo to next message
thienbao
Messages: 1
Registered: June 2002
Junior Member
- how to connect to remote database in Oracle
- how to select remote data from another database in Visual Basic with Oracle database
Re: Connect to remote database [message #66779 is a reply to message #66411] Fri, 10 January 2003 05:53 Go to previous message
Danh Do
Messages: 1
Registered: January 2003
Junior Member
No Message Body
Previous Topic: Unable to configure listner in Personal Oracle 8i
Next Topic: installing Oracle9i
Goto Forum:
  


Current Time: Sat Mar 02 16:30:12 CST 2024