| Connect to remote database [message #66408] |
Sat, 25 May 2002 20:06  |
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  |
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 |
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 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
