04-16-2012
Hi,
If you get connect runing "sqlplus / as sysdba" so you are connected with dba role, you can add data file.
the message "connect to an idle instance" is because you instance is down, run startup to start the instance.
If a datafile is missing or been corrupted the instance will show a message, restore datafile from your backup and apply archived logs, if necessary.
Quim&r@
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
not required this time (36 Replies)
Discussion started by: Sandeep_Malik
36 Replies
2. Shell Programming and Scripting
Hi all,
I m new to shell programming..Can anyone please guide me how to insert data at a specified location in the file..
I have a configuration file..I want to add data to it through script..I am able to do it...I get that data written at end of my configuration file..I want data to be placed at... (3 Replies)
Discussion started by: divya_flora
3 Replies
3. Shell Programming and Scripting
Hi,
I have one file a.txt ,the contents of the file is
A B C
D E F
and I have another file b.txt, the contents of the file is
1 2 3
4 5 6
now when I am using this command
cat a.txt b.txt > c.txtI am getting the output as
A B C
D E F
1 2 3
4 5 6
but i need the output... (2 Replies)
Discussion started by: prarat
2 Replies
4. Shell Programming and Scripting
HI ,
I have a file with multiple lines like below, I need to check on column starting with #prototype if it has the .Number.txt extension do nothing else add 1.txt extension.
Source data
Jdbc_app_data :- sample data
#prototype= sample data from test.1.txt
application_id=122135... (4 Replies)
Discussion started by: gaur.deepti
4 Replies
5. Shell Programming and Scripting
Hi All,
how can i edit my original data and add more data if my 2nd script outputs SUCESS?
ex.
input file:
1.txt
nik,is,the
1script.sh
if 2ndscript.sh output SUCCESS then i'm going to edit my input file and add data best,pogi..
sample outputdata.
nik,is,the,best,pogi
2ndscript.sh... (3 Replies)
Discussion started by: nikki1200
3 Replies
6. Shell Programming and Scripting
Hi.. I'm into a bump after trying to solve this prob.. i've a file with contents like below.
<blankline>
'pgmId' : 'UNIX',
'pgmData' : 'textfile',
'author' : 'admin',
.......
Now i'm trying to insert a new data after pgmId. so the final output will be... (7 Replies)
Discussion started by: arjun_arippa
7 Replies
7. Shell Programming and Scripting
I collect data in a file in below format(Month Day Year Size) in RedHat Linux. Now i want to calculate the data size date wise. As i code shell script after long time, i forgot the features and syntax. Can anyone help me regard this please.
Feb 8 2014 15
Feb 10 2014 32
Feb 10 2014 32
Feb 12... (2 Replies)
Discussion started by: makauser
2 Replies
8. AIX
I desperately need help converting ascii data file generated on AIX platform that contains dollar sign ($) at the end of each line in the data file as shown below.
ME570^0128237^HG278999^20140805:21:00:00^BEENZ001^$
This is the AWK command for adding CR to the new line.
awk... (1 Reply)
Discussion started by: cumeh1624
1 Replies
9. Shell Programming and Scripting
Dear Gurus,
I have a file which comes every day with set of data, as a part of processing i want to add a comment at the start of every line.
e.g of file
<PCL>
2E;"HCA";"COP Car A";"ODBS_CFG"
7C;"DD";"Doors Car D";"ODBS_CFG"
3D;"XA";"Auxiliary Car A";"ODBS_CFG"
3E;"XB";"Auxiliary... (12 Replies)
Discussion started by: guddu_12
12 Replies
10. UNIX for Beginners Questions & Answers
I have an array in an external file, "array.txt", which contains:
char *testarray={"Zero", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine"};I want to be able to add an element to this array, and have that element display, whenever I call it, without having to recompile... (29 Replies)
Discussion started by: ignatius
29 Replies
LEARN ABOUT PLAN9
asadmin-stop-instance
asadmin-stop-instance(1AS) User Commands asadmin-stop-instance(1AS)
NAME
asadmin-stop-instance, stop-instance - stops the specified server instance and all the services associated with it
SYNOPSIS
stop-instance [--user admin_user] [--password admin_password] [--host local_host] [--port 4848] [--local=false] [--domain domain_name]
[--secure|-s]instance_name
Use the stop-instance to stop the instance with the instance name specified. The stop-instance can be run both locally and remotely. The
named instance must already exist within the given domain; and the instance must be running.
OPTIONS
--user administrative user associated for the instance.
--password administrative password corresponding to the administrative user.
--host host name of the machine hosting the administrative instance.
--port administrative port number associated with the administrative host.
--local determines if the command should delegate the request to administrative instance or run locally.
--domain name of the domain.
--passwordfile file containing passwords appropriate for the command (e.g., administrative instance).
--secure if true, uses SSL/TLS to communicate with the administrative instance.
OPERANDS
instance_name name of the instance to be stopped.
Example 1: Using stop-instance in local mode
asadmin> stop-instance --local --domain domain1 server1
Instance server1 stopped
Where: the server1 instance associated with the domain1 domain is stopped locally.
Example 2: Using stop-instance in remote mode
asadmin> stop-instance --user admin --password bluestar --host localhost --port 4848 server1
Instance server1 stopped
Where: the server1 instance associated with the named user, password, host and port is deleted from the remote machine.
EXIT STATUS
0 command executed successfully
1 error in executing the command
INTERFACE EQUIVALENT
Server Instance page
asadmin-delete-instance(1AS), asadmin-start-instance(1AS), asadmin-create-instance(1AS), asadmin-restart-instance(1AS), asadmin-start-
appserv(1AS), asadmin-stop-appserv(1AS), asadmin-start-domain(1AS), asadmin-stop-domain(1AS)
J2EE 1.4 SDK March 2004 asadmin-stop-instance(1AS)