problem in creating databse

[amolso]

Hello

I have Oracle database 8.1.6 on windows NT Server named 'ODBK'
I wanted to create a new database for my another project.

I have just created a new database in Oracle using DBCA.
First I shut down the database using SVRMGR
and then entered 'STARTUP NOMOUNT'
I have created this database useing custom installation as I wanted
it to be created into another drive 'H:'.

I did not choose dedicated server mode in my custom rather went for
shared server mode.

I named it 'DBKT'. For all the dbf log and files which are to be created
in new db I set path to 'H:\Oracle\....'

IT took more than 3 hours for creattion of database. But there was no error
till that time.

However when I tried to connect to my default database it was not connecting.
using scott/tiger. to which it prevoiusly used to connect

I then used at commnad prompt 'Set ORACLE_SID = ODBK'
Then I used sqlplus scott/tiger which then successfully connected to my database

I opened another dos prompt where I used 'set oracle_sid=dbkt'
where it got connected to.

However Thru my GUI interface connectivity to Database I am not able get connected
to my old database
It shows me regular box of username, password, hostname
but even after writing every thing properly it is not connecting
saying TNS service name not found
I even entered ODBK sometimes in host but still it's not working
what can I do get it connected in my regular widows SQL prompt

Amol

 

[dbachpb]

Looks like your sqlnet was not configured for your new database.
Look at the tnsnames.ora file in your $ORACLE_HOME/network/admin directory, you should see an entry for your new database. If you don't, you can add it with sqlnet easy config or edit the file manually.
Also make sure your ORACLE_HOME points to the right directory.


Hope this helps

 

[THoey]

I agree, look at the TNSNAMES.ORA file. In my case, I noticed that the database name was changed to TCSV.SBC.COM instead of just TCSV. If I used TCSV.SBC.COM in my connect string, it worked.

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[amolso]

Hello Friends

Change in registry did work.

Can you tell me how to get connected to the new
database in the same windows, As I am entering
host string as new database name but still it is not connecting.
Again if I say Set oracle_sid= newdb on DOS prompt and from then I connect then it is working
I checked my tnsnames.ora file which do contain
SERVICE_NAME = newdb with host ip and port no
1521. Where exactly I am going wrong
Amol

 

[dbachpb]

I would like to see yout sqlnet.ora and tnsnames.ora files.
You may want to look at the sqlnet.ora to see if there is a default domain name.
Also, do you get the same error message or a different one, and if so i would like to its description.
Also, you need to configure your listener to listen for the new instance. Look at the listener.ora file or try tne command : $ORACLE_HOME/tnsping (or tnsping80) connect_string
where connect_string = to your database connect string as defined in your tnsnames.ora. If tnsping work, then your networking is setup correctly.

 

[matrixcd]

There is some other thing you might check
1. The Listener.ora should have the new database add to it.
2. Did you create a services for the new database that will start on reboot. Locate in Control Panel|Services
3.You can connect via the GUI by also entering the connect string that was add to your tnsnames.ora file.
4. By changing the registry entry only set that as your default database during boot and connect without using the connect string.
5. You can also set the Oracle Sid and Oracle Home as default by setting it into you environment setting. Located in under the Control Panel|System|Environment

 

[amolso]

Hello

In my tnsnames.ora file connect string is DBKT
tnsping DBKT not working again the same error
TNS-12535 TNS operation timed out

While Creating Database DBCA Asked me a Choice
LISTENER or LISTENER1
I Chose LISTENER1
Now I checked In my Listener.ora file

There are entries of two listeteners
LISTENER and LISTENER1

The new database setting is in LISTENER1

My LISTENER contains a connection to default database and extproc setting which are default
DO I have to modify my LISTENER and add connection to new databse also by forgetting LISTENER1 Setting ?

However I am Also having a connection string for one of my remote databases in tnsnames.ora . I can connect this database thru windows entry screen by entering connection string in host string column . However even after setting similar setting for new database (which are done by system in tnsnames.ora) I am not getting connectivity to new database. Can you please tell me settings in listener.ora ?

Amol